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 i...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOn 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
------------------------------
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
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
------------------------------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
------------------------------
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
------------------------------