when a field is showing a value of 0 or 1 what is the best way to add a description?

Question

Hi, I am looking to set up an email using tokens. the problem I have is that the field in Salesforce is returning a value of 1 instead of the name of the field.

for example, I want the email to say thank you for purchasing brand1 - the field in salesforce for brand1 if they have purchased brand1 is 1.

What would the best way to approach this?

My thoughts would be to create a pick list field in Marketo and display the brand name desired if brand1 = true [1]. I haven't quite figured the logic yet.

Would there be a better way to approach this, I don't have the option to change the original field.

Thanks

Michael_Florin-2 · Accepted Answer

This would be a use case for Dynamic Content. Dynamic Content can be done by Segmentation and Snippet or - and that could be the appropriate option here - by Script Token aka Velocity.

https://experienceleague.adobe.com/en/docs/marketo/using/product-docs/email-marketing/general/using-tokens/create-an-email-script-token

Take a look at this documentation to understand the basics, and then probably start with a simple script like this:

#if ($lead.brand1.equals("1"))
Brand 1
#else
Brand 2
#end

You can see the result of your scripts in personalized Email Preview or by sending test emails to yourself.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded