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.
Solved! Go to Solution.
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
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
yes, you're right.
Expression is very ambigious : [owner] in table level.
Thanks
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()
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |