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

    Can you have a calculated field if some of the fields are blank?

    Asked by brockeni on March 02, 2014 at 01:14 PM

    I want a "grand total" at the end of my form.  However, it will not calculate if some of the fields are left blank. Is there anyway to "assume zero" in a blank field? This final calculation will include fields on pages that they may not go to (depending on other options); so I can't "require field". Is there any way to do this?

  • Profile Image
    JotForm Support

    Answered by BDAVID on March 02, 2014 at 02:45 PM

    Hi, I see what you mean, the calculation widget would not calculate if the fields are left in blank:

    At this moment the best thing to do is to set the fields as "required", I have submitted a request to our second level to have this implemented, however we can not assure you if this will be implemented or how long it will take. You will be notified via this thread when this happens.

  • Profile Image

    Answered by john.roscoe on March 02, 2014 at 03:06 PM

    Another work around I have used - make the field 'required' and set the default value to 0. You can also make one of the choices = 0 , or you can disguise it by using a string like "CH00SE an option" (using zeroes not letter O) as your default value.