Prevent record editing when field contains x value

[Donny Limbert]

Is it possible to prohibit record editing when a field matches X value? For instance, a field named "Status". When the Status field contains "completed" is it possible to prevent editiing ANY field in that record from that point forward? For some reason, having a hard time figuring this one out.

[Kris M]

check security settings in manage>>security>>privelege sets>>edit privelege set>>records>>custom priveleges>>edit>>limited. That is where you can restrict editing of a record based on the result of a calculation. You can also perform restriction using interface elements i.e hiding controls from users or performing calculated validations using script triggers and such but their are important issues to consider when using interface based pseudo security devices/methods.

[Steven H. Blackwell]

A reminder to all that the User Interface is not part of the Security schema.  It should not be used for that purpose.  Doing so introduces a major vulnerability that can serve as the attack vector for exploits against the file.

 

Use Record Level Access and the other privileges defined in the Privilege Set.  That is why they are in the application.

 

Steven