See the Custom fields report

The Custom fields report shows how a custom field's values are spread across your records — how many records hold each value, and which records those are. It's the quickest way to audit a field: spot typos and duplicates, see how often a value is used, or find every record with a particular value.

Where to find it: Reports → Custom fields

Before you start: you need at least one custom field defined. See Create and manage custom fields.

Read the report

1. Pick a field from the dropdown at the top (fields are listed alphabetically, with the record type they apply to).
2. The summary shows Records with a value, the number of Distinct values, and the Field type.
3. The table lists each value with:

   • Value — the stored value.
   • Records — how many records have that value.
   • % of valued — that value's share of all records that have any value.

Counts reflect live records only — deleted records aren't included, and each record is counted once.

Find a value

Type in the Search values box to narrow the list. Search looks across every value for the field, not just the ones currently on screen, so you can find a value even when the field has thousands of distinct entries.

See which records use a value

Click a value to open a list of the records that hold it. Each record links straight to its page, so you can jump in and review or fix it. For values shared by a very large number of records, the list shows the first 2,000.

Export

Use the download button to export the current distribution as a CSV.

Related

• Create and manage custom fields
• Export, filter, and drill into a report