Hello,
I shared my app in another email account so I can test with two separate users. I made this column “Useremail” because I need it for security filter. When I make request using another email, it gets the useremail. But when I open the app with the original email acct I’m using (which reflects all forms made by other account), the useremail then gets changed to this email. The result (because of the security filter), the original requestor doesn’t display the form because the “useremail” was changed. How can I stop that? I hope the wordings of my problem is making sense. Please help! Thanks!
What is the exact definition of this useremail column? Why does it get changed when a row is opened by another user?
2 Likes
Sorry Sir, wdym when you say ‘exact definition’? Are you asking for what purpose am I using it? I added the column ‘useremail’ to get the user’s email when making request forms because I needed to filter data for each users. This is how I set this column.
put the expression in the Initial value of the column. that way, the column get the email of the user who created it and never gets updated (unless manually modified)
https://support.google.com/appsheet/answer/10106437?hl=en
4 Likes
This was it! Thanks a lot Sir!
1 Like
