Skip to main content

Simulating an action that should happen "when a record is deleted"

  • September 25, 2023
  • 4 replies
  • 178 views

Forum|alt.badge.img+4

Hi, I couldn't find an automation trigger that ignites actions "when a record is deleted".  I have 3 tables interconnected (Projects, Tasks and Allocations), and when a project is deleted I need to delete the associated Tasks and Allocations.  How can I do this?

Thank you since now,

Gustavo Chelles

4 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • September 26, 2023

Hi,
it's an interesting task where you can experiment with new ideas. For example, 'when record matches condition', If you have empty links in Tasks,  Allocations, and modified day of that field different from the day of record creation, it may be your case with removed Project


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 26, 2023

@guchelles

There is no way to monitor for record deletions in Airtable unless you know how to write your own custom programming code and you can figure out how to use Airtable’s extremely complicated webhooks API.

The much easier approach would be to just add a checkbox field (or a single select field) that the user selects when the user wants to delete a record. Then, when the user checks the box (or selects an option), that would trigger the automation to delete records everywhere.

However, the other problem is that Airtable provides no way to natively delete records in its Airtable automations. This would either require writing custom JavaScript code or using Make, which is a no-code automation tool for Airtable that doesn’t require any knowledge of programming code at all.

There is a small learning curve with Make, which is why I created this basic navigation video to help. I also provide the links to a few other Make training resources there as well. For example, to instantly trigger your Make scenarios from Airtable, check out this thread.

 

 


Forum|alt.badge.img+4
  • Author
  • New Participant
  • September 26, 2023

Scott, thank you so much, I will take a look at the tools you have suggested.


Forum|alt.badge.img+4
  • Author
  • New Participant
  • September 26, 2023

Hi,
it's an interesting task where you can experiment with new ideas. For example, 'when record matches condition', If you have empty links in Tasks,  Allocations, and modified day of that field different from the day of record creation, it may be your case with removed Project


Thanks for the suggestion, Alexey, the problem is that I haven't find a "delete record" action in Airtable automations.  It seems a simple feature they could implement.