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.
How do I correct this, and keep that unchanged?
Solved! Go to Solution.
Hi @Pratyay_Rakshit
Is the USERMAIL() set as the the Inital value ?
Hi @Pratyay_Rakshit
Is the USERMAIL() set as the the Inital value ?
No, itโs within the โFormulaโ field, not initial value.
Is it so that setting it to initial value rather than column formula will solve my problem ?
Yes, Did you try it?
Thank you. Itโs solved.
Hi everyone!
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.
Any ideaโs?
(Useremail() is in initial value)
@Liam_Tennis
You need to set the RESET ON EDIT propety to ON so that everytime the record is edited, the initial value will be resetted.
Thank you for the swift response! that solved the problem!
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |