Are update allowed not working

[kjkim]

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.

[Suvrutt_Gurjar · Accepted 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

[kjkim]

yes, you're right.

Expression  is very ambigious : [owner]  in table level.  

Thanks

[Suvrutt_Gurjar]

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()