razvanhr
Nintex Newbie

Comma in Text Field always multiplies number by 10

Jump to solution

Hello all,

I am facing a behavior which in my opinion is more of a usability issue than a help:

I have a text field (single line of text) which is connected to a SharePoint Column defined as Number, with 2 decimal places. Whenever I input a number such as 1000,5 the number is transformed automatically into 10005. Validation and regular expressions do not seem to work to stop this behavior. When using a dot however like 1000.5, the number is correctly stored as 1000,5. Is this somehow related to the locale of the site I am in or is this a Nintex setting that I can turn off? My users are getting really pissed because over here we do not use the dot for separating decimals but the comma -> you can imagine the problems this is causing.

So does anybody know which setting is responsible for this and how I can turn this off?

0 Kudos
Reply
5 Replies
shrinivasnaik
Workflow Veteran

Re: Comma in Text Field always multiplies number by 10

Jump to solution

Hi Razvan,

If you try changing your column type from number to currency in SharePoint and then select the format of the currency for your particular locale then SharePoint itself would validate how the format of the currency should be.

Regards,

Shrini

Reply
burkslm
Nintex Newbie

Re: Comma in Text Field always multiplies number by 10

Jump to solution

I don't believe you are supposed to be entering commas in a number defined field. If I'm not mistaken the commas will automatically appear for you. Does this have to be defined as a Number field. Why not keep it a text field and then use Reg Edit or Replace()?

Reply
razvanhr
Nintex Newbie

Re: Comma in Text Field always multiplies number by 10

Jump to solution

Hi Shrini, thanks for that idea, I will give this a try although my requirement is that no commas or dots or whatever should be accepted as an input value. Basically I want integers  Is there no other way to do this but to use currency? It has 4 digits accuracy after the decimal point, I don't really need that kind of precision.

View solution in original post

Reply
razvanhr
Nintex Newbie

Re: Comma in Text Field always multiplies number by 10

Jump to solution

Hi burkslm, actually you can - I am actually experiencing this behavior and it is quite acceptable when you need the decimal precision. However I do not need these, basically I need integers. Validation with regex does not "see" the comma  [0-9]+ even if it is there - quite weird behavior.

Replace is a good idea, however I consider this to be basic functionality and it should be doable without JavaScript. If nothing else works I suppose I will have to give that a try.

Reply
emha
Automation Master
Automation Master

Re: Comma in Text Field always multiplies number by 10

Jump to solution

not sure how did you test, but regular expression definitely rules out dot and comma characters

0 Kudos
Reply