How to enter the comma in the numbers?

  • ConnexPay
    Asked on April 19, 2024 at 1:46 PM

    I need to be able to capture currency/numeric values following the format:

    999,999,999,999

    The number widget will not work because the commas can't be formatted. And when currency is set to the validation, it does not allow for billions.


    I then tried the Masked Input Field widget. I'm able to get the commas to appear automatically, but they start based on positioning from the left instead of the right. For instance,

    when i enter 1234 - the comma is automatically place as 123,4. I need it to be three positions from the right 1,234. Please advise - thanks.

    (this widget is currently active near the top of page 8 in our form linked below)


    How to enter the comma in the numbers? Image 1 Screenshot 20

  • Gaud JotForm Support
    Replied on April 19, 2024 at 2:29 PM

    Hi ConnexPay,

    Thanks for reaching out to Jotform Support. I’m really sorry that this is happening. I'll do my best to help you. You won't be able to add the comma separator to the Number field. You won't be able to change the direction of the comma from the right using the Masked input widget.

    I suggest you use the Short Text field and make these two changes to achieve the results you are looking for. Let me show you how:

    • Open your form in Form Builder, and in the orange navigation bar at the top of the screen, click on the back gear icon for the Average Gross Income Sales Short Text field.
    • Select the Options tab, choose Numeric from the validation drop-down.
    • Turn the toggle on for Input Mask, enter the #,####. Close the panel. That's it.How to enter the comma in the numbers? Image 1 Screenshot 30

    How to enter the comma in the numbers? Image 2 Screenshot 41

    Let us know how it goes.

  • ConnexPay
    Replied on April 19, 2024 at 4:14 PM

    Hi Gaud- I appreciate the attempt at a workaround. However this still doesn't resolve the issue for me.

    I need this to be able to capture answers as varied as $1,000 to $1,000,000,000 using this field. The only way I can imagine it working is where as the user types, each new numeral appears immediately to the left of the decimal (I don't even need the decimals to show)

    So if someone were to enter the digits 1 2 3 4 5 in sequence, with each keystroke the format should go

    1

    12

    123

    1,234

    such that the 1 starts moving to the left in the field each time a new digit is entered. (Whereas in everything I've tried the 1 remains fixed on the left and the numbers continue right, making it impossible to correctly calculate the placement of the comma)

  • Gaud JotForm Support
    Replied on April 19, 2024 at 4:57 PM

    Hi ConnexPay,

    Thanks for getting back to us. You can use the Form Calculator widget and add the commaSeparate mathematical function and the field 290 to pass the value with the commas. Let me show you how:

    • Open your form in Form Builder, and in the orange navigation bar at the top of the screen, click on Add Form Element
    • Select the Widget option, search for the Form Calculation widget.
    • Click on the Magic Wand icon to open its settings, Choose the f(x) icon in the purple color.
    • Type commaSeparate and select it.
    • Type 290 and select the 290 number field of the Average Gross Income Sales Volume Annual in between the commaSeperate.
    • Click on Save, and that's it.How to enter the comma in the numbers? Image 1 Screenshot 30

    How to enter the comma in the numbers? Image 2 Screenshot 41

    Let us know how it goes.

 
Your Answer