Create a New User Record on App Startup

[rufusp]

I use a User Control Table to control access to data in my AppSheet app. I use slice on the user control table to filter to the currently logged-in user to read various access permissions and parameters. If the user record exists in the control table the app works fine but If does not exist the form displays no items selected. How do I get the app to create user record for the current user if one does not exists.

Thanks!

[AleksiAlkio]

i assume this situation probably happens when the app user opens the app at the very first time. You could write an expression with the starting view if the user exists or not. If it doesn't, show a form view to add basic information, maybe with not editable initial values.

[rufusp · Accepted solution]

Thank you for your response, Aleksi. The solution posted by 12seth12 in this post worked for me https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Trigger-action-when-a-new-user-uses-the-App/m-p...