I need the client to enter the amount they are applying for between $10,000.00 and $20,000,000.00 in that format. I built $##,###,###.00 but the clien

  • Todd Werboweski
    Asked on March 29, 2024 at 11:27 PM

    I need the client to enter the amount they are applying for between $10,000.00 and $20,000,000.00 in that format. I built $##,###,###.00 but the clients are frustrated as they would enter 100000 for $100,000 and it would show up as $10,000,0##.00 and they don’t know how to fix it. Thoughts?

  • Sheena JotForm Support
    Replied on March 30, 2024 at 12:04 AM

    Hi Todd,

    Thanks for reaching out to Jotform Support. I understand the issue, but I’ll need a bit of time to work out a solution. I’ll get back to you shortly.



  • Sheena JotForm Support
    Replied on March 30, 2024 at 12:40 AM

    Hello Todd,

    Thanks for your patience. Please note that enabling an input mask in the field will restrict users to a specific format. They will need to enter an 8-digit number to make the value valid. As a workaround, we can use the Masked Input Widget and create a condition to prevent users from submitting the form if they didn't enter a value between $10,000.00 and $20,000,000.00. Let me show you how to set that up:

    1. Add the Masked Input widget and set the decimal separator to "." I need the client to enter the amount they are applying for between $10,000 Screenshot 70
    2. Add a number field and hide it by default, then create a condition to pass the amount of the input mask widget to the number field once it is filled. I need the client to enter the amount they are applying for between $10,000 Screenshot 81I need the client to enter the amount they are applying for between $10,000 Screenshot 92
    3. Add an error message using a Paragraph Field then create a condition to show this error message and hide the succeeding fields if the amount from the number field is incorrect. I need the client to enter the amount they are applying for between $10,000 Screenshot 103I need the client to enter the amount they are applying for between $10,000 Screenshot 114

    Result:

    I need the client to enter the amount they are applying for between $10,000 Screenshot 125

    Here's my demo form. You can clone this form to your account by following this guide.

    Give it a try and let us know if you need any help.

  • LOBC_Finance
    Replied on April 9, 2024 at 5:52 AM

    Fabulous! Thank you.