Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 months ago

Pipeline - Bulk Upsert - Continuous Loop

I have a pipeline setup to insert new records into the same table base on a count entered into a previously created record. The issue I am having is a continuous loop of entering new records

Here is what I have

  • New record created with a count in a field
    • Count is Set
    • Asset Definition equals the asset type being setup
  • The count should create that number of new records in the same table
  • The pipeline is as follows
    • Record Created
    • Prepare Bulk Record Upset
    • Search Records
      • This search is being performed on a helper table that has one field in it for equipment count (i.e, one record with 1, 2 records with 2, 3 records with 3 and so on
  • For each record DO - Add a Bulk Upsert Row
  • Commit Upsert

All assets are being entered into the same table with asset types and asset definitions. Any subsequent equipment that is being added is basically tied to the parent asset with a Unit ID #

Looking for what I am missing here that is causing the loop



------------------------------
Zint Joseph
------------------------------

5 Replies

  • On the search helper table step, try putting the number of records to be created into the limit field 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • ZintJoseph's avatar
      ZintJoseph
      Qrew Captain

      That is a manual entry field, which I feel if I set it to the max that I think it would ever be, it will still loop and put that many records in even though my actual count is lower.



      ------------------------------
      Zint Joseph
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        OK, I was hoping it would allow a value being dragged into the box from a previous step.  I see now that it does not.  You say you have a helper table.  Can you number the records there in sequence starting at 0 and search where that number is less than the # required?



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------