Adding calculations in JotForm tables

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

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:

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

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

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!

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

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

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

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:

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

Demo:

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

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

Thank you!

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.

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?

Hi,

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

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:

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

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

Thank you!

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!