Pipeline - Check for Duplicates when writing to a table

Question

Good morning,I've created a pipeline to write a tracking number to a table, but I only want to create unique records. There may be many items with the same tracking number, but I only want to write it to the table once. Is there a criteria I can use in my pipeline to check for this?Thank you,Kim------------------------------Kim------------------------------

MarkShnierYou · Answer

If the field is marked as Unique or is the Key field, you can have the Pipeline do an "upsert" using the Bulk Records step "Prepare a Bulk Record Upsert" and then add a row to the Upsert and then commit the upsert.

I know it seems like overkill to go through all those hoops to create an upsert and then add the single row and then commit the upsert just to get one record too upsert but maybe one day we will get a direct upsert record step so we don't have to go through all those steps.

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

Sign up

Login to the community