Select Page
How to Find and Remove Duplicates in Your Airtable Records
How to Find and Remove Duplicates in Your Airtable Records

How to Find and Remove Duplicates in Your Airtable Records

Here’s how you can find (and remove) duplicates in your Airtable records.

The specific integration, On2Air Amplify, in this tutorial is no longer being developed as we focus on On2Air Backups, automated backups for Airtable.

Find and Remove Duplicate Records

You can check for duplicates in certain field types. You can specify which field you want to check for duplicates.

  • To check for a duplicate, add the
    Current Record Editor
    Current Record Editor
    in your Amplify layout
  • Open the Editor Settings and for each field where you want to check for duplicates, enable the Check for Duplicates setting

image

  • Go to your record and find the field you want to check for duplicates.

image

  • Click the Duplicates icon above the field and it will bring up a list of other records that have the same value for that field.
    • If no Duplicates are found, you'll see a No Duplicates found notice below your field

image

Video - How to Find Duplicates in Your Airtable Records