Changing Data Value - Add on to a value? | Community
Skip to main content
February 5, 2013
Question

Changing Data Value - Add on to a value?

  • February 5, 2013
  • 3 replies
  • 1987 views
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??

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Josh_Hill13
Level 10
February 6, 2013
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
February 6, 2013
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
 

July 24, 2013
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.