Script to stop all

[cterrell16]

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.

[No_access]

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..

[mr_vodka]

See here.

http://fmforums.com/forum/topic/83768-locking-records/page__p__387606__#entry387606

[cterrell16]

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.

[mr_vodka]

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.