The Quick Base Community will be read-only from August 19th-23rd while we finalize the updates to launch our new community site. On August 23rd the new community site will be live and accessible right here at this same URL with the full launch on August 27th with a special AMA with Jay Jamison on our exciting Cloudpipes news.
If you run into an issue while we are working on our migration you can reach out to our Care team via a Care case for help. There is a link to submit a case right on the Community home page or at our Contact Us page at www.quickbase.com. Thank you for your patience while we work behind the scenes.
After selecting "Values in the field must be unique" and "Check existing entries for duplicate values." in the Field Properties, I get an error warning that the existing values in the field are not unique.
How do I locate records where there are duplicates in a particular field?
The way we all have to do it is to make a report of Type Summary, and group by that unique field. Then click the column heading that has the Count of record. That will sort it lowest to highest, so click again and it will resort from highest duplicate count to lowest. Save the report, at a personal report.
Then just keep drilling into the 2's and 3'3 at the top of the report and fixing the data until they are all edited so there are only 1's as you come back to the saved report.
Thanks Mark. I ended up creating a report of all records and included that column, then exported it to a spreadsheet and let Excel show me which were the duplcates. :) Would be nice to be able to add that to the Advanced Search funcion....
Related question: when I add a 'group-by column' option to my summary table I'm no longer able to sort from high to low. Am I missing something? Alternatively, is it possible to filter the report to only show summary values >1?