Prohibit edit if existing Value

[Tissot]

I've been searching the forums like heck to no avail.

Can some one point me how to Prohibit edit of a field if a value exists.

I thought it was as simple as checking the Validate existing value box in the Validation Tab but unfortunatly its not as simple as that.

Thanks

[bcooney]

Typically, when someone has this request, we suggest setting the field's behavior to not allow Browse mode and putting an Edit button next to the field. The Edit button would run a script that would popup a layout that has the field(s) open for edit, providing the validation part of the script was true.

That is,

User clicks Edit

Script starts

//validation check

If (isempty (field))

gtrr in new window using layout Edit

else

//validation fails

Show Dialog "Sorry, you can't edit this field."

endif

You could also tie the allow edit to a priv set, such as Admin only by checking Get (PrivilegeSetName) = "Admin"

[Tissot]

Thanks. Is there no way to do that via a calculation in Validation Tab?

[bcooney]

Perhaps. I don't use the Validation tab for something like this, because the interface options are hideous.