โ07-18-2024 01:33 PM
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
Solved! Go to Solution.
โ07-19-2024 01:06 PM
โ07-18-2024 01:40 PM
Sounds like you need .to_currency
โ07-18-2024 01:48 PM
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/>
โ07-18-2024 01:55 PM - edited โ07-18-2024 01:56 PM
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.
โ07-19-2024 07:17 AM - edited โ07-19-2024 07:21 AM