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

    Spreadsheet Widget: Ability to perform the calculation formula until there's a value entered in the involved cells.

    Asked by cmmhr on April 19, 2017 at 04:28 PM
    1- Is there a way to get rid of the "NaN" symbols in two of our columns where we have formulas as the default values
  • Profile Image
    JotForm Support

    Answered by Kevin_G on April 19, 2017 at 05:38 PM

    This seems to happen since the widget is trying to perform the calculation even when there are not entered values in the cells involved, then there is not a numeric result to show. 

    I think setting the widget to perform the calculations until there are values entered in the fields may work to avoid the "NaN" shown when the calculation is not properly performed. 

    I will report this to our second level as feature request, although we cannot provide an ETA or ensure this will be implemented, we will let you know as soon as we get any update about it. 

     

  • Profile Image

    Answered by cmmhr on April 26, 2017 at 10:21 AM

    Thanks for getting back to me, just to double check, the option to not perform the calculations until there is data in the field is not currently available, correct? Thanks for all your help.

    Katie Thompson

  • Profile Image
    JotForm Support

    Answered by AIDAN on April 26, 2017 at 11:56 AM

    Yes, the option is not currently available.

    It was a feature idea from my colleague Kevin that is worth requesting, and as he mentioned, he has escalated this as a feature request so we will be notified of any progress via this thread.

    I hope this helps. If you need further assistance please let us know. Thank you.

  • Profile Image

    Answered by cmmhr on April 26, 2017 at 12:00 PM

    That sounds great, Thanks for all your help!

    Katie Thompson