I'm looking for a way to run an action on another child of the grandparent object. For example: when a specific release milestone task ('Deploy to Prod') is complete, I want to prompt and run an action in all Change records that are linked to the Release. The Release is the grandparent of the task, and the Changes are other children of that release.
What I'm hoping to do could be triggered from a status change on the parent Release (when closed, run this action on the linked Changes), but I really want to trigger it from a prompt when the Milestone task is completed - 'Yes' would run one action on the linked changes, 'No' would run another.
Can this be done?