Forum Discussion

Qrew Cadet

3 years ago

Pipeline - Check for Duplicates when writing to a table

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 writ...

KimRavizza

Qrew Cadet

Thanks Mark. I'll give that a try and let you know how it goes.

------------------------------
Kim
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

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
------------------------------

KimRavizza
Qrew Cadet
3 years ago
Thanks Mark. This works perfectly!

Yes, that was my concern, as I will be updating multiple records with the same tracking number at the same time.

Thanks so much for always being so helpful!

Kim

------------------------------
Kim
------------------------------