How "flag" a record

[Darren Emery]

I'm wondering if there is a standard, or best, method to set a condition on a record, so that is in essence flaged, and not allow certain actions to be taken.  In the past, I've used a text field as a blank, and when I need to flag a record, I insert a value,   Then I have my scripts check that field and only allow an action if the field is empty.

 

I have also used the presence of a child record in a related file to act as a flag. 

 

This works, but I wonder if there is a better, or more robust way, to accomplish this? 

 

 

[comment]

Assuming the condition is meant to apply to all users, setting a Number field to 1 (True) would be the simplest way, IMHO.

[LaRetta]

... so that is in essence flaged, and not allow certain actions to be taken. 

 

Hi Darren,

 

Using Michael's approach, the most robust and safest way to guarantee that your flag will be honored is to let Security handle it by privileges calc = not flag which will disallow changes if it is flagged with the 1.  Then back it up with trigger script if you wish to improve the User experience of it, as you are doing.