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

    Problem buildind a form based on a speadsheet

    Asked by PhilippeS on October 07, 2012 at 02:50 PM



    I want to collect in a google speadsheet the first choice and the second choice for several employees : exemple


    First          Last        Choice1      Choice2

    John       Dude             A               B

    Helen      Frances         C               G


    --> Thus I would like to be able to create a form that displays at once the First Last nameS of all the employees , and lets the user assign the choices by clicking  A or B or C or D etc

    Exemple on how I would like the form to look so the user would only have to clicl on the proper  Letters:

                                        FIRST CHOICCE                                                     SECOND CHOICE

    John Dude          O A  O B    O C    O D    O E   O F   O G     |           O A  O B    O C    O D    O E   O F   O G

    Barack Amabo     O A  O B    O C    O D    O E   O F   O G      |             O A  O B    O C    O D    O E   O F   O G

    Bill   Notnilc        O A  O B    O C    O D    O E   O F   O G      |              O A  O B    O C    O D    O E   O F   O G

    George Shub      O A  O B    O C    O D    O E   O F   O G       |             O A  O B    O C    O D    O E   O F   O G



    The user clicks on  the letter of choice 1 and the letter of choice two for all the employees listed and clicks on submit.

    The result is send to the google spreadsheet.


    Is it possible to create such form ?   How ?



  • Profile Image
    JotForm Support

    Answered by Rodjit on October 07, 2012 at 03:31 PM


    You may want to take a look at this pre-made form and Google Spreadsheet Results here.

    What I did is, choose the Full Name (under Quick Tools) field and Radio Button (under Form Tools) fields and entering my options up to letter G.

    Radio Buttons (Selections);

    1. Choose Radio button under Form Tools on sidebar options

    2. Highlight the radio button field

    3. Click "Properties"

    4. Click "Options" and in your options from A-G

    Please feel free to clone the form for your convenience and let us know for any question you may have so we can assist you.


  • Profile Image

    Answered by PhilippeS on October 07, 2012 at 03:53 PM


    First of all, thanks a lot for such a quick answer : I am amazed by your dedication.

    This first approach is great however, I was wondering whether on a one and only form, clicking only once the submit button, I could submit the choices of let's say 12 employees (whose name, possibly would appear prepopulated in the form.  

    This way, the user assigns choice A and C as first and second choices to Jonh Doe, moves to Jack Lark and assigns choice C and G and so on and finally hits the submit form.

    Then a spreadsheet collect the 1st and 2nd choices of the whole group.

    I hope I am clear in my request, and 1000 thanks again


    Philippe (Martinique, French West Indies)

  • Profile Image
    JotForm Support

    Answered by jonathan on October 07, 2012 at 07:09 PM


    Hi, how about using the matrix field (found in survey tools).

    I created a sample form, try test if this is suitable to your requirements.

    Please inform us if you have further inquiry.