cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

convert number to currency in emails

johnw
Executive Chef I
Executive Chef I

after POs are booked and my recipe sends emails out to Sales and OMs to let them know what happened the prices are hard to read since there is no formatting.

for example they see:

Op Amount: $3891266.55 (USD)

they would like to see:

Op Amount: $3,891,266.55 (USD)

this seems like it's an easy ask but I can't figure it how to do it

thanks

john 

 

1 ACCEPTED SOLUTION

gary1
Executive Chef III
Executive Chef III

Haha, yeah that's how it works! This is all one task:

variable.jpg

View solution in original post

12 REPLIES 12

johnw
Executive Chef I
Executive Chef I

but either way my whole email body would have to be converted from html to a formula, correct?

gary1
Executive Chef III
Executive Chef III

You can do it two different ways.

If you do the conversion in a variable before the email action, you can do this:

email_2.jpg

If you do the conversion in the message itself, you will need to make it a formula like this:

email_1.jpg

johnw
Executive Chef I
Executive Chef I

oh so i change my existing body to a formula field and put "" around all the existing html code and do + wherever I have a data pill

gary1
Executive Chef III
Executive Chef III

That's pretty much it. In my opinion, it's easier and cleaner to do the conversion in a variable and insert it into the text (option 1 above). I'm splitting hairs over a single task, but it makes the email body easier to read and update.

johnw
Executive Chef I
Executive Chef I

we currently have 5 different price fields in the email but maybe I could get creative and create a single variable with all the different price fields formatted with line fields and then add that