Auto-fill column on change other column and edit value

[RaulFV]

Hi,
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.

Formula:
Max(
select(
Elements[Order],
[Type] = [_THISROW].[Type]
)
) + 1

[Steve · Accepted solution]

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[RaulFV]

Thanks Steve.
I had seen the documentation but not noticed that while doesn’t asign a value to the related column the formula stills apply.