How to add multiple rows in a second table, when adding a new record in first table

Topic Labels: Automations Base design Data
275 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have two tables. The first is a item "types" as below


...the second is a table of "details". Each row represents 1 item of the total number of that item type. Each row in the second table will have unique data, like an ID, a physical address and a QR code....


If I add a new row in to table 1, with a qty of 20 units (in the Qty column), how can i automatically add that many rows to the second table, and link them to the dislay type from the first table?


3 Replies 3

Check out this thread where @Dan_Montoya has an example of how to solve this problem

4 - Data Explorer
4 - Data Explorer

Thanks @TheTimeSavingCo . I'll take a look at the thread

First of all, you should define correct trigger for automation, for example when Status is not empty and Quantity is not empty. If you set only Quantity field for trigger and type '20' in it, it will run after you type '2'.

If your plan includes scripting in automations, you could use simple trick:





Thus, you create N records, each linked to the 'parent' record which triggered the automation
you can also add additional fields data, based on parent record, if needed.