How to add multiple rows to a table with FormulaMap, with a value that increases by +1 in each row?

[Steve_Simon]

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))

Any ideas?

[Dalmo_Mendonca]

One way to do it strictly as you put it is:

Sequence(1, [Multiselect Control].Count())).FormulaMap(
  AddRow([Order Table],
    [Order Table].[Order #],max([Order #])+CurrentValue,
    [Col1],[Multiselect Control].Nth(CurrentValue)
  )
)

See this:

Simulate a For Loop (Reference position inside FormulaMap)

So I was struggling with a problem where I needed to evaluate multiple lists simultaneously. A classic use case for a loop. Coda doesn’t have built-in formulas for classic loops such as for or while. The closest thing being FormulaMap. It takes a list as input and runs every item through an expression. Inside the expression, you use CurrentValue to reference the current item being evaluated. As a result, CurrentValue can be of any type (row, date, etc). But there’s no obvious way to get the ke…

---

But I’d probably use a column formula to guarantee unique order numbers: [Order Table].[Order #] = thisRow.RowId()

[Filmos]

Actually, using the Sequence formula would be better than using RowID, since the RowID formula is unreliable when adding multiple rows.

Just putting this here to save a lot of debugging and frustration.