Are updates allowed? SWITCH expression stopped working 4Sep2020

This expression was implemented on 26Jun2020 and was working until a user got an error message on 4Sep and the expression was deleted.

SWITCH(LOOKUP(useremail(),Employees, “EmployeeID”,”role”)
“IT Admin”,”ALL_CHANGES”,
“MD”,“ADDS_AND_UPDATES”,
“READ_ONLY”
)

How can I revise the expression to control update permissions based on the user’s “role” in the Employees table?

0 4 508
4 REPLIES 4
Top Labels in this Space