Are update allowed not working

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