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

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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 space in between. When I add new data, it combines the Lat and Long first and then updates existing records.
Sometimes I do want to simply update existing, but other times when new records being added, I want QB to alert me of duplicate and put that duplicate somewhere else for later review, and proceed to import for the non-duplicates.
Photo of Ruby Kapil

Ruby Kapil

  • 1,054 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,954 Points 50k badge 2x thumb
you would need to import to a temporary scratchpad table first.  Then have a relationship between you real table and the scratchpad table to detect of there is a duplicate. 

Then I would use a saved table to table copy  in a URL button to copy across the non duplicates.