Highlight duplicates when two fields in one record are duplicate of another record within the same table

  • 1
  • 1
  • Question
  • Updated 9 months ago
  • Answered
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb

Posted 9 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
A record in Quick Base can’t really “see” other records.

So what I would do is to create a new table to record the Unique values of that field. To initialize the table, set a Text field in that new table called Unique values to be the key.

Then make a summary report in your details table and use the table to table copy option off the more menu to populate it.

Then make a summary count field and look that up down to the details table. If > 2 then duplicate.

Ok so now how to maintain that table?

I would make an Action to fire when the # of Uniue values is = 0 to create that Unique value record.
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb
Thanks. I will try it!!
Photo of Ruby Kapil

Ruby Kapil

  • 816 Points 500 badge 2x thumb
Thanks for the advice. I ended up creating a formula List field to concatenate two values. Then did summary report grouping on this new field, sorting descending by the Count. It gave me what I needed, anything over Count =1 I know is a duplicate and can drill down to investigate and correct. You saved the day once again!