Skip to main content
Question

How would I specify a form rule to make all fields in a record read only on fulfillment of a condition, without specifying each field individually? The record has about a 50 odd fields.

  • April 21, 2014
  • 0 replies
  • 49 views

How would I specify a form rule to make all fields in a record read only on fulfillment of a condition, without specifying each field individually? The record has about a 50 odd fields.
This topic has been closed for replies.

No problem.

Change the role permission to remove the ability of that role's users to edit record if that condition is true.  If the condition is complex with ANDs as well as ORs, then make a formula checkbox field called [Editable?] to evaluate the condition and then make your role permission custom rule based on that field being unchecked.

  • Registered
  • April 21, 2014
Use script with the image onload technique:

Pastie Database

https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=263

What don't I learn to check this before I create a rule and set each field to read only! Argghhh ... so simple! Thanks Mark