select multiple rows from first table and copy them to second table with condition

[alhazen]

Hello There!

how to select multiple rows from first table and copy them to second table with below condition:

For You Know, Data in table 1 is added by loop action of a control table.

Thank you very much for your attention.

[1minManager]

Use a Select() function to choose the rows

https://support.google.com/appsheet/answer/10108207?hl=en

Create a "add a new row to another table by using values from this row" type action to copy a single row

https://support.google.com/appsheet/answer/10107706?hl=en#zippy=%2Cdata-add-a-new-row-to-another-tab...

Create a "execute an action on a set of rows" Action to use the select() formula you created above and the above action to copy mutiple rows.

https://support.google.com/appsheet/answer/10107706?hl=en#zippy=%2Cdata-execute-an-action-on-a-set-o...

Simon@1minManager.com