How can i remove duplicate records by email adress?

[zerem]

hey
i have problem with my automation from MAKE and it move duplication of records.
i want to know how can I delete duplicates by email?
i mean - check for any duplicated email, delete all row.
Thanks!

[Soly]

Welcome to the Airtable Community @zerem !

I would suggest to use the Dedupe extension to fix this.

support.airtable.com

Dedupe Extension | Airtable Support

The dedupe extension helps you find and manage duplicate records in a table. You can delete duplicates or merge individual fields from...

I hope that helps :slightly_smiling_face:

[ScottWorld]

@zerem

Some options for you:

1. As @Soly said above, you can use Airtable’s DeDupe extension, which was specifically designed for these purposes.

2. You can always custom-create your own automation with Make’s Airtable integrations to search for duplicates and remove them.

3. You can use the method that I describe in this Airtable podcast episode.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld