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

    How do I get calculations to appear in my Excel download?

    Asked by vincelorusso on June 07, 2015 at 12:35 PM

    I have 4 calculations set up in my form, at the very end, and they're hidden so that the person filling out the form doesn't see them, but I want to be able to see them in my Excel download. They don't appear and I've made sure the calculations are correct.

     

    Any thoughts?

    Page URL:
    http://www.jotform.us/form/51177910386156

    excel calculations
  • Profile Image
    JotForm Support

    Answered by jonathan on June 07, 2015 at 03:10 PM

    Actually when I checked the submission data of the form http://www.jotform.us/form/51177910386156 I noticed that the calculated results were empty.

    user guide: -How-to-view-Submissions

     

    Is the Calculation working properly on the form? Check first also if calculation formula is correct and working. You can try to Unhide first the calculation fields so that you can see in form if they are working.

    If they calculation fields have value they should show up in the submission. 

    If you wanted the empty submissions to still show, you can uncheck the option "Auto Hide Empty Submission" in the view submission page of the form.

    The empty fields will also show up in your Excel download.

    Hope this help. Let us know if issue remains.

    Thanks.