-
michaeljclarke1991Asked on July 1, 2016 at 5:38 AM
For example:
Dropdown A: School 1, School 2, School 3
Dropdown B: <if School 1 is selected, show:> Pupil 1, Pupil 2, Pupil 3
Dropdown B: <if School 2 is selected, show:> Pupil 4, Pupil 5, Pupil 6
Dropdown B: <if School 1 is selected, show:> Pupil 7, Pupil 8, Pupil 9
The full list of schools and pupils should be taken from a Google sheets document, or a basic CSV file.
-
John_BensonReplied on July 1, 2016 at 11:06 AM
You can use the Dynamic Dropdown widget in order to achieve this. Here's my demo form: https://form.jotform.com/61823863666971
The full list of schools and pupils should be taken from a Google sheets document, or a basic CSV file.
If I understand you correctly you want JotForm to get information about schools and pupils from your Google Sheets or from a CSV file. Unfortunately, this is not possible with JotForm. You need to manually input the options in the drop down which is the school names and pupils.
Hope that helps. Thank you.