Error on switch function for table restrict updates

Hi,
I want to restrict updates of table only for rows made by current user.
when I use the this expression :

SWITCH(USEREMAIL(), [Email], “ADDS_AND_UPDATES”, “READ_ONLY”)
The switch expression pass the “test” but when saving I get this error:

This is true for any column name I use ,not just [Email].

If I dont use [column] e.g specific email or any other text there is no error, so I suppose the error might be a bug with [column]?
I checked it also with adhock app i created only to test this issue : NewApp-153182-21-03-27

Solved Solved
0 2 188
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

This is not possible using the Are updates allowed? setting for a table. Instead, you’ll have to add the necessary logic into the Only if this condition is true expression for the Add, Delete, and Edit system-generated actions for the desired tables.

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

This is not possible using the Are updates allowed? setting for a table. Instead, you’ll have to add the necessary logic into the Only if this condition is true expression for the Add, Delete, and Edit system-generated actions for the desired tables.

Got It. Works fine:)
Thanks a lot Steve!

Top Labels in this Space