Button to add variable rows to a table

I’m looking make a push button that adds a variable number of rows to another table depending on criteria in a different table. For each of the active members in the Members table, I want a new row in the Rate table each time the button is pushed.

However, I can only find one of two things:

  1. Formulas wherein you predefine the number of rows to add.
  2. A formula that adds the array of people all into one cell, adding only one row.

This is the output I’m looking for:

Does anyone have any suggestions? Thank you!

I created a demo for you here.

Basically, the button will do a ForEach on each active person in the Members table and add each one to the Rate table.

1 Like

Thank you tremendously! This works exactly as hoped!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.