Update trigger to insert multiple records based on Quantity field in #insert

[JohnNuttDesk]

Hi Hi

I need to print a label for each item that I sold.  For example, in my SalesDetail table, I have one record that I sold Quantity = 14 of item AAA and a 2nd record that I sold Quantity = 3 of item BBB.  I need 14 records of item AAA Inserted to my Shipping Label table and I also need 3 records of item BBB Inserted as well.   I have a datapage that can then print 17 beautiful labels.  My trigger below works great on Update if I only Update one record at a time in Sales Detail.  The problem is that I have 100s of records in Sales Detail and I "Bulk Edit" the records.   The trigger below will either pick the 3 OR the 14 and then, for example, Insert 3 records of AAA and 3 records of BBB.  Do I need to use the "For Each Record In" Loop?  I added the TxnLineId which is unique to each record in SalesDetail but I still couldn't fix my problem.  Help is always appreciated!

 

 

[JohnNuttDesk]

Caspio was able to help with the answer.  Here it is.  This trigger will make/Insert "x" number of records in the "child" table based on the "x" number in the quantity field of the parent.  Most importantly, it works in bulk edit mode on the parent table as well.  For example, I can update a "batch #" like 123 into the batch field of my parent table.  I can use  the Bulk edit to update dozens of records with this "batch" number 123.  Then this trigger will insert multiple child records for each parent record updated with the batch #.  For example if one record in the Parent has the quantity set to 15 then this trigger will create 15 records in the child table.  Great for making shipping labels!!  

 

[cheonsa]

Hi!

Just to add, here is the article for more information regarding Trigger Loops: https://howto.caspio.com/triggered-actions/triggered-action-elements/loops/