Save last user that changed a record in a table

[James_McFarlane]

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

[Jonathon · Accepted solution]

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

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

[BobRoyAce]

Doesn't this only work, when initially adding the record? What about when users make subsequent edits?

[James_McFarlane]

Thanks Jonathon!

That did the trick.

[Aleksi]

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