What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can I implement a dynamic dependent dropdown?

    Asked by michaeljclarke1991 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.

    dynamic dropdown widget implement
  • Profile Image
    JotForm Support

    Answered by John_Benson 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.