Users enter their expenses in a sheet, where there is a column with formula useremail() to log that user’s e-mail and a name column which is a bunch of ifs, like ’ if usermail()=“firstname.lastname@example.org”, then user_name = “abc” '.
There is an action for that table, unavailable to the user who posted the data, available to an ‘approving person’ / ‘moderator’ to mark that expense valid. Its a type of ‘set some values of columns to this’.
What the problem is, when the moderator is approving or rejecting that expense, the useremail() column gets updtaed with the e-mail of the moderator. Which is a HUGE problem in the mechanics of the whole app.
How do I correct this, and keep that unchanged?