I want to update my Episode Task status based on the related Tasks for Shots in the Episode, i. e. when all Episode Shot Tasks at a given step (say, Layout) are approved, set the Episode Layout Task status to
I did that once based on Task status updates, checking all Shot Task statuses every time one of them was set to
apr… needless to say it wasn’t my best idea, as the event handler had to face huge queries.
Now I wonder if it would be possible to use the summaries as triggers, so I would only use their value to update my Episode (and if so, how?).