How to keep a field non editable after first ...

[Himanshu_Gupta]

How to keep a field non editable after first entry?

Let say I have asked buyer details to be filled and a executive fills all detail of buyer in his first visit now I dont want to get it edit post first entry reason is that buyer detail wont be change in future.

Please help at the earliest and thanks in advance.

[Aleksi_Alkio]

There are many ways… for example put this formula NOT(IN([KeyColumn],TableName[KeyColumn])) into the Editable_If field.

[Himanshu_Gupta]

Column Name ‘Wholesaler name’ in Schema ‘Wholesale data_Schema’ of Column Type ‘Name’ has an invalid Editable_If constraint ‘Wholesale data[KeyColumn]’. Unable to find column 'KEYCOLUMN’MORE INFOGO TO THE PROBLEM

I am getting above error

@Aleksi_Alkio

[Aleksi_Alkio]

Your “Registered Phone” is the key column and you should use it like… NOT(IN([Registered Phone],Wholesale data[Registered Phone]))

[Himanshu_Gupta]

If i am using TableName[KeyColumn] function what should i enter in place of table name and keycolumn?

[Aleksi_Alkio]

Those names need to come from your table structure. Please check what is your key column in that table and use that column name instead.

[Himanshu_Gupta]

I did but what happened is once i enter in that field(non editable column) and move to next field for entering(let say phone number) first value get blocked at the first time entry but when i am going back to edit i am able to edit it. @Aleksi_Alkio

[Aleksi_Alkio]

Would you please show that formula in the Editable_If, thanks

[Himanshu_Gupta]

#ERROR!

[Aleksi_Alkio]

Is the “Wholesaler name” a key column?

[Himanshu_Gupta]

yes Column name is wholesaler name(2)

[Himanshu_Gupta]

@Aleksi_Alkio