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?
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')
If you’re not on a Pro plan, the best you could do is clear the fields I’m afraid: