Help

Deleting related fields from another table

686 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Aaron_Preston
4 - Data Explorer
4 - Data Explorer

I have 2 tables linked, one with job information (primary) and one with finance, when i delete one from the job information table the finance table still has its relevant data (information not linked to original).

Is there a way of automatically deleting the one when the other is deleted?

Thank you

3 Replies 3

There’s no built-in way to do this. This can only be done with a custom JavaScript (which you could automate via Airtable’s Automations), or with an external automation tool like Make.com, or manually.

Hey Aaron, as @ScottWorld said, you can run a script in an automation to delete a record once it’s no longer linked if you’re on a Pro plan. Here’s a working version of said script that you’ll need to customize:

let inputConfig = input.config()
let table = base.getTable('Table 2')

table.deleteRecordAsync(inputConfig.recordId)

automation delete

If you’re not on a Pro plan, the best you could do is clear the fields I’m afraid:

automation clear

I’ve set up both here for you to check out

Thank you for the clarification… Not going to lie… at this stage thats beyond my capabilities :joy: