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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp, 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- 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__YouHuh? .. 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
------------------------------- 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
------------------------------
- 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).
------------------------------
Anaya Steward
------------------------------- MarkShnier__YouYou 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
------------------------------- It's working now! Thank you so much!
------------------------------
Anaya Steward
------------------------------
