302 Found

Found

The document has moved here.

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How can I find duplicate values in a specific field?

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.

You can read more about Summary reports here: http://www.quickbase.com/user-assistance/#about_the_summary_view_page.html

Comments

Post new comment

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.
302 Found

Found

The document has moved here.