Add multiple rows into another table using a set of template rows from another table

[nate913]

Hi Everyone!

Brand new the the community and started building my first services app! Could not have gotten this far without so many of your posts! Thank you! I did get stuck and I'm hoping someone can help me get unstuck. 

What I want to do:

1. Click Action button from the 'Customer' record
2. Reads all rows of data (essentially a list) from the 'Equipment Template' table and copies
3. Writes all rows to the 'Equipment' table (1:M)
4. The user can then capture all the equipment data they need to and it is referenced correctly

The 'Equipment Template' rows of data are essentially a survey list of data elements that needs to be gathered (pump, motor, valve, etc). There maybe a totally better way to do this but my thought with the 'Equipment Template' table is to give us the flexibility to change it in sheets rather than coming back into appsheet. 

[Suvrutt_Gurjar]

Please take a look at the multiple tips on adding multiple rows to a table.

You will of course need to modify the approach. You could use bot automation as well.

Search - Google Cloud Community