Make entire form not editable based on dynamic rule

Question

Is it possible to lock a form from being edited, based on a dynamic rule? Or do I have to individually select every field to be read only?

------------------------------
Michael Tamoush
------------------------------

markshnier__you · Answer

You can use roll permissions to lock a record for editing. Make a formula field that determines whether or not the record should be locked for editing and use that as a custom permission rule.

but other than that if you want to prevent all the fields on a form from being edited then he would need to lock them one by one in a giant form rule.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

11013 · Answer

Hi, MarkI've seen many solutions from you and I was wondering if you could give me some guidance. I am wanting to prevent editing of a record on a particular form if a) the user is the record owner and b) if a particular field has a particular value (e.g., relation to head of household = "self"). I can do this field by field using a dynamic form rule, but there must be a more elegant solution.I'd appreciate your thoughts.Thank you in advance

markshnier__you · Answer

np,Your instincts were correct. Yes there is a better way. You're not really trying to prevent editing of certain fields on the form you're really trying to prevent the editing of a record. So that would go back to the role permissions for the role that the user is in. You can set up a custom permission rule for modify. If the native drop downs for how you can configure the custom rule aren't flexible enough for you then you can always make a formula field called&nbsp; [Allowed to edit?]&nbsp; .... and then you can get crazy complicated with your formula. Then base the Role Custom Permission rule based on that one checkbox field.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

11013 · Answer

Please disregard my question. I considered your earlier suggestion regarding formula field and that was my solution. Thank you

Forum Discussion

Make entire form not editable based on dynamic rule

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Dynamic Rule - Or statement?

Child Table - Grid Edit Issues

Formula URL - Edit then Add