1/ I had originally had it with this formula, but I pulled the example here from another table that I had created for my own use case, where it had to have a count so feel free to use either.
2/ The .Nth() is necessary because of the way Coda’s ‘CurrentValue’ scopes. The reference within a FormulaMap() is local to the list you want affected, so by duplicating to a separate table you would lose the reference to the original table’s elements. Using Sequence() and .Nth() allows us to use the elements within the original table at the Nth() location to affect the ‘CurrentValue’ of the separate table. This is the only way I have figured out how to implement a loop within a loop.
A post on this subject that helped me: Loop within a Loop
I am not sure if there has been any updates that allows a different system of looping, but someone may correct me on that.
As for the AddRow Reference, the reference does only show 1 column being affected, however the actual formula takes optional parameters: .AddRow(table, column 1, columnValue 1, column 2*, columnValue 2*, column 3*, columnValue 3 …) and so on.
This allows you to duplicate any information within a row that you want, and leave out anything that is not necessary to duplicate.
I have long been waiting for a simple DuplicateRow(table, row, table 2*…) but unless I have been out of the loop, I am still waiting.