Is there a way to automate the deletion of a record in a table when certain conditions are met?
Welcome to the community, @jjbachar1!
Yes, but you would need to write a script for that by using the “Run Script” automation action.
Below is an automation script you can use, but be sure to take a look at my screenshot below for how to set this up, because you’ll need to setup your input.config variables in the left margin.
Also, note that you will need to hardcode in the name of your Table in the script below.
let inputConfig = input.config();
let recordId = inputConfig.myRecord;
let table = base.getTable("Table Name Here");
await table.deleteRecordAsync(recordId);
Alternatively, if you’re looking for a no-code way of automating the deletion of Airtable records, you can use Make’s automations & integrations. They offer the ability to delete Airtable records, along with the ability to upsert records, integrate with other apps, and much more.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
