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

    How to create a quiz based on uploaded Excel file, with randomly positioned questions and options

    Asked by SEGService on July 13, 2016 at 03:13 AM

    Hi,

    I want to build a quiz with 50 questions.

    I used in the past the radio buttons incl. the calculation option for the right answers

     

    question 1: Is it possible to use an xls file to put in the questions ? that mean all radio button properties based on an uploaded xls file?

     

    question 2: it would be very nice if all questions (radio fields) are randomize. The different students will have different sequence of questions.

     

    question 3: if it is possible to pick 50 questions of a database of 100 questions ? That means all students have different 50 questions.

     

    It would be nice if you have any solution for my "problem"

     

    regards

    Christian

    radio buttons problem different solution
  • Profile Image
    JotForm Support

    Answered by Boris on July 13, 2016 at 07:46 AM

    We generally ask that a separate support thread be opened for each concern you have, in order for us to avoid any confusion and fully address each of the questions being asked. When it comes to uploading a file from which your form questions will be created, we do have an application that can convert spreadsheets into JotForm forms:

    http://www.jotform.com/spread2jot/

    However, it is not suitable for creating a quiz - it cannot create radio button or check box questions with multiple options. In order to create a quiz with such fields that offer multiple options to select from, I'm afraid you'll have to create the form from scratch, through our easy-to-use Form Builder.

    When your form is created, if you want the options on a check box or radio button field to display in a randomized order, you can simply click on the gear-shaped icon of your desired field in the Form Builder, click Edit Properties, and then enable its Shuffle Options.

    Please take a look at the following images for visual guidance:

    Options would display in a randomized order, as depicted in the following image:

    When it comes to your final question, I'm afraid there is no way for us to pull individual questions from a database and have each user answer a different randomized set of questions.

    Let us know should you need clarifications regarding the above, and if you need assistance with anything else, kindly open a new support thread in order to avoid confusion and for us to assist you better.

  • Profile Image

    Answered by SEGService on July 14, 2016 at 09:39 AM

    many thanks for your help.

    Could it be, that http://www.jotform.com/spread2jot/ only works with US server ?

    I tried to use it with our data on EU server but I couldnt see the new added form based ont the spread2jot uploaded file

  • Profile Image
    JotForm Support

    Answered by Boris on July 14, 2016 at 11:01 AM

    In order not to confuse the issue of creating a quiz form, with the issues you are having with the Spread2Jot app, your report about the app not working for you has been moved to a support thread of its own:

    https://www.jotform.com/answers/882590

    We will be assisting you with it there, shortly. Thank you.