Discussions

Expand all | Collapse all

Using a summary report to spot duplicates

  • 1.  Using a summary report to spot duplicates

    Posted 01-08-2020 12:10
    Edited by Anaya Steward 01-08-2020 12:13
    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 01-08-2020 12:18
    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 01-08-2020 12:27
    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 01-08-2020 12:28
    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 01-08-2020 12:46
    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 04-09-2020 11:01
    I wish we could create reports out of existing reports... This would fix so many workarounds in QB. 

    https://quickbase.uservoice.com/forums/111823-quick-base-product-feedback/suggestions/40133761-table-report-out-of-existing-reports

    ------------------------------
    Francesco Spiga
    ------------------------------



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

    Posted 01-08-2020 12:39
    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
    ------------------------------



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

    Posted 01-08-2020 12:54
    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
    ------------------------------



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

    Posted 01-08-2020 13:02
    It's working now! Thank you so much!

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