DuplicateRow function

[Pieter_Lesage]

A function to duplicate (or copy) a complete row would be very practical.

in this topic @Joshua_Upton and @Paul_Danyliuk helped me with how to duplicate a row (here Button to duplicate multiple rows) , but the problem is that when I add a column in the future, I need to rework the formula.

A function to duplicate a row and define what columns you want to change would be ideal. If you add columns in the future, they would be copied also.

DuplicateRow(table1, row, table2, column, value)

[Paul_Danyliuk]

FYI I already made a topic with such request:

Add CopyRows() capability

Sometimes there’s a need to copy a row or multiple rows, e.g. to make a snapshot of some data. Think of a pricing calculator table with lots inputs for different percentages etc — and the salesperson wants to make multiple variants with small changes to be able to quickly switch between. Copying a row with AddRow() and enumerating all the columns is not a problem… unless there’s a few dozen of those. CopyRows() could be a handy formula. It would accept a row or a filtered table, and for variad…

Same table, because realistically there’s no simple way for Coda to map columns from one table onto another table.