Help with creating a button that will add multiple rows and their values

[Kayla_Van]

Hi! I would like to create a button that adds multiple rows from a template table to a masterlist table but will also copy over their exact values in all the columns. If anyone could help, that would be greatly appreciated!

Here’s a Test Doc I created: https://coda.io/d/_dPCwxMtGreQ/Master-List_suGvu

I found a formula somewhere else but it only adds rows with the task’s value, when I want it to add exactly the same values in all the other columns.

Thanks in advance!

[Dale_Cowling]

Hi @Kayla_Van,

You were using ToText(CurrentValue).

The use of ToText is very situational and breaks any formatting and relationship value it might hold.

I have removed all references of ToText().

You also kept using CurrentValue on its own for every value. CurrentValue in this FormulaMap is a Row and you need to treat it as such. For example to get the Stage it needs to be CurrentValue.Stage indicating which column on the row being precessed that you want to retrieve the value from.

Hope this helps.

All the best

Dale

[Kayla_Van]

Got it! This is so helpful, thank you very much.