Forum Discussion

CharlotteM's avatar
CharlotteM
Qrew Cadet
2 months ago

Pipelines to upsert just one of duplicate records

I have an invoice line item table with a non-key field Invoice #.  Some lines have the same invoice number.  These lines with the same invoice number are usually entered by the user at the same time ...
  • MarkShnier__You's avatar
    2 months ago

    ya, ... Would be nice to have a Quickbase step which would absurt a single record. But since they don't give us that what you need to do is launch your pipeline to search all the records that may need Parents to be created and then INSIDE the For Each loop you need to create an upsert box, add a single row, and commit the upsert.