Forum Discussion

AnayaSteward's avatar
AnayaSteward
Qrew Trainee
5 years ago

Using a summary report to spot duplicates

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, s...
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
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
------------------------------
AnayaSteward's avatar
AnayaSteward
Qrew Trainee
5 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years 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
    ------------------------------
    • AnayaSteward's avatar
      AnayaSteward
      Qrew Trainee
      5 years ago
      It's working now! Thank you so much!

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