Hi all,
Does anyone know a way to lock the contents of a field once it has been entered?
The idea is to have an editable field which allows you only once to enter data. Once that data is in, the field can not be changed anymore.
Any ideas?
B.
Subject: lock field contents after first entry
It’s difficult if not impossible to do that on a field level. However, you can put any fields you want locked down into an access-controlled section on a form.
Subject: In fasct you can get close, relatively easily
by aiming at the effect you want -
Have two areas on the form
- with the Editable field
but a hide when of (! @IsNewDoc)
- with a Computed For DisplayField
named ?ShowEditable - value Editable
but a hidewhen of @isNewDoc
I’m sure you can see whats happening -
Subject: RE: In fasct you can get close, relatively easily
I didn’t suggest that method because it’s not secure, and the (perhaps incorrect) implication I got was a desire for high security. A sufficiently clever and malicious user could find a way to circumvent that. But as long as the developer knows and can accept that, it’s a useful technique.
Subject: True - but sometimes cheap and cheerful is enough
However, supposing the design did need better security
would even even an access controlled section on the form
give protection against an agent written by a user with sufficient rights
If you signed the field you might DETECT the change
but would it stop it?
Even encrypting wouldn’t protect against a trusted person who had teh key.
(Lyers on layers)
Subject: In fact you can get close, relatively easily
If you set the field Default Value to “”, and have a Input Enabled formula of FieldName = “”, then this allows one entry, and after that it is not possible to edit the field.
Is that any help?
Ian