Using a summary report to spot duplicates

Question

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
------------------------------

anayasteward · Answer

It's working now! Thank you so much!------------------------------Anaya Steward------------------------------

markshnier__you · Answer

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
------------------------------

adamkeever1 · Answer

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
------------------------------

markshnier__you · Answer

Huh? .. don't think so :)You cannot filter a summary report on the summary counts.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

anayasteward · Answer

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------------------------------

Forum Discussion

Using a summary report to spot duplicates

Related Content

Summary Reports

Is it true you cannot add a duplicate personal report name per App?

Maximum Summary field not working

Pipelines to upsert just one of duplicate records

Way to Duplicate Tables or Make A Template for a Table?