How to automate adding multiple rows from one table to a new table with a button?

2

You could create a button on the project table that has a formula that looks something like this:
FormulaMap(
Lookup(Projects,Project,thisRow.Project),
AddRow(
TaskList,
task,
CurrentValue.Task,
notes,
CurrentValue.Notes
)
)

1 Like