What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Using comma as decimal point in number formatting not working on Calculation widget

    Asked by isben22 on May 23, 2017 at 04:15 PM

    All, I am new to JotForm and am having trouble with the European Formatting in particular. I have a generic form that I am trying to develop and have several calculated fields. One field pair is for data entry, the second is a hidden field for the basis of estimate. Customer is to place a measurement in the fields, and the form will calculate the cost. 

    The form seems to be forcing the comma separator for the European format. When trying the suggestion of ticking the box in the calculated control for comma separation, it is Null but still pushing the comma formatting. 

    I have also looked within the widget to see if there is another formatting control that may be selected but there do not seem to be any that I am missing. I have tried some formatting that was suggested in the thread, but it seems that the calculation breaks when I do this. 

    my form is at:https://www.jotform.com/build/71415750681860. 

  • Profile Image
    JotForm Support

    Answered by jonathan on May 23, 2017 at 04:26 PM

    Hi,

    I reviewed your form and I can see that the configuration to use comma as decimal separator on Calculation widget is working as it is suppose to.

     

     

     

    Please let us know if this is still is not resolved.

    Thanks.

  • Profile Image

    Answered by isben22 on May 23, 2017 at 04:37 PM

    Thank you for the prompt reply. It is supposed to be a decimal, NOT a comma. On my end if I leave it unchecked, it still resolves as a comma. Thank you!

  • Profile Image
    JotForm Support

    Answered by jonathan on May 23, 2017 at 05:24 PM

    I apologize for the confusion. I misunderstood the original question.

    I reviewed further the form and I found a fault on the field type used. I found that all your input fields used on calculation were actually all Calculation widget.

    I suggest you change those input fields, even those hidden ones with a Textbox(short entry) field instead. Then redo the Calculation widget formula so that it will take effect on the newly used fields.

    Let us know if this did not work.

     

     

  • Profile Image
    JotForm Support

    Answered by jonathan on May 23, 2017 at 06:01 PM

    Please try my demo form also https://www.jotformpro.com/71426716223957

    You can clone it if it work the way you intend it to.

    User guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

     

     

  • Profile Image

    Answered by isben22 on May 24, 2017 at 09:01 AM

    I see, Thank you for the assistance with this. I had tried to use a "number" control thinking that they would be the right container for adding numbers, but the calculated field at the end did not work. So I tried using the calculator widget for each field (what you see) and it partially worked. I did not think to try text. 

     

    Thank you for your help!

  • Profile Image
    JotForm Support

    Answered by Kiran on May 24, 2017 at 11:34 AM

    I have checked your form https://www.jotform.us/form/71425179781160 and see the field are not used with calculation widget. Please try the suggestions provided by our colleague in the earlier post and let us know if the issue still persists.

    If you are working on a different form, please provide us with the form ID/URL so that we can take a look and assist you further.

    Thanks!