May 31, 201213 yr Is there a way to make a script that will stop data from being changed in a record. I want to be able to assign a number to a record then lock everything from being changed.
May 31, 201213 yr you can use validate by calculation to keep the field locked, this requires a extra field thats not on the layout to use as the "lock" field and you can use "not isempty(lockfield)" as the validation. use a script to toggle the lockfield..
May 31, 201213 yr See here. http://fmforums.com/forum/topic/83768-locking-records/page__p__387606__#entry387606
May 31, 201213 yr Author I don't follow. I tried the link also but I don't see where it actually does what I need. I'd like to have all my data typed into the cells and then it a button to lock all cells from further modification.
June 1, 201213 yr Did you see the modified demo? Use the Admin user/password and look under Mange Security for the 'User Access' privilege set. What you need to to allow access when the flag field is not set. Once the flag field is set those who are in the 'User Access' privilege set should not be allowed to modify the record. Of course you want some kind of admin privilege set to have access so that they can unlock it if need be.
Create an account or sign in to comment