Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
8 years ago

When importing into existing table from Excel/CSV, if duplicate found, do not import duplicate

Instead move the incoming duplicate records to another table for review. Background: I set up a Formula-Text field as the Key field (used API). The formula uses List() to combine Lat and Long with s...
App builders
Ask about Quickbase functionality
Data import and export
KatherineOlson's avatar
KatherineOlson
Qrew Member
6 years ago
Can someone expand on this suggestion?

1. How would I detect duplicates using a relationship between the table and a scratch table?
2. Assuming a "table to table copy" is a "table to table import," how do I get only the unique records to copy?
3. Lastly, how do I get that import into a URL button?

------------------------------
Katherine Olson
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Can you explain what you mean by Duplicates?  Do you mean a duplicate of the Key field in the target table?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------