I’m trying to autofill a column in a form when the user changes other column, and after doing this the user can modify the value of the autofill column.
If I use a formula in the column I can’t edit the value.
The initial value is not valid because I can’t know until the user select a value in the other column.
The exact case I’m trying to solve is:
I have a table with elements and other with type of elements.
I want to fill a column order in the elements table with the maximun order plus 1 of the elements of the same type.
[Type] = [_THISROW].[Type]
) + 1