How can I set up a field with prefix and number precision without using calculations?

  • Profile Image
    IntegritySurety
    Asked on September 28, 2017 at 10:30 AM

    If I'm understanding the widgets, field options, and previous forum questions, there is no way to show a field with a $ in it, in which a client can enter a dollar amount of varying lengths?  I used a number field with masked input, solely with a $ prefix so that it shows up as a dollar, however, there's no way to turn off the "number precision" and still be able to use decimal for cents... that I can find. I tried 0 and None.

    Sometimes my clients need to enter a very exact amount "$100,123.45" and sometimes they need to enter only "$500".  The problem lies in that they're not watching the screen - they need an even $100,000, so they see "$" and they type 100000 thinking it's $100,000 and with the "number precision" set to 2 it turns it into $1000.00. With "number precision" set to 0, $100,000 works fine, but $100,000.45 is impossible - it turns to $10,000,045 because the . no longer functions

    I can't find where I can insert $ into a number field, or into a short text field. I don't need calculations. Masked field doesn't work because the # of digits varies.

    I don't care if my submission comes to me as $100000 or $100,000 or $100,000.00, as long as it has $ and it is correct. I can't risk $100,000 request showing up as $1000.00 on the submission, or $100,000.45 showing up as $10,000,045

    Thank you

    Am I missing something?

    (if you fiddle with the form, choose "Principal" and "bid bond" - I'm running my testing on the "Estimated Contract / Bid Amount: Maximum possible")

  • Profile Image
    Kevin_G
    Answered on September 28, 2017 at 12:24 PM

    I have been checking this and found that the Masked Input field should work for you, although it allows to set up a custom pattern it will also allow you to leave it empty, you can also set the amounts delimiters. 

    Please find the widget and an example on this link: https://widgets.jotform.com/widget/masked_input 

    This guide will help you adding the widget to your form: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form 

    I hope this helps.