ACL depending on value on a field

[CE_]

Hi,

ACL's always get me confused. I have 5 different tables where records should be "read only" if the field "source" has value "X". But if it's not value "X" it should not be read only. So I guess I need to create a write ACL for all of these tables with an advanced script condition? How should this be configured? Thanks!

[Muhammad Khan]

Try creating ACL with below configurations.

Type: Record

Operation: Write

Name: "Your table"     -- None --

Condition: "Your Field"  "is not"  "X"

Once done, verify with non-admin users because there is a check box Admin overrides on ACL record which allows admins access irrespective to conditions.

If these tables do not have any extension (not extended from each other) relationship, then you might have to create an ACL for each table.

Note: If there is an out-of-the-box write ACL, you might have to deactivate it.

[CE_]

Thanks, I'll try this. How about the roles? 

[Muhammad Khan]

If you want to restrict via roles as well, then you can add roles as well.