How can I implement a dynamic dependent dropdown?

  • Profile Image
    michaeljclarke1991
    Asked on July 01, 2016 at 05: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.

  • Profile Image
    John_Benson
    Answered on July 01, 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.