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?