+3I 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?
Thanks
+23Hi,
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
