I have a user lookup field on the Account that I want to control ownership for all the Account's Contacts. So for example, if the Account is owned by User1, and my user lookup field says User2, all the Contacts should also be owned by User2. If that lookup field is changed to User3, all Contacts should be reassigned to User3.

I tried to build a workflow rule for this, but it doesn't look like you can change the owner dynamically -- I can trigger the update, but I can't specify the field update to change it to match the lookup field (have to specify one user to change to).

Is this only possible via a trigger?

  • 2
    Have you tried using Process Builder/Flows?
    – sfdcfox
    Feb 25, 2016 at 17:27

1 Answer 1


This can easily be accomplished through Process Builder.

  1. Select object type of Account.
  2. Select criteria of ISCHANGED(MyUserLookup__c).
  3. Select action of Update Records > Related Records > Contacts.
  4. Select field of OwnerId.
  5. Select value from Account of MyUserLookup__c.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.