Very new to appsheet… just about 1 week old.
I have a very simple form. My users can add or modify the data in the form.
I’m using a field called LoginID = USEREMAIL() to see who is making changes to the data.
I also would like to capture who is adding the data.
So for example, User 1 creates a record. it is captured as his loginid
now if user 2 changes the record, the loginID changes to user2 id
similarly for user3 it changes to user3 id.
I would like to keep the login id of user1 but would also like to capture the login Ids of users who are making the changes. Not more than 3 users will be working on row of data.