Make column formula non-editable even thought it has a dinamic formula

[juliaruiz]

Hi,

 I would like to know how to make a non-editable column but that has an initial formula.

When entering a record into a form, I have some fields that are automatically filled in with some USERSETTINGS info like "User", "Name" etc. I would like, when another user edits that record, the column of "User", "Name" etc don't be edited.

I've tried to enter IFBLANK([_THIS]) on EDITABLE IF? but is not correct because it not can exist this parameter if FORMULA is not blank.

Thank you so much,

[AleksiAlkio]

If you have something with the initial value field, you should be able to set the column not editable. Then it saves the value from the initial value and later nobody is able to modify it. No expression is needed.

[juliaruiz]

 If the field has a formula, it can not be editable. If I make Editable? disabled, appsheet turns on it when I save showing this error.

Also I tried making Editable? IFBLANK(_THIS) but it doesn't work neither.

Anyway thank you so much.

[AleksiAlkio · Accepted solution]

So.. you have the formula in the "App formula" field and not in the "Initial value"?