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

    Totalling form fields

    Asked by oecc on November 12, 2016 at 01:44 PM

    How can I add up the fields from all the submissions in a form?

    Then display the total in an HTML report?





  • Profile Image
    JotForm Support

    Answered by Charlie on November 13, 2016 at 01:16 AM


    Just to clarify, you would like to add or sum up specific values from different submissions and display it on the HTML report? Unfortunately that is not possible, but it can be somehow done in the Visual Report Builder, you can check this guide: https://www.jotform.com/help/187-How-to-Create-a-Visual-Report-with-Your-Form-Submissions 

    Another way is to integrate your form to Google Spreadsheets, after that, you can use different functions to specifically sum up or create calculations based on the answers or inputs from different fields you have: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    The Google spreadsheet can then be embedded or shared to your users so that they can view it, should be somehow similar to the HTML table, there you can create graphs, charts, table that would represent the number of inputs and items on your submissions in totality. Here's a short article about that functionality: https://support.google.com/docs/answer/63728?co=GENIE.Platform%3DDesktop&hl=en 

    I hope that helps.