JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
[Quiz App] Only evaluating 100 first submissionsAsked by ChiDrama on June 25, 2015 at 03:33 PM
Why is Quiz Form only evaluating the last 100 entries/submissions? I need to be able to download this data for funder reports asap.
I have posted this on the App page... but this support is more extensive allowing for uploading files.
Your prompt response would be appreciated!
Thank you for contacting us.
I have attached a bug report ticket to this thread and forwarded it to our Development Team for consideration.
We will keep you updated via this thread.
Any updates? I really need to complete a report process by the end of this month and there are over 500 submissions in two different files.
Im looking for support on this issue posted requesting update on the
Otherwise, whats my work-around? How do I download all the test scores for
all the students?
Apologies for the inconvenience. Upon checking the ticket report, it is still assigned to one of our developers and is still currently being investigated. We will you as soon as we hear any news on this.
For the workaround, it seems like this isn't possible for existing submissions, but I'll try to find something that we can work one. I'll get back to you when I find a workaround that we can use.
Again, apologies for the inconvenience.
While I still wait on a developer to respond, is there a way to select the
first 100, download results, archive them and then move to next 100?
Have you tried opening the app and setting the answers again?
Currently, I'm unable to find a workaround on this.
But, I could suggest that you download your submissions as excel file and create a formula to manually check and calculate the scores of each submissions using Excel. Here's a sample tutorial link on how to make a quiz form in Excel. You can get an idea there on how to create a sheet for the list of answers to your question and use a formula to give them a value, let's say "1" if it's correct and "0" if not. then we will add all the "1"s and sum them.
This might be tricky but you can try it while our developers are still fixing the issue on the Quiz app.
I will notify them again to see if we can get any news.
Apologies for the inconvenience.
If you would still like to evaluate or score your submissions using the excel file, here's an easy approach that I made:
1. First, create columns in your Excel file that corresponds to your questions that you need to add or assess. In this case I made Q15 to Q19 at the last columns and added also a "Total" column.
2. Now we will add the formula to check if the answer is correct. Here's my formula:
=IF(AS2="a. his/her death",1,0)
This formula tells that if the answer in the column "AS2" is equal to "a. his/her death" then output the value "1" (which means correct), if not output the value of "0" (which means incorrect) in our Q15 column. Now we want to apply the formula to the whole column, we can't manually type it repeatedly, but we can drag it easily. See the screencast below on how I did it. (To learn more about the "IF" function in Excel, you can check this link.)
After that, apply the same procedure on the other columns, but make sure that you are referencing the correct column. In my case, Question 15 is found at column AS.
You can now sum columns Q15 to Q19 to column "Total" easily using the SUM function in Excel. We will add all of the "1"s which gives us a total score.
I hope that somehow it helps.
This is helpful. Im really disappointed Jotforms Quiz Form wasnt able to
return the data as I need it.
Would you happen to kjnow how to get the cacluation field to return the same
answer in the Quiz (e.g., 6/11 six out of eleven were correct); then as
percentage? I will also check online, but thats too much for me to figure
We hope to get the Quiz App fixed at some point. We will let you know when we have any updates.
Please see the next post to get the idea about form calculation based solution.
We can also calculate the percentage, for example, it may be "(correct answers / total questions) * 100".
Before deciding if we can use Jotform for the 2015-16 school year, we need
resolution on the Quiz App and the ability to download all answers to a CSV
file to assess our programs.
We have sent a note to the developer in charge to check this.
Please note that you can download raw Excel/CSV submission data at any time from Submissions page.
Unfortunately, the 'Score' column provided by Quiz App will not be included in this case.
Yes, we are aware that we can download all the files. Its the test scores
that we are wanting a solution for. In the meantime, we are looking at
other online surveys/test sites to see if theres another solution.
...nurturing new voices