save email of who modifies data in my app.

[mauricio_aello]

Hello, I am trying to save the email of the person who modifies a record. or change its status, for example from "Pending" to "Finished", thank you very much.

[SkrOYC]

https://support.google.com/appsheet/answer/10108210?hl=en

https://support.google.com/appsheet/answer/10106509#reset-on-edit

[mauricio_aello]

Thanks a lot , i already using that function to record who are the creator of the entry , but i wish to make a registry of the user that modifies an entry already existing.

[SkrOYC]

The second link talks about Reset on edit, the info about it in the docs is very low.

In general, it means that you can make a column with an Initial Value expression (like [ModifiedBy]) to change everytime there is an edit and reset to the Initial Value expression result.

It's similar to an App Formula on real column. Btw, @Steve you know any difference between reset on edit vs AppFormula on real column?

[Steve]

In this case, I myself would use App formula.