Changing Data Value - Add on to a value?

Anonymous
Not applicable

Changing Data Value - Add on to a value?

I have a field in Salesforce.com I'd like to update. It's a multi-select picklist field which means you can add multiple values to it.. for example:

Super-cool-field-name: Product 1, Product 2

I want to use Change Data Value to add "Product 3" to the existing values instead of overwriting the value that's there. Is this possible??

Tags (1)
3 REPLIES 3
Josh_Hill13
Level 10 - Champion Alumni

Re: Changing Data Value - Add on to a value?

I'd test this on one lead before you get to far ahead of yourself. I have a bad feeling it might overwrite it.
Jep_Castelein2
Level 10

Re: Changing Data Value - Add on to a value?

Hi Eric, 

You can do this as follows:
  • Create a Marketo-only field "append this"
  • Change data value, attribute "append this", new value "Product 3"
  • Change data value, attribute "super-cool-field-name", new value: {{lead.super-cool-field-name}}; {{lead.append this}}


The result will be "Product 1; Product 2; Product 3", which will show up as multiple values in SFDC. 

And yes, test this carefully before going into production. A typo could cause data loss. 

Best, 

Jep
 

Anonymous
Not applicable

Re: Changing Data Value - Add on to a value?

Jep, i would love to be able to implement your suggestion above. we are having the same problem with our multi select drop downs in Dynamics CRM. WE are however, new to Marketo and i cant quite follow how to do wht you are suggesting, could i trouble you for instructions for the newbies?
your help would be greatly appreciated.