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 ?
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.
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
I think the possible way is "regular expression" but I have tried many methods but it was not working.
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
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)
Thanks all very much.