How to add n rows by bot automation

[kemonra]

Hello everyone!

How can I add n rows from Table A to Table B using a bot automation in AppSheet? I already know how to use actions to add multiple rows to another table, but I want to achieve this through a bot automation. Specifically, I want to input the number of rows to add in Table A, press the trigger (action button), and then activate the automation to add the corresponding number of rows to Table B based on the input in Table A. I have used the "add a new row to another table" action, but the bot only performs this action once and then stops.

[Suvrutt_Gurjar]

You may want to elaborate your requirement a bit more in detail.

1. Do you wish to have 1:1 replication between table A and B. Meaning if you are replicating 5 records from table A , replicate each of those table A records once in the table B

2. You would like to replicate one record from table A with certain values repeated in 5 records of the B table. This is equivalent of creating 5 child records in table B for a single record in table A

3. Would you like this number of records to be replicated by the user or would you like the a fixed number of records to be replicated each time.