Storing user email in database table

Couldn't find any topic around this. I am trying to store email of the user that logs in to my app. Tried with the Actions + Automation using "Data: add a new row to another table using values from this row" but couldn't get it to work. My Users table is still empty.... I am probably doing something wrong? Is there any easier way to achieve this?

Solved Solved
0 3 431
1 ACCEPTED SOLUTION

I am not aware of a built in way to register a user the first time they visit the app. The way to possibly go about this yourself is to start the app with a form view for registration and then make everything else inaccessible unless your email shows up in this registration table. This could be accomplished through datasource security filters and 'show if' conditions within the other views of the app.

View solution in original post

3 REPLIES 3

If you are not getting any rows at all, then please yes, there must be something wrong within the process you have built.  Please show us your actions and automation. 

Do note that all processing must be triggered off of user activity ( the only exception are Scheduled automation) - i.e. a button tap, Form Save, selecting row, etc.  Please indicate how your process to add to the Users table is being activated.

Thanks for reply, so there is no way to add/register user on the first app visit for example? User needs to actually click or do some action for automation to fire? What about the first time the user needs to accept the "terms" of the app, where it says that app might collect user activity? Is there some kind of event? Is there even difference between App and AppSheet data base as user source? In both cases I see only my own tables and are able to trigger the event when data changes (add,delete,update).

Screenshot 2024-07-22 at 21.56.58.png

I am not aware of a built in way to register a user the first time they visit the app. The way to possibly go about this yourself is to start the app with a form view for registration and then make everything else inaccessible unless your email shows up in this registration table. This could be accomplished through datasource security filters and 'show if' conditions within the other views of the app.

Top Labels in this Space