Skip to main content

Auto-deleting records?


Hi there,

I have a Projects table and a Tasks table, as laid out in the Project Management demos from AirTable.

When a Project is completed, we check the “Complete” checkbox and that moves it from the Upcoming Projects view to the Past Projects view (which are simply the same tables, but with a filter based on the Complete checkbox).

However, when a project is completed, I’d like for all the linked tasks in the Tasks table to be deleted. Not moved to another place, but actually deleted.

Is there a way to automate this?

Nickie

6 replies

Forum|alt.badge.img+3
  • Known Participant
  • 24 replies
  • September 6, 2018

Using integromat. You could search for all records in that table that have that checkbox set to true, and then delete all the of tasks that belong to that project.

It has a pretty good first free tier, and a lot cheaper than zapier.


  • Author
  • Participating Frequently
  • 6 replies
  • September 7, 2018
Jacob_Turley wrote:

Using integromat. You could search for all records in that table that have that checkbox set to true, and then delete all the of tasks that belong to that project.

It has a pretty good first free tier, and a lot cheaper than zapier.


Thanks Jacob. You’re right, to do this in Zapier I’d have to pay because it’s a three-step scenario.

I’m looking at Integromat now.

I’ve created the initial step where Integromat watches the Past Projects view in order to see when new records are added.

How do I do the second step that searches for all the tasks that belong to that project?

Nickie


Forum|alt.badge.img+20
  • Inspiring
  • 614 replies
  • September 7, 2018
Nicola_Rudolf wrote:

Thanks Jacob. You’re right, to do this in Zapier I’d have to pay because it’s a three-step scenario.

I’m looking at Integromat now.

I’ve created the initial step where Integromat watches the Past Projects view in order to see when new records are added.

How do I do the second step that searches for all the tasks that belong to that project?

Nickie


Hi

Integromat has a Facebook page for posting inquiries, such as yours. You can also contact support by email, although, you may have to wait a while to get a response.

MK


Forum|alt.badge.img+15
  • Inspiring
  • 368 replies
  • April 2, 2020

We built a tool that automatically deletes all records within a view. So you can set any filter combination you like and it will always delete anything that gets added to that view. For example it can be used to delete: completed tasks, old records, empty records, etc.


Forum|alt.badge.img+1
  • New Participant
  • 1 reply
  • September 15, 2020

Hi!

Is there a way of doing it directly in Airtable (adding a custom script or settings somewhere?).
Like: if records is X days old => delete it.
Or: when I reached the max amount of records for my plans, delete records?

Or should I use Airtable API to GET the number of record then DELETE the ones that I want?
Also, in zapier, I don’t see a task delete (only update/create/search records). Am I missing something? Should I use custom request + Airtable API if I want to use zapier?


Forum|alt.badge.img+1
  • New Participant
  • 2 replies
  • February 1, 2023
Moe wrote:

We built a tool that automatically deletes all records within a view. So you can set any filter combination you like and it will always delete anything that gets added to that view. For example it can be used to delete: completed tasks, old records, empty records, etc.


You should provide the option to buy extensions individually because $120/month is way too much.

Pipedream have an automation and their free plan would cover most peoples needs https://pipedream.com/apps/airtable/actions/delete-record


Reply