Solved: Add data on column but not edit it after - Page 2

Fabrisantilli · 08-14-2020 09:13 AM

Hello! If I set a column to be editable, it will appear on my add form (action), although some columns I have are editable after being added and some others are not, I even have two columns that are identically designed although one is editable after the data is added and the other one is not.
I need the users to be able to add data to a specific column, but then not be able to edit it after is added. How can I do that?
Thanks in advance.

Steve

To allow the user to add a value only when the row is first created, but not when edited later, set Editable? to the expression:

NOT(IN([_ROWNUMBER], table-name[[_ROWNUMBER]))

replacing table-name with the name of the table.

To allow the user to add a value only so long as the column does not already have a value, set Editable? to the expression:

ISBLANK([_THISROW_BEFORE].[column-name])

replacing column-name with the name of the column. Note that _THISROW_BEFORE is relatively new and may not yet be available to all app creators. If you find that the case, I can provide an alternative.

View solution in original post