- PhilippeSAsked 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 ?
- JotForm SupportRodjitAnswered on October 07, 2012 at 03:31 PM
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.
- PhilippeSAnswered 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)
- JotForm SupportjonathanAnswered 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.