Currency token and decimals...in a snippet

[Dan_Stevens_]

Hi Greg - we use program tokens to display the current year in our email footer snippet:

...even though the email isn't physically located in a program (but the "send" smart campaign is).

[Anonymous]

Hello,

I need to display a currency database value in an email snippet.  I've inserted this value as a token.  However, when I send my test emails,  trailing zeroes are eliminated. 

For instance:

• A field containing "1.50" in the database is displayed as "1.5" in the email
• A field containing "1.00" in the database is displayed as "1" in the email

I understand there are velocity scripting solutions to format this number.  However, I don't think you can use velocity script tokens in a snippet?  Is there a way to have the token just be displayed as it appears in the database?

I'm thinking I may need to re-create the entire snippet logic in a velocity script?

[Grégoire_Miche2 · Accepted solution]

Hi Matt,

You cannot use a program token in a snippet, AFAIK (See and vote here: ​), so you will have to go full velocity, I am afraid.

The other possibility would be to use a proxy text field that you would populate from the currency field, for instance with a webhook.

-Greg

[Dan_Stevens_]

Hi Greg - we use program tokens to display the current year in our email footer snippet:

...even though the email isn't physically located in a program (but the "send" smart campaign is).

[Grégoire_Miche2]

Hi Dan,

Nice one. Therefore the idea above is useless, then. I was trusting it. The Buffet Formula : going to bet smarter than you woke up.

If a program token works in a snippet, then a velocity one should as well.

-Greg

[Anonymous]

Thanks for your response - I ended up just making that field a string.  While it's not great if I ever need to run operational logic against the value, this program didn't require it.