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.
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.
"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."
How can I do this?
I need that some table_form, not be editable ("READ ONLY") when [status] be "Ready".
Use an expression like [Status] <> "Ready"
in the Only if this condition is true property of the action you want to prohibit (e.g., the Edit action) for a row with that value. To preclude editing individual columns, instead use the expression in each column's Editable property.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |