Re: Append to current data value with multiple tokens?

Geoff_Krajeski1
Level 10 - 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
Grégoire_Miche2
Level 10

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

Geoff_Krajeski1
Level 10 - 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.

Geoff_Krajeski1
Level 10 - Champion Alumni

Re: Append to current data value with multiple tokens?

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

Grégoire_Miche2
Level 10

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

Amit_Jain
Level 8 - Community Advisor

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.