- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 12, 2023 04:45 AM
Hi,
I want to write a script that automatically deletes duplicates as soon as something new is added to the table. Basically it should work similar to the Dedupe extension, but be automated to save time.
I only want to delete rows which are identically in each field. It's my first time trying to automate a function with Airtable. I would appreciate if any one has some ideas how to get started with the script or maybe has even written something similar before.
Thank you for your help!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 01, 2023 08:22 AM
Did you ever find a solution? I'm looking for a similar solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 21, 2024 09:00 PM
same here

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 25, 2024 11:55 AM
I was able to find a solution that worked for my situation. In my case, the trigger is a form being submitted. I'm not sure how you would manage it if you're entering the data directly into an Airtable base.
Here's my steps:
Trigger: When a form is submitted
First Action: Find records where Task Record ID is Parent Record ID (we prefill the form so that these two will always match)
Second Action: Run script. (I found the base script in another thread, but I don't have that one handed right now)
