I'm building a project management platform. In my current configuration, there is a table for Projects, and another for Tasks.
When a Project is created, an automation runs to add corresponding Tasks.
The Project table has a "Status" field, with options for In Progress, On Hold, Canceled, and Done.
When a Project status is changed from In Progress to On Hold, I added an automation that also changes the status of the underlying Tasks to On Hold (so the individuals to whom those tasks are assigned now to pause work on them).
But how would I create an automation to switch that Task status back to In Progress if the parent Project status is changed back?
If I set the trigger to be "when record in Project matches conditions (status = In Progress), it's going to update a lot of tasks that should be updated.
Is there a scripting solution for "if a project was On Hold and now is In Progress, change all underlying Tasks statuses that were On Hold to In Progress"?
