Display a string field with multiple values as a bulleted list in an email

Anonymous
Not applicable

Display a string field with multiple values as a bulleted list in an email

I am using a custom string field to capture values for a weekly webinar. It is possible to select more than one since the topics will change from week to week. Everything is working properly but I need to know how to display the field as a bulleted list or even in a dynamic table that creates a new row for each value in the event that someone selects multiple dates.

At the moment when we use the merge field the values are seperated by a semi colon (;) producing an ugly appearence like this:

July 13 - Office365;July 26 - topic;August 15 - topic;etc;etc

- Does anyone have a nice solution for this?
Tags (1)
2 REPLIES 2
Josh_Hill13
Level 10 - Champion Alumni

Re: Display a string field with multiple values as a bulleted list in an email

That is how Marketo handles multi select input or concatenation.

You can use CONTAINS to search for the correct value.

Not sure there is a good solution right now. There was a thread about this, but the coding turned out not to work because of the type of field and the API.
Jep_Castelein2
Level 10

Re: Display a string field with multiple values as a bulleted list in an email

Jay, you may be able to use email scripting for this. It uses the Velocity scripting language, which allows you to split strings by a delimiter using the parseStringList and setStringsDelimiter functions:

https://velocity.apache.org/tools/devel/javadoc/org/apache/velocity/tools/generic/ConversionTool.htm...

The string function returns an array, which you can then format any way you want. 

This does require some scripting/programming skills. You need to load the ConversionTool, as shown on the bottom of the docs: http://developers.marketo.com/documentation/email-scripting/