Pipeline to Split Record into More Records Based on Field
Hello all! I could use some help with a pipeline. I have a table called assets. When the sales team adds assets to an order they enter a quantity. There are times that the operations team then need...
There is probably a fancy way way with jinja / regex, I'm a low tech kind of guy, so I would set up a helper table preloaded with records numbered from one to 100.
Then, on some kind of trigger, I would search that helper table, looking for records numbered less than the quantity of the trigger record.
Then a For Each loop to add a child record of more lines to your order. Then, lastly, I would edit the trigger record to set the quantity down to 1.
