In “Are Updates Allowed” I’m usign the following formula:
IFS(CONTAINS(LOOKUP(USEREMAIL(),“Members”,“Email”,“Roles”),“Administrator”),“ALL_CHANGES”,CONTAINS(LOOKUP(USEREMAIL(),“Members”,“Email”,“Roles”),“Event Creator”),“READ_ONLY”,CONTAINS(LOOKUP(USEREMAIL(),“Members”,“Email”,“Roles”),“Event Handler”),“UPDATES_AND_DELETES”)
When the user is an Event Handler, I also need the formula checks in the table Members if this specific user can edit a specific event (The event that the user can edit is in a Event ID column in the Members table). Is there any way to do this?
Thanks
Solved! Go to Solution.
The settings for Are Updates Allowed? apply to the entire table as a whole; they cannot be used to control access to select rows within the table.
You can impose row-level access control using the Only if this condition is true expression for the table’s system-generated Add, Delete, and Edit actions in Behavior >> Actions.
User | Count |
---|---|
43 | |
34 | |
24 | |
23 | |
15 |