This is a simple thing to do with other workflow products, but I can't seem to find how to do this with Nintex
I have tested this on both Forms for O365 and on premise versions of Forms.
I can confirm that the currency field does not in fact display as currency on edit on both versions and you will need to apply custom java script to do so. You can find references online on how to apply custom java script to a field to change the formatting to currency on edit. Alternatively you can make a feature request to have this piece added to the product on our user voice site here: Customer Feedback for Nintex
However, on display I can confirm that it does not show a dollar symbol nor decimals and commas UNLESS you specify a number of decimal places in Office 365. In on premise versions it is displaying the currency field as expected on display mode as Andrew is seeing.
Here is the configuration for my column on my list (O365):
Here is the result:
When you change this from "2" to "automatic" you receive the following result:
I am currently investigating internally if this issue is a bug or a future implement for forms for O365.
Teddy, Please expand on your question just a little bit so I can better understand where you need to display a currency value. You mention through a workflow product, so I wasn't able to determine when you were using the value.
For list display or form display, if you use a SharePoint field of type Currency, then the decimal, separator, and symbol will be added automatically in the formatting.
When type currency is selected you will see the below options.
Let us know if you need any further information
This isn't working on my form. I have currency fields and in the Nintex form, the currency symbol and the comma separation is not occurring.
Hi Chris, Are you able to make this work? I have the same problem.
Are you talking about on the Edit form? While a field is editing the formatting is not applied.
In the display mode, you should see the formatting.
This is interesting because i'm not seeing it even in Display View mode.
Can you test this in O365? Did you change any default settings of your Money field?
I received a response from Nintex that the currency symbol will not appear until the form is saved. I think this is a bit ridiculous, but it's one of the limitations that until it is saved it will not appear. On edit, it will appear just as numeric values, the formatting shows after it's submitted.
Hi, see the Andrew Beals response below. I don't see it working even after save publish item on O365 app. may be working in on premise versions only.
Just to note, this is the same behavior as adding a value in a currency field on SharePoint new item forms as well. You can even type text into a currency field before it is validated.
Yes, This is exactly I'm getting. I hope its an easy fix in O365 as on premise its working.
Just an update on this issue, In O365 if you have Currency field type under repeating section, it does not display any input with the commas in the view mode even you set 2 decimal places it will not show any commas.
Having the same issue, using a repeating section so had to put a Nintex Single Line Textbox in and set it to currency. Regional settings is a problem(some use "." and some ",") This is a issue on mobile, so when typing in "22.50" and the region is not set to USA, it saves it as 2250. They need to fix this.
Retrieving data ...