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"?

[rmanchu]

This does not address the case where the form is populated from LINKTOFORM(). I want some fields that are populated to be locked but at the same time saved.

How to achieve this?

[AleksiAlkio]

So.. you have an action with LINKTOFORM() where you set the value in the column A. That column should not be editable, right? If that's the case, you should be able to set that column not editble. The LINKTOFORM() populates the value into it and show it through the form view. Is that what you are looking for?