Pipeline - Check for Duplicates when writing to a table

I have found that an upsert is the safest way to create unique records. You can also use a formula query or a relationship to detect if the unique key already exists but if you create records on some mass basis like an import then multiple concurrent pipelines will spawn at the same time and they may both try to add the unique key as they will be in a race condition against each other. So an upsert will avoid that.

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