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()=“abc@xyz.com”, 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.
I have the opposite problem now where a different user is making an edit but the useremail stays the same as the old person and is not updating to current person submitting the edit.
