Limit modification

[KirkD]

I don't want the user to be able to modify a field after the record is commited. I know I've seen this before but I can't remember how it's done.

[aldipalo]

Try this. You may want to add some kind of validation to the script. If the user adds garbage they will not be able to change it, so you should validate it first.

HTH

No_Modification.zip

[KirkD]

Thanks for the help. I did come up with a similar solution over the weekend but I have two problems with this.

1)I can still tab into the field and make changes.

2)I can shut off the tab entry but then the user has to click the mouse to enter each field. You don't know how many complaints I would get for that.

I came up with a solution using zippscript. If you are interested I can put together a file to show you but you will need to install zippscript. If you are interested let me know.

Thanks

Kirk

[comment]

Why don't you simply take away users' privilege to edit records?

[KirkD]

I thought of changing the edit privileges but I want them to create and edit the record but after they have entered a value I want to prohibit changes on two of the fields.

I don't see how to do this with privileges. Maybe I'm missing something.

[comment]

Sorry, I thought you wanted to lock the entire record, once it has been created and filled out. Unfortunately, it's not possible to assign privileges per field.

Hmm... so you want to be able to tab into the field - and I presume you don't want to get the dreaded FM validation dialog either. Not so easy. The best I can think of (without resorting to plugins) is the attached - but note that you have to commit a new record first, before you try to fill the lockable fields.

LockFields2.fp7.zip