Skip to main content
Michael Dely a posé une question dans #Collaboration
Hey Community, 

 

I want to create a formula field pulling a picklist from a contact to another contact.  We do not incorporate the Household thru traditional means, so I am looking for a work around.  We treat one of the contact records as the head of household and the others as secondary members.  The head of household ALWAYS has a picklist selection of "Client" or " Advisor" and everything else has "Family Partner."  Is there a way for me to have a formula field that pulls a particular field from the Client or Advisor onto the Family Partner?  Please let me know how this can be done. 

 

Thanks, 

 

Mike 
60 réponses
  1. 30 avr. 2020, 05:46
    I'm assuming the household members are still linked via the same account, right? 

     

    You'd start by building the flow. First, create 3 variables:

     

    The contact ID (ContactId) 

     

    The account ID (AccountId) 

     

    The new picklist value (I don't know what you call it - so it's your choice)

     

    All variables should be text. All variables should be marked as available for Input. 

     

    Now the flow itself is stupidly simple. Drag 1 Update Records step, and select to update records by criteria. Select the contact object. The criteria should be that the account ID is equal to the AccountId variable, but the record ID is not equal to ContactId. Then, update your picklist field to be set to the third variable. 

     

    You're done with the flow. 

     

    Next, build a process on Contact. Set the criteria to detect a change to the picklist for the head of the household only(!). Add a flow action, and pass the new picklist field, record ID, and account ID into the relevant flow variables. 

     

    That should do it :)