โ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-19-2024 07:24 AM
but either way my whole email body would have to be converted from html to a formula, correct?
โ07-19-2024 08:46 AM
You can do it two different ways.
If you do the conversion in a variable before the email action, you can do this:
If you do the conversion in the message itself, you will need to make it a formula like this:
โ07-19-2024 08:54 AM
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
โ07-19-2024 09:33 AM
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.
โ07-19-2024 12:09 PM
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