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
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
Qrew Legend
Qrew LegendOK, 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
------------------------------