Help

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
cancel
Showing results for 
Search instead for 
Did you mean: 
Repurpos
4 - Data Explorer
4 - Data Explorer

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

Repurpos_0-1712571877167.png

...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....

Repurpos_1-1712572064941.png

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?

Thanks

3 Replies 3

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

Repurpos
4 - Data Explorer
4 - Data Explorer

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

Hi,
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:

Alexey_Gusev_0-1712641555614.png

Alexey_Gusev_2-1712641837063.png

 



Alexey_Gusev_1-1712641765081.png

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.