Save last user that changed a record in a table

Hi Appsheet community,

In our app we would like to get the last user that made a change to any field of a record and save their email to the column called UserModified. I looked at the change counter and changetimestamp but I have not been able to work out a logic to get the user that made the change.

regards,

James

in the UserModified column, set the initial value to USEREMAIL()

Then, toggle the ‘Reset on edit’ to on:
image

5 Likes

Thanks Jonathon!

That did the trick.

1 Like

Another way… write the USEREMAIL() to App formula and it will save a new value every time when you add or modify that record.

3 Likes