Lock and unlock the record

Discussion created by trinity-1314 on Aug 26, 2014
Latest reply on Sep 2, 2014 by samarthmkt

Hi FileMaker Members


I have a question about how to creat a script to limit the modification permission of the record. The details as below.


For example, there are some fields in the named "orders" layout including a field Approval Status with value list by "Approved" and "Draft".

When I set the field Approval Status as "Approved", the related record of the orders layout was locked or unable to edit. On the contrary, "Draft" can be modified.

Attached GUI for your reference.


Hope I make myself clearly. Look forward to hearing from your reply. Thanks in advance.