cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

How to add thousand decimal in number of task email ?

Hi all,

I have created a nintex form, after user finish to fill the nintex form, I want to insert number fields with thousand decimal of the form into notification email. Is there any way I can do that ?

notification email, number

Tags (1)
Reply
5 Replies
Workflow Hero

Re: How to add thousand decimal in number of task email ?

You should write your email on a workflow.

Take a look at  

Accept as Solution Reply
Workflow Hero
Workflow Hero

Re: How to add thousand decimal in number of task email ?

Eric Rhodes

Thanks for your suggestions. I have formated correctly both Nintex Form number fields and Sharepoint columns. They show the correct number with thousand separator as below image.

notification email, number

Fernando Hunth

But when I insert the variable was stored number into the email body, it was not have thousand separator, I have used "Build String" to build custom HTML body

html body

I think the possible way is "regular expression" but I have tried many methods but it was not working.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: How to add thousand decimal in number of task email ?

In your workflow, try adding a "Set Variable" action and configure it like the screenshot below.  It takes a number list column, formats it as currency, and saves it into a text workflow variable that can be used in the email. Make sure to click the three dots (...) beside the Field selection to select the return type.

Here's a good post to use if you need to remove the decimals: How to email currency with thousand separator but not decimals

Accept as Solution Reply
Workflow Hero

Re: How to add thousand decimal in number of task email ?

Eric Rhodes

Thanks for your tip. I have done successful. Based on your tip, I have figure out the simple way.

- Build String > Advanced Lookup > Current List Item > Select the column contain the number > Select return type > Formatted Currency (as image)

return type, currency

Thanks all very much.

Accept as Solution Reply