Context:
All my Design cards (for my Designer to work on) are set up as subtask cards to the Story cards (for my Devs to work on)
I am trying to set up an automation to edit the value of the "Blocked by" field of a Story card based on the status of their subtask Design Card.
"Blocked by" is a Select List (Multiple Choices) field, though I can change it to a different type if needed. Default value for that field = (No Blocker)
Requirements
I want the following to happen:
1. If a subtask Design card exists & its status <> Done, then automatically edit the value of "Blocked by" field of its parent Story card to add tag "Design" & remove tag "No Blocker"
2. If a subtask Design card exists & its status = Done, then automatically edit the value of "Blocked by" field of its parent Story card to remove tag "Design"
Implementation Approach
1 ideally gets triggered when a subtask Design card gets created
2 ideally gets triggered when a subtask Design card transitions to status Done
Alternatively, we could set up a scheduled automation to run 1 & 2 every day
Have tried setting this up multiple times but not had success. Be very grateful for your help to point me in the right directions. Thank you!