Append to current data value with multiple tokens?

Highlighted
Level 7 - Champion Alumni

Append to current data value with multiple tokens?

Can someone provide the proper syntax for if I want to append data value to the end of my current field value?

Example: Product Interest => New Value "{{lead.Product Interest}}; MultiVu: {{system.date}}

Is this possible?

5 REPLIES 5
Highlighted

Re: Append to current data value with multiple tokens?

Hi Geoff,

Just have the 2 tokens side by side. e.g. New value: {{lead.Product Interest}} text {{system.date}}

-Greg

Highlighted
Level 7 - Champion Alumni

Re: Append to current data value with multiple tokens?

Do semicolons mess with the syntax?

I ask because that field (in SFDC) has a set syntax with the semicolon.

Highlighted
Level 7 - Champion Alumni

Re: Append to current data value with multiple tokens?

Or any other punctuation (like in Regex) for that matter?

Highlighted

Re: Append to current data value with multiple tokens?

Hi Geoff,

This means that it is a multi-valued field in SFDC. You'll have to run a test, I haven't tried to edit it in Marketo Change data values for a very long time and I do not remember

I would bet it works to do add the semi-colon and the additional value.

Keep us posted!

-Greg

Highlighted
Champion Moderator

Re: Append to current data value with multiple tokens?

The syntax look Ok. But, Instead of adding the data at the end, I would suggest to prepend it. This way, if there is char limit on the field, it will have the latest values and will truncate the old values. So the toekn will look like

Product Interest => New Value "MultiVu: {{system.date}};{{lead.Product Interest}}"

It's always recommend to have a separator like semicolon (;), pipe (|) etc. it will have you to programmatically separate the old vs. new values for reporting purpose.