cancel
Showing results for 
Search instead for 
Did you mean: 
Nabil1
Nintex Newbie

How to set 0.00 as default value in a form field

Jump to solution

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?

Labels: (1)
0 Kudos
Reply
7 Replies
kunalpatel
Automation Master
Automation Master

Re: How to set 0.00 as default value in a form field

Jump to solution

@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+)?$

Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to set 0.00 as default value in a form field

Jump to solution
Hi,
If you configure the control as Currency and use 0.00 as the default it will work.
Reply
Nabil1
Nintex Newbie

Re: How to set 0.00 as default value in a form field

Jump to solution

So, is it not possible with a number field?

0 Kudos
Reply
kunalpatel
Automation Master
Automation Master

Re: How to set 0.00 as default value in a form field

Jump to solution

@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.

0 Kudos
Reply
SimonMuntz
Nintex Employee
Nintex Employee

Re: How to set 0.00 as default value in a form field

Jump to solution

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.

0 Kudos
Reply
nico
Nintex Newbie

Re: How to set 0.00 as default value in a form field

Jump to solution

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 : 

Configuration Forms controlConfiguration Forms controlSharePoint list viewSharePoint list viewDisplay exempleDisplay exemple

View solution in original post

Reply
Nabil1
Nintex Newbie

Re: How to set 0.00 as default value in a form field

Jump to solution
Thanks a lot Nico.
0 Kudos
Reply