Skip to Navigation

Reply to comment

The easiest way to find places where the same value is used in the same field across multiple records is to use a Summary report. To create one, you can:

1. Choose a table from the Table bar.
2. Click REPORTS & CHARTS to open the reports panel, then click + New.
3. In the dialog, select Summary and click Create.

Now set the view properties to the following:

1. Under Grouping and crosstabs, set Group by to the field you want to identify duplicate entries for.
2. Under Sorting, choose Custom order.
3. Change the Sort by line so it reads: Sort by # of (items) from high to low.

When you click Display, you'll see a table that has two columns: the field values in the first column and the number of times that field's value has been entered across all records. At this point you can click on the field values to get a list of each record that has that specific field value.

To learn more about Summary reports in general, please see our About Summary Reports help topic.


The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 2016 QuickBase, Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit