A READER ASKS: Locking A Record

From Dwayne Wright - Certified FileMaker 9 Developer
WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright

I am trying to set up a script that would lock files in filemaker after they have been created after two weeks. I am the data coordiantor of the company as of a few months ago, but nothing is locked. I dont want to set the lock (or limited the access) right away, because then I would be the only one that would be able to change the information. By setting a script that would automaticly lock the file, then this will give the accessioning department to correct their mistakes w/o me doing all of the work. If you have any ideas or suggestions let me know. Thanks.

This isn’t that hard to do, basically you need a trigger and then a follow up security setting. The trigger can be manual, semi automatic or fully automatic. Many times, you can have one field for the trigger that is either empty or contains data. If empty, the lock isn’t activated.

The locking of a record is commonly done either with field validation or with security privilege set design. A lot of users go the validation route because setting up security options intimidates them. That is a shame because using FileMaker security settings are not that difficult, extremely powerful and flexible.

Here are some links to other posts that might be of interest in regards to this topic...
Locking A Record Via Validation
Designed Record Locking
EXAMPLE: Record Locking
A READER ASKS: Lock a user/account into a certain layout
EXAMPLE: Record Level Access By Account Privilege
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.