Discussions

Expand all | Collapse all

Using a summary report to spot duplicates

  • 1.  Using a summary report to spot duplicates

    Posted 12 days ago
    Edited by Anaya Steward 12 days ago
    Hello! Is there any possible way I could use a summary report to spot duplicates of records in the same table? Each record has a formula text field that shows a unique code for each record, however, some of the records have the same unique code. I was wondering if I could use a summary report to find records with the same codes. If not, what should I try? 

    ------------------------------
    Anaya Steward
    ------------------------------


  • 2.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    np, just make a summary report of unique codes and click the column twice to get it to sort form hiugh to low, then save.  The dups will float to the top.

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



  • 3.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    There is also the option to filter to only show instances where the count for the unique code is greater than one. This will then show you only the duplicates.

    ------------------------------
    Adam Keever
    ------------------------------



  • 4.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    Huh? .. don't think so :)
    You cannot filter a summary report on the summary counts.

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



  • 5.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    Ah, indeed. I was thinking of the summary field of a relationship used in a table report. I have done this and it allows the functionality.

    ------------------------------
    Adam Keever
    ------------------------------



  • 6.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    For some reason, when I made the report, it doesn't count any of the duplicates. The summary simply shows the codes and a "1" next to it (I can't show the column with the codes in it since it contains client info).
    These are some of the settings I used. Have I overlooked something? This is my first time using summary reports.


    ------------------------------
    Anaya Steward
    ------------------------------



  • 7.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    You should be summarizing the # of Records and then group by Unique formula.

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



  • 8.  RE: Using a summary report to spot duplicates

    Posted 12 days ago
    It's working now! Thank you so much!

    ------------------------------
    Anaya Steward
    ------------------------------