Forum Discussion

Re: Creating multiple child records based on the quantity of a field in the parent table

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)
[email protected]
------------------------------

2 Replies

  • katlyncowley's avatar
    katlyncowley
    Qrew Assistant Captain

    Have you found another way to do this? I tried performing a search for records where # child records (summary numeric field) was less than the # of records needed (numeric field), then loop through, but there's no counter function that I know of, or really any other way to do this. 
    It would be especially beneficial if I could set individual due dates on each of the child records.

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      katlyncowley  Maybe you should post a new complete question and reference this thread and include why this solution does not work for your use case.