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
Solved! Go to Solution.
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.
User | Count |
---|---|
44 | |
30 | |
24 | |
23 | |
13 |