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

  • Profile Image
    Asked on September 30, 2015 at 02: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]))? 


  • Profile Image
    Answered on September 30, 2015 at 04: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.


    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".


    Here's a test form:

    Do let us know if the above suggestion works.