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

    Summarizing Input Table Data: options would include: count (the number of responses), sum, average, median... Excel-like functions

    Asked by centerforentrepreneurship on May 18, 2017 at 04:34 PM

    Has anyone found a way to quickly and easily summarize Input Table data?

    I have a table that's 35 rows and 4 columns. When viewed in Excel or Google Sheet that's 140 discrete columns!

    Does anyone have a method for aggregating the results in a 35 x 4 table?

  • Profile Image
    JotForm Support

    Answered by Kevin_G on May 18, 2017 at 06:17 PM

    Unfortunately, it is not possible to change how the Input Table displays in the Excel report or the Google Sheets integration, currently each option in the Input Table will be displayed as a single column. 

    How would you like to get the information displayed in the Excel report? 

    Would you like to receive it like a single field just like it displays in the submissions page? 

    Please, let us know, we will be glad to open a feature request on our second level. 


  • Profile Image

    Answered by centerforentrepreneurship on May 19, 2017 at 04:14 PM

    Thanks for the quick response, Kevin.

    I'm not sure the how the data is shown in Excel can or should be changed.

    However, a data aggregation option in the built-in "Reports" feature would work. Options would include: count (the number of responses), sum, average, median... Excel-like functions, but only viewable in JotForm reports.

    This would be a nice-to-have, so it's certainly not a requirement. As such, please give it a low priority.

  • Profile Image
    JotForm Support

    Answered by BDAVID on May 19, 2017 at 05:23 PM

    I have forwarded this feature request to our back-end team. You will be notified via this thread if this gets implemented in the future.