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!
Creating automation for deleting duplicates
+1
+6I 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)
let table = base.getTable("Tasks");
let inputConfig = input.config();
let recordId = inputConfig['recordId']
await table.deleteRecordAsync(recordId);
Third Action: Update record. It is conditional based on whether or not there's already an attachment in the attachment field, but the basic functionality is the same in both cases: Update the found record from Action 1 with the attachment that was uploaded via the form and mark the task completed. (This does work even though you've technically already deleted the new record in Action 2.)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.