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?
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |