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

    [Quiz App] Only evaluating 100 first submissions

    Asked 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!

     

     

    Screenshot
    quiz app
  • Profile Image
    JotForm Support

    Answered by Mike on June 25, 2015 at 05:15 PM

    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.

  • Profile Image

    Answered by ChiDrama on July 07, 2015 at 06:33 PM

    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. 

  • Profile Image

    Answered by ChiDrama on July 07, 2015 at 06:38 PM
    Im looking for support on this issue posted requesting update on the
    thread.
    Otherwise, whats my work-around? How do I download all the test scores for
    all the students?
    Thank you,
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on July 08, 2015 at 01:09 AM

    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.

  • Profile Image

    Answered by ChiDrama on July 14, 2015 at 02:33 PM
    Charlie,
    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?
    Thanks,
    Ilesa
    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on July 14, 2015 at 03:11 PM

    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.

     

  • Profile Image
    JotForm Support

    Answered by Charlie on July 14, 2015 at 03:31 PM

    Hi,

    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.

  • Profile Image

    Answered by ChiDrama on July 14, 2015 at 06:23 PM
    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
    out.
    Thanks,
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on July 14, 2015 at 07:42 PM

    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.

    How to create a Quiz form with a number of correct answers on a Thank You page

    We can also calculate the percentage, for example, it may be "(correct answers / total questions) * 100".

  • Profile Image

    Answered by ChiDrama on August 27, 2015 at 01:45 PM
    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.
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on August 27, 2015 at 02:24 PM

    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.

    Download Form Submissions as Excel/CSV/PDF

    Unfortunately, the 'Score' column provided by Quiz App will not be included in this case.

  • Profile Image

    Answered by ChiDrama on August 27, 2015 at 03:45 PM
    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.
    Best always,
    Ilesa Duncan
    Education Director
    Chicago Dramatists
    ...nurturing new voices
    cc:
    ...