I would like to be able to trigger workflows off a change to the Primary Contact Name associated with an Opportunity. For example, we might initially have one person listed as the primary contact for an opportunity, but then the primary contact changes as the deal progresses. I would like to be able to seamlessly "reassign" an existing opportunity to a new primary contact and maintain all deal history.

Changing the Primary Contact Name today breaks various automations that use the "Find Opportunity" function as it requires that other fields like email address and opportunity name also be updated. Ideally, I would be able to run an automation that detects a change to the Primary Contact Name, and then updates the corresponding primary email address and opportunity name accordingly, enabling the opportunity be found in the system.