I’ve been using Formula Map to add multiple rows to a table, with the Column 1 names drawn from a Multiselect control.
The issue is that I want the “Order #” for each of those rows to incrementally increase… I currently have the following formula, which sets the “Order #” of the row as the MAX value +1… but formula map is not re-calculating the max value as it progresses from row to row. Each row ends up with the same “Order #.”
FormulaMap([Multiselect Control],AddRow([Order Table],[Order Table].[Order #],max([Order #])+1,[Col1],CurrentValue))