Skip to main content
Nintex Community Menu Bar

How to add thousand decimal in number of task email ?

  • May 7, 2018
  • 5 replies
  • 56 views
  • Translate

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

Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+16
  • 914 replies
  • May 7, 2018

You should write your email on a workflow.

Take a look at  

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 464 replies
  • May 7, 2018

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.

Translate

bamaeric
Forum|alt.badge.img+13
  • Apprentice
  • 464 replies
  • May 8, 2018

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

Translate

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.

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings