Forum Discussion
JoshuaCase
Qrew Cadet
Is there a way to now do this via a pipeline?
I am looking to have records created in a separate table based on a QTY entered in the original table.
So if a part is ordered and we ordered a QTY of 15. Create 15 new records in the separate table to then track each part's unique serial, MAC, etc..
------------------------------
Joshua Case
------------------------------
I am looking to have records created in a separate table based on a QTY entered in the original table.
So if a part is ordered and we ordered a QTY of 15. Create 15 new records in the separate table to then track each part's unique serial, MAC, etc..
------------------------------
Joshua Case
------------------------------
MarkShnier__You
2 years agoQrew Legend
I will offer up my no code solution. No doubt there is a more elegant solution available using more advanced Jinja, but this will work on a no code basis.
Make a helper table and upload from Excel the numbers from 1 to 1000.
Trigger the pipeline and do a search against that table where the Order Qty is less than or equal to the number in the helper table.
The use a For Each loop to create your children.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Make a helper table and upload from Excel the numbers from 1 to 1000.
Trigger the pipeline and do a search against that table where the Order Qty is less than or equal to the number in the helper table.
The use a For Each loop to create your children.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------