Pipeline - Bulk Upsert - Continuous Loop

Question

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

markshnier__you · Answer

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 · Answer

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 · Answer

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
------------------------------

zintjoseph · Answer

I think the major issue is the Prepare Bulk Record Upsert. The merge field option is only the RID. Since I am not updating but rather adding records to the same table, there is no RID. The little statement below the field says if no RID is found, it will just add the records. Somewhere along the way, it is losing the count and just continues to add records. Before I caught what it was doing and turned off the pipeline, it had added almost 10,000 new records instead of the 8 I had put in the count
------------------------------Zint Joseph------------------------------

zintjoseph · Answer

Right now the query is Equipment Count equals {{a.rack_circuit_count_case_linueps}}.
In this instance, the count was 8. In my Equipment Count table, I have 8 records with an equipment count of 8. I am assuming the logic is it finds 8 equipment records with 8 and enters 8 new records and stops. The only field in the count table is the Equipment Count field which is setup with one record with 1, two records with 2, and so on up to 16.
------------------------------Zint Joseph------------------------------

Forum Discussion

Pipeline - Bulk Upsert - Continuous Loop