Make field data permanent

Question

Hello!

We want to create a Formula-Checkbox field that is true when a certain trigger occurs, when it "switches" we want it to stay switched and never change back. Is that possible with QB?

For example if there are 3 stages of a record like stage 1, stage 2, stage 3...when it switches to stage 2, we want it to stay stage 2 even if it goes back to stage 1 or to stage 3. Basically, once it hits that trigger, the field locks.

Thanks so much,

------------------------------
Gelo
------------------------------

MarkShnierYou · Answer

If all editing is done on forms, then you can have a form rule.

When Multiple conditions are true

When the user is not in the role administrator.
When [Status] = Stage 2

Action
Make Read only [ Status]

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

Sign up

Login to the community