How to add a field for dollar amount entry with 2 commas?

  • jillhatcher
    Asked on February 1, 2016 at 1:36 PM

    Hello,

    I have been struggling with what type of field settings will allow for entry of dollar amount values that can go up into 9 or so digits of information.  Such as, $11,000,000 or $1,000,000.  I've tried the currency setting and it will not accept a second comma with three more zeroes behind it.  No commas leaves too much room for error.

    Help!

    Thanks,

     

  • Jeanette JotForm Support
    Replied on February 1, 2016 at 5:12 PM

    I am not sure where you are trying to accomplish this.

    But, from what I can see, you do not have a payment integration in your form yet.

    If you are looking for a way to get the $1,000,000  format, I would recommend you use a text field and then implement a calculation field.

    Then establish on the wizard the the sum of either just text fields or a combinations of numbers and text fields:

    How to add a field for dollar amount entry with 2 commas? Image 1 Screenshot 30

     

    This way you can have the desired results

    How to add a field for dollar amount entry with 2 commas? Image 2 Screenshot 41

     

    And you can even pass the total to a payment integration

    Here is my demo form for you to see the desired results https://form.jotform.com/51376726372965

    I hope my guide helps you.

  • jillhatcher
    Replied on February 1, 2016 at 7:17 PM

     

    This is not to receive a payment.  This is simply for the person completing the form to report a dollar amount that may go up into the million dollar range.  There is no need for multiple fields to be calculated.

     

     

    I have used the text box, currency validation setting.  This seems to have a setting that will not allow the data entered to exceed $999,000.

     

    How to add a field for dollar amount entry with 2 commas? Image 1 Screenshot 20

     

  • Jeanette JotForm Support
    Replied on February 1, 2016 at 8:51 PM

    In that case, simply set the validation as NONE.

    How to add a field for dollar amount entry with 2 commas? Image 1 Screenshot 20