Discussions

Expand all | Collapse all

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

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

    Posted 02-03-2018 21:12


  • 2.  RE: Highlight duplicates when two fields in one record are duplicate of another record within the same table

    Posted 02-03-2018 23:14
    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.


  • 3.  RE: Highlight duplicates when two fields in one record are duplicate of another record within the same table

    Posted 02-05-2018 19:23
    Thanks. I will try it!!


  • 4.  RE: Highlight duplicates when two fields in one record are duplicate of another record within the same table

    Posted 02-07-2018 04:10
    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!