Used below expression in TODO table.
I wnat it updated Only if login user email matchs owner column value(email type)
Test shows good, but applying & saving does not work correctly.
SWITCH(USEREMAIL(),[owner], “ALL_CHANGES”,“READ_ONLY”)
ANy idea???
Thanks in advance.
If you are looking for each row level control of update/delete rights through row level column values in [Owner] column , please do so in actions settings.
The changes you are making are at table level ( for all rows) and not each row level. " Add" permissions are at table level, so “Add” permissions you will need to control from the Data → Table → Are Updates Allowed option. However you cannot refer row level values there.
Control add, update, and delete operations - AppSheet Help
1 Like
yes, you’re right.
Expression is very ambigious : [owner] in table level.
Thanks
1 Like
You can use the an expression like below in delete and edit system actions’ **"**Only if this condition is true" setting for row level control of edit and delete.
[Owner]=USEREMAIL()
1 Like