Re: Append to current data value with multiple tokens?

Geoff_Krajeski1
Level 10 - Champion Alumni

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
Amit_Jain
Level 8 - Community Advisor

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.

Grégoire_Miche2
Level 10

Hi Geoff,

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

-Greg

Geoff_Krajeski1
Level 10 - Champion Alumni

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

Grégoire_Miche2
Level 10

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

Geoff_Krajeski1
Level 10 - Champion Alumni

Do semicolons mess with the syntax?

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