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:
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
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.