Hi all,
I have a textbox control with the following configuration:
Datatype:Decimal
Style: Language English (US)
Does anybody know a solution for this issue?.
Thank in advance.
Solved
Textbox control removes comma
Best answer by RaymondJVR
Good Day AVI
You merely need to turn off the formatting to allow the value entered to format to its default data type (decimal).
Please follow these steps:
1) Select the control
2) Navigate to its styling properties and edit the styling
3) select the "None" option in the styling
4) Test again.
*Note: Using a comma (,) as the decimal seperator might fail on default control validation (Invalid decimal value entered) in which case you need to use a period (.) instead of a comma
Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.
Kind Regards
Raymond
HI AVI,
What expect behavior for you? Do you want to make comma for separate number? if yes, you just check 'use 1000 separator' option for make it.
I tested on my end when inpit 12,45 to textbox it change to 1,245.00, So this is expect behavior.
What expect behavior for you? Do you want to make comma for separate number? if yes, you just check 'use 1000 separator' option for make it.
I tested on my end when inpit 12,45 to textbox it change to 1,245.00, So this is expect behavior.
Hi Macky,
I expect no change the value enter by the user.
The configuration of the control is uncheck '1000 separator' (see image).
Simply, K2 form removes the comma character. if I enter 12,45, I can explain the value 12450 because comma is the separator, but I cannot explain 1245, the real value stores by k2.
Regards and thanks.
You can perhaps change the data type to a string and instead use a pattern validator to tell the user that they didn't enter a valid number in the scenario you've described
+13- Nintex Employee
- Answer
Good Day AVI
You merely need to turn off the formatting to allow the value entered to format to its default data type (decimal).
Please follow these steps:
1) Select the control
2) Navigate to its styling properties and edit the styling
3) select the "None" option in the styling
4) Test again.
*Note: Using a comma (,) as the decimal seperator might fail on default control validation (Invalid decimal value entered) in which case you need to use a period (.) instead of a comma
Should you feel that this post is of use and or an accurate solution to the raised question, I kindly encourage you to mark it as such using the 'Mark as Solution', 'Kudo' andor ‘Me Too’ options.
Kind Regards
Raymond
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.