cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i format the number type in Nintex Forms seperate by ","

Jump to solution

Dear all,

I used Nintex Forms for develop my application. I have one list with column with number type, when I input value long length (ex: 123456) and save, then the number will display in view is 123,456. When I viewed in Nintex Forms, the number cannot display like this, when I create one list with SharePoint standard, the format is 123,456. Can you help me?

 

Thanks!

Labels: (2)
Tags (1)
0 Kudos
Reply
10 Replies
christopheraucq
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

Hi Bill,

I have tried in SP 2013 online.

It displays the coma.

Which versions are you using (SP, Nintex)

Regards,

Christophe

0 Kudos
Reply
mlauer
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

Hi Bill

 

in Nintex Forms You have to use a formatting string for numbers:

 

It's descibed in Nintex Help. For more information about string format see Custom Numeric Format Strings

 

Kind regards

Manfred

0 Kudos
Reply
Not applicable

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution


Thank Manfred,

I solved my problem with your suggest!

P/s: I found in the Nintex Forms Help document about String Format of Single Line Of Text field:

String Format: The string format to apply to the value. The string format will be determined by the type of data
specified by the control. When it is a number the following can be used http://msdn.microsoft.com/enus/library/0c899ak8.aspx, and http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx. For other types see
http://msdn.microsoft.com/en-us/library/26etazsy.aspx

Thank again!

0 Kudos
Reply
bhutim
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

Hi Manfred and Bill

I have a same situation with a field that is a number format and in SharePoint I have configured it to have 2 decimals. While the user types the value in the field I want to format so that the user be sure that they have entered the correct value.

I have tried the ideas above applying to my field but it doesn't happen in the client, is there something I am doing wrong?

Thank you

Regards

Bhuti

0 Kudos
Reply
steven_parker
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

Can you do something similar in Nintex 2013?  I don't see the "String Format" under Advanced for the single line textbox I am working with.  That must have been something they added to O365 Nintex.

0 Kudos
Reply
emha
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

it appears there if you change datatype to integer or decimal

0 Kudos
Reply
sscrush
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

The only reason you are able to change the datatype is because you don't have it bound.  This isn't helping.

0 Kudos
Reply
emha
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

or if the datatype of connected field is numeric

Reply
cmikhaiel
Nintex Newbie

Re: Can i format the number type in Nintex Forms seperate by ","

Jump to solution

I've been trying this solution and this Forms - Display numeric fields with thousands separators   an no matter the type, currency, number, single line of text.. it doesn't show the correct thousand separator while the user is inserting the data..

what am I doing wrong?

0 Kudos
Reply