Button to add variable rows to a table

[Jacob_Bauer]

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!

[Troy_Larson]

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.

[Jacob_Bauer]

Thank you tremendously! This works exactly as hoped!