Adding calculations in JotForm tables

  • Profile Image
    WebsiteCoordinator
    Asked on October 29, 2020 at 02:24 PM

    I just watched the 2 minute video about Jotform tables.

    Here is my question.

    I have a form with 2 table survey questions where users rate their experience with several event activities.

    Is there a way to have Jotform Tables add a column in which I count all experiences?

    The results I am looking for are these:

    Question - possible answer: not applicable, poor, OK, good, excellent

    What I want to see in the new tab or a new calculated column is:

    How many people answered not applicable? Poor? OK? Good? Excellent?

    In the demo I see that there are calculation options but I don't see that option for my form. This is possibly because the survey question was set up as a table that possibly is text and not as number.

    I am super happy with Jotform, but I do sorely miss the survey statistics option. Am I missing it or are there no such options yet?

    Also:

    How is a table different from having the results in an Excel Worksheet? This is something that is already there as a feature, the tables just look nicer, but do not add to that feature or am I missing something?


    So in short:

    1. Can I count or sum answers from a table in a Jotform form - counting all answers?
    2. How are the tables adding to Excel functionality?

    Thanks,

    Nicky

    Page URL:
    Tablefeatures

  • Profile Image
    Niko_N
    Answered on October 29, 2020 at 05:58 PM

    Hi Nicky,

    1) To get automatic calculations, how many people answered not applicable? Poor? OK? Good? Excellent? etc., I suggest to use Summarize with a chart option:

    1604008278_5f9b3956d4c5b_


    It will quickly summarize form submissions based on the question options and has the option to change chart type:

    1604008409_5f9b39d9f3255_


    You can hover over the question, and it will show all the details how many people selected each option and corresponding percentage:

    1604008496_5f9b3a3028d15_


    2) As I understand, you are interested in how JotForm Tables differs from MS Excel. If that's a case, please note that downloaded Excel data is a static file, whereas JotForm Tables is directly connected to your form submissions and all the data is updated in a live mode. Besides, Tables has various features of displaying data, filtering and sorting them etc. Shortly, downloaded excel data is quite limited, whereas JotForm Tables is created to have all the required features for maintaining form data.

    Please let us know if you have further questions.

    Thank you!

  • Profile Image
    WebsiteCoordinator
    Answered on October 29, 2020 at 06:04 PM

    Very cool! Thanks for the quick reply. I found those options thanks to your explanation. Great improvement!

  • Profile Image
    WebsiteCoordinator
    Answered on October 30, 2020 at 01:25 PM

    Hey there,

    I am using those new features now and the thing I am missing is this:

    The graphic representation of the results cannot be taken to full screen view from the pop-up. This means that some of my questions that are longer than 2 or 3 words are not shown in full. I tried exporting them but the export basically is like a screenshot of just the little chart pop-up window. Could the chart be adjusted to have the ability to show it full screen?

    Thank you for your consideration!

    Nicky

  • Profile Image
    WebsiteCoordinator
    Answered on October 30, 2020 at 01:33 PM

    By the way: I did notice the option to create a new tab and then go to report mode. Great!!

    What I miss here is the option to show ALL answers for open questions, and not have the scroll bar.

    Thank you for your consideration!

    Nicky

  • Profile Image
    Niko_N
    Answered on October 30, 2020 at 03:03 PM

    Hi Nicky,

    I'm glad to hear you have good experience with JotForm Tables.

    As I understand, now you want the report to include all your open questions in one page, instead of users scrolling down for separate question results. If that's a case, you can create a blank report tab:

    1604084381_5f9c629d5e647_

    Then add reports for both questions to the same page and adjust according to the layout:

    1604084562_5f9c6352ad41e_



    Demo:

    https://www.jotform.com/report/20303541959004830

    Please check and let us know if you are referring to something else.

    Thank you!

  • Profile Image
    WebsiteCoordinator
    Answered on October 30, 2020 at 03:23 PM

    Thanks for the video. However, is it true that I cannot have an open text result run over more than 2 pages?

    Do you have suggestions for how to best display open question results?


    Here is another remark that supports what I asked about not showing results with a scroll bar:

    When I export the report it comes in as a PDF which means the scroll bar disappears.

    Also, it seem the only page setting possible is A4, which is not the default in North-America.

  • Profile Image
    WebsiteCoordinator
    Answered on October 30, 2020 at 03:29 PM

    I tried the blank report and it looks like the most I can do is fit is to the page.

    But I currently only have 16 responses but there could be possibly hundreds. I might want to show a top 10 or something and group them manually . Just use the graphics where they make sense. That means I am best off with making a manual screen shot of each chart and past it into a Word or Powerpoint method.

    I would like to suggest maybe allowing users to add a blank page in a report with charts and then add their own text. Right now this is not possible as far as I can tell: I can only choose from the table's element. It would be a big help if I would have a text widget that I can format the way I want it and enter the most important answers from the open questions. Is this an option?

  • Profile Image
    Niko_N
    Answered on October 30, 2020 at 05:11 PM

    Hi,

    For open question results, the best option would be to create a typical Extended Report and then share it with the Publish option:

    1604091828_5f9c7fb4eee70_

    Having each question results on the separate page would give better insight; also, users won't be required to scroll down, it would be displayed like a typical presentation:

    https://www.jotform.com/report/20303695654805830


    Please note that Filtering options work for reports as well, so if you have multiple submissions, you still will be able to group them based on date or some filtering option:

    1604092123_5f9c80dbb06ee_


    You can use basic elements for adding some custom text or data along with table elements:

    1604092213_5f9c813538e4b_


    Please check and let us know if you have further questions.

    Thank you!

  • Profile Image
    WebsiteCoordinator
    Answered on October 30, 2020 at 09:09 PM

    Oh I gotcha. I totally missed the basic section because the table report comes in with the elements scrolled down. I will give that a try. Many thanks!