I have to set the default value of a number field in a Nintex form to 0.00. However, when i do that and publish the form, at runtime, it appears as 0 and not 0.00.
Any ideas on how to do this?
+12
@Nabil1 ....I'm guessing you're using SLT control and allowing Decimal data types. Instead using String data types and put below RegEx in validation and pass the message that only numbers/decimals are allowed.
^[1-9]d*(.d+)?$
Userlevel 6
+22
Hi,
If you configure the control as Currency and use 0.00 as the default it will work.
If you configure the control as Currency and use 0.00 as the default it will work.
+2
So, is it not possible with a number field?
+12
@Nabil1 ....If you're using number list column and in decimal instead of Automatic, if you select 2 then it should work. Make sure that your form control is connected to that column or if you want create a list column first and then add that on the form from the list column list on the left side.
Userlevel 6
+22
On a single lines of text control set to generic if you set the default value to fn-ToLower("0.00") that works as well.
Userlevel 4
+10
Hi,
On you form, in the configuration of you control :
Set the default value to "0.00"
Set the String format to "0.00"
If you must save value to SharePoint, don't forget to configure your sharepoint number field to display 2 decimal
Like :
+2
Thanks a lot Nico.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.