Add User ID to Actions

Probably another very easy question for the pros here…

I’ve dialed in a lot of things in my app, and am now trying to add the user functions…

I made a new table with user emails, user names, user IDs, and phone numbers. I added a column for user name in my main table that receives all the edits. I made the “user name” column in the user table a “ref” type, and the name column in the main table automatically added the formula “USERNAME().”

My hope was that whenever someone on the list of users made an edit, that it would add their name to that main table, but it is not working. Also, when I go to my actions to try and manually add that column to my actions (“set the value of some columns in this row”), the option to manually set “user name” does not show up…

I’m very new to AppSheet in general, but to working with REFs specifically…

Thanks for taking a look!

It is highly advised to NOT user USERNAME(). USEREMAIL() is the better expression to use.

It won’t list columns that aren’t editable. Having an App Formula in a column makes it not editable, this may be your case here.

1 Like