- artproductionAsked 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]))?
- CharlieAnswered 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: http://form.jotformpro.com/form/52725815005956?
Do let us know if the above suggestion works.