How can Lock some fields

[TereLavin]

i don

[Aussie John]

you could use the validation options int hte define fields dialog. eg use calculation option set to get the current user

[RalphL]

You can use related fields for data entry and then break the relationship. The related fields are on top of normal fields that do not allow entry.

The method of breaking the relationship is to null one of the fields in the relationship. This can be done by script or it can be built into a calculation for this field.

[Ken Newell]

I was digging through some past items that I made and ran across this which I call switchable validation. In essence you create a flag to determine if you can edit a record and use the flag to validate the date. Presented in it's simplest form to get the idea that you can selective turn validation off and on using this flag. Hope this helps you.

SwitchVal.fp5.zip

[ibiubu]

Similar question...but in the different direction.

I have a custom calc in my privledges that lets only certain users edit certain records. Is there anything that can be added so that one particular field can ALWAY be edited?

For example I have it set so that if a particular user is on a particular layout, that record can not be edited. But I would like it to be set that if the user selects one particualr field, that one field can be edited. I did try adding the following to my access privledges for allowing editing:

Status (CurrentFieldName) = active

But of course that did not work.

LR

[ibiubu]

OK, here is a quick solution for this. To be able to edit one field in a layout, but not the others:

Set up access privleges with limited access for edit records.

For the access calc use something like:

Status (CurrentScriptName) = NameScript

Now in the layout select the "Name" field and go to Field Format in the menu...

Turn off the check box for "Allow entry into field."

Now make a script step called "NameScript." Add a single step:

Go to Field["Name"]

Assign this script to the field called "Name."

Result: The user cannot edit any fields on the layout based on the settings in Access Privleges. BUT when the user clicks on the field "Name" the script is run that has the Go to Field step. The user can edit this field because of the entry in Access Privleges that includes Status (CurrentScriptName) = NameScript

Don't know how elegant this is, but seems to be the only way I could get it to work.

LR

[transpower]

Upgrade to version 7; you'll have far greater control of accounts and privileges.