Re: Deleting records

971 0
Showing results for 
Search instead for 
Did you mean: 
10 - Mercury
10 - Mercury

I’d love to run a task (using Zapier or IFTTT) to do some cleaning up.

Example: update stock and delete related old log records.

Thanks in advance!

5 Replies 5
5 - Automation Enthusiast
5 - Automation Enthusiast

I would really like to delete records using zapier instead of Integromat cleaning up after zapier!

4 - Data Explorer
4 - Data Explorer

This seems like functionality that should have been in the product a long time ago.

Considering that a frequently used zap would entail Unsubscribers in Mailchimp or whatever email automation service… it’s reasonable to expect that in this scenario, the Airtable user would want to simply delete the record, rather than move it or update it or whatever.

That this BASIC functionality was requested 3 years ago and hasn’t been addressed is a little troubling.

11 - Venus
11 - Venus

Hi @Chris_Vacano

You could use Integromat, using the Airtable app in Integromat to delete Airtable records, in a scenario. This update with the Airtable app was released a few months ago.

Then, you could create another scenario to create and update records, all in one scenario.

I have created both scenarios and they seem to work.

Hope this information helps.

Mary K

Probably so.

Database product designer are [typically] quick to come up with a variety of ways to create information, but when it comes to archive policies, janitorial processes, and helping users embrace normalization standards, they typically shrug their shoulders and point to their APIs.

A well-designed data system - especially one that is designed for code-free living - should be prepared to [natively] implement janitorial actions that not only sustain a clean data climate, but also maintain performance. It’s in Airtable’s best interest to assist users concerning the health of their data assets.

In any case, Integromat is certainly an option as is the Airtable API. One of the challenges in data maintenance is performing deletions where dependencies exist and code-less integration tools are less likely to help you avoid creating orphaned records.

10 - Mercury
10 - Mercury

We built a tool that always deletes any record in a certain view. So you can setup a view filter(s) with any criteria that you like and when matching records are detected, they will automatically get deleted.

Automatically Delete Records in Airtable View