Problem buildind a form based on a speadsheet

  • Profile Image
    Asked 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
    Answered 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 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
    Answered 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.