Lock data entry after the entry is made

[Jens Peter]

Hi

I need some help that I hope someone can help me with.

I have a field "Type" where I have a value list added to holding "Type 1" and "Type 2".

The user may change from "Type 1" to "Type 2" but when the "Type 2" is selected the field needs to be locked for futher changes.

Do anyone have an idea on how to calculate this?

Thanks for any help.

[Raybaudi]

Hi, Peter

make the field "Type" an autoenter/replace with this calc:

Case(

Type = "";

Let([

$$Type=""

];

"");

Type = "Type1" and $$Type ≠"Type2" ;Type;

"Type2" &

Let([

$$Type="Type2"

];

"")

)

BTW: if someone deletes contents of the field "Type", he could change from Type2 to Type1( or whatever else if the validation of the field isn't setted to "member of value list")

[Raybaudi]

I changed my mind...due to the limitations that I said to you ...

So, I think that is better this solution.

Make a new calculated text field, let say: TypeLocker, with this calc:

Case(

TypeLocker = "Type2";"Type2";

Type = "Type2";"Type2"

)

and change the calc of the autoenter/replace Type field to:

Case(

not IsEmpty(TypeLocker);TypeLocker;

Type

)

[LaRetta]

The holding FIELD needs to be locked from further changes? So it can't be changed from Type 2 back to Type 1? Or do you want the RECORD locked if Holding = Type 2 so no changes can be made to ANY fields within the record (such as posting month-end)? Someone may need to change that field! And someone may even need to change that record (under unusual circumstances). I guarantee Type 1 will be changed to Type 2 by accident. So if you use Daniele's method, you'd better allow modification by SOMEONE within the calc.

Another option is to use Access Privileges. You can apply field-level access, restricting changes if Type 2 to only certain personnel by using Extended Privilege Sets. It depends upon 1) how important is the lock and 2) have you established access privileges (which I highly recommend)? If you wish to go this route and need assistance, let us know.

LaRetta

[Jens Peter]

Hi raybaudi

Your idea work as I want/need it to work.

I made the extra field and added your calculation - the entry of data to the first field is now locked when type2 is selected.

Thanks.

LaRetta, as always you take it a little futher. It was not needed for this as all the other fields may be changed after the selection of type.

But thank you.

/

Jens Peter

[Raybaudi]

Peter,

happy that that calc solved !

BTW: if you wish that any choose of that field couldn't be modified, make the calc of your field "TypeLocker" exactly the same of the field "Type":

Case(

not IsEmpty(TypeLocker);TypeLocker;

Type

)

So, if someone chooses "Type1", that will be his final choose !

[Jens Peter]

Hi

The field Type cannot be accessed on the layout so this is not a problem.

But I will keep your idea - never know when I could use this :-)

Thank you again.

Jens Peter