Forum Discussion

MiriamKlugman's avatar
Qrew Member
2 years ago

Allow only one field to be edited in Custom Data Rule

I want to make a custom data rule that would allow only field to be edited based on my condition.
I can't use a dynamic form rule because I need the rule to apply for Grid Edit.
How can I do that?

Miriam Klugman

1 Reply

  • There may be a better way, but all I can think of is to use the user role permissions and for each role necessary, set the field permissions so that all fields except for the one are view only.

    Then in the table access permissions, do a custom rule for modifying the record, so that the record itself can only be modified under your condition.

    This way, the record as a whole is locked until your condition, and even when unlocked, only the one field is set to be editable. You would need to do this for all roles you want this behavior for.

    Mike Tamoush