How to use "Currency" Validation to format text field?

  • artproduction
    Asked on September 30, 2015 at 2:17 PM

    Is there a way to utilize the Currency Validation option to format a text field?

    Maybe, something similar to Excel's DOLLAR function --> (DOLLAR( number, [decimals]))? 

     

    How to use Currency Validation to format text field? Image 1 Screenshot 20

  • Charlie
    Replied on September 30, 2015 at 4:17 PM

    I believe the Validation option Currency allows the user to input a currency sign and a number value.

    However, if you want to format it, you can use the "Input Mask" option instead.

    How to use Currency Validation to format text field? Image 1 Screenshot 30

     

    You could also try passing the textbox value to a Form Calculation widget using a conditional logic. Here's a condition that I setup. You'll notice I added the currency "$" just beside the textbox value I fetched, then in the advance options I "set show empty decimal places".

    How to use Currency Validation to format text field? Image 2 Screenshot 41

     

    Here's a test form: http://form.jotformpro.com/form/52725815005956?

    Do let us know if the above suggestion works.