Updates Allowed Formula

[juanpa]

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

[Steve · Accepted solution]

juanpa:

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?

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.

[Marco_Nietto]

"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".

[dbaum]

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.