Concatenate a related child object picklist values to a multi-select picklist value on the parent

Chooper — Thu, 07 Sep 2023 14:50:12 GMT

Is there a way in DemandTools to concatenate a related child object picklist value to a multi-select picklist value on the parent? I thought I could with Modify, however I can't find the solution.

Re: Concatenate a related child object picklist values to a multi-select picklist value on the paren

AnthonyValidity — Thu, 07 Sep 2023 17:25:55 GMT

Hi @Chooper ,

Yes, you are able to add multiple values to a multi-picklist from the child object to the parent object in Modify. Since DemandTools 5.x can only look up to related objects, you would choose the child object in step 1.

In step two, you would write a formula that is updating the parent object, and if there are values already on the parent object's picklist, you would want to reference that field in the formula. Example:

CONCATENATE(${Account.Fruit__c}, ";", ${Account_Score__c})

The multi-picklist field on my account is called Fruit. It already had a few selections, but I wanted to add the value found in the Account Score (I know doesn't make sense but stay with me). I referenced the original field in the formula, and then added a semi-colon in quotes as one of the values that I'm adding.

Hope this helps!

topic Re: Concatenate a related child object picklist values to a multi-select picklist value on the paren in DemandTools

Concatenate a related child object picklist values to a multi-select picklist value on the parent

Re: Concatenate a related child object picklist values to a multi-select picklist value on the paren