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

gary1
Executive Chef III
Executive Chef III

Sounds like you need .to_currency

johnw
Executive Chef I
Executive Chef I

is it that simple???

  in the html body of an email I have it set something like this

<strong>PO Amount: </strong>   $<Amount Data Pill><br/>

 

 

gary1
Executive Chef III
Executive Chef III

It all depends on how your email body is written AND if you have more than one dollar amount per email.

If your email only has one amount, I would make a logger or variable, convert it with .to_currency, and then swap the data pill in the email body.

If you don't want to burn the task, then you'll have to switch your email body to formula mode, and use .to_currency on the amount in the body, and concatenate it back together.

If you have multiple values, then it'll probably be a combination of a list or multiple variables to hold the conversions, and then implementing them into the email body.

shivakumara
Executive Chef I
Executive Chef I

Hi @johnw ,

Try with below formulae. Hopefully it solve your problem. 

Just add the data pill in HTML body.  
<strong>PO Amount: </strong>   $<Amount Data Pill><br/>
Amount_2.png

@gary1 ,

You were right, but we need to modify little bit based on the Ask.

Thanks and Regards,

Shivakumara Avadhani

 

Amount_1.png