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

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