How can I implement a dynamic dependent dropdown?

  • michaeljclarke1991
    Asked 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_Benson
    Replied 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 

    How can I implement a dynamic dependent dropdown? Image 1 Screenshot 20

    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.