Button that creates multiple rows

[Pch]

Here’s also a topic which helped me a lot when I was struggling with FormulaMap()/ForEach()

FormulaMap() : When and where?

Here is a small example. Imagine you have two tables (Table 1 and Table 2) and you want to copy all the row values from Table 1 to Table 2 (only from Name column in my example, but you can copy more columns). You can do it with a button using FormulaMap function. You “list” to use with the FormulaMap function will be all the rows in Table 1. Code for the button: [Table 1].FormulaMap(AddRow([Table 2],[Table 2].Name, ToText(CurrentValue))) Here is an example doc: Second button copies only …