I have a script that changes the value of a particular field. I would like to start the script with something like "if this user is not allowed to edit this field, then exit the script".

I have seen the "Get(RecordAccess)" function, but not one at the field level. Any tips? thanks in advance.

The user belongs to a Privilege Set, correct? Let's say it is called "StandardPriv." Then, in your script:

If (Get (PrivilegeSetName) < > "StandardPriv",

setfield

End If

Make sure that the checkbox at the bottom of the Script window is not selected for Run with Full Privs.

Whilst checking the privilege set name is good, problems could arise later when more privilege sets are added or modified.

Instead, perform a "practical test" to see whether the field is locked by setting the field to its current value: if an error occurs, you know it's locked. The "Set Error Capture [ On ]" step suppresses the error from being reported to the user.

Set Error Capture [ On ]

Set Field [ field ; field ] // Set field to itself

Set Variable [ $error ; Get( LastError ) ]

Set Error Capture [ Off ]

If( $error = 0 )

Else

End If

If you're using FMP 8 or earlier, put the error into a global field instead of a variable (since variables are FMP 8.5 and later).

But, Vaughan, how is the field locked? In any case, it'll be tied to a priv set, right?

Hi bccooney and Vaughan, thanks a lot for your feedback.

bccooney, your solution is good but what I like about Vaughan's is that is dynamic, that is what I was looking for. That is, let's say that I add a new priviledge set, if I use your solution I would need to modify the script, whereas if apply Vaughan's there is no need to adjust the script. Thanks a lot to both anyway!

OK. I give up. How is the field "locked?" You'd still have to set up the access privs for editing this field for the "new" priv set. Also, I prefer my scripts to have "all the info" in the script. So, when the field doesn't edit, I can see it's bcs of the priv set.