Linking Drop Down boxes

  • Profile Image
    harishkota.general
    Asked on April 27, 2019 at 05:02 AM

    Hi 

    In the form i need to select a college name from a drop down and fill the rest of the college details like State, City, Pincode based on the name selected. The data is available in the spreadsheet.

    Spreadsheet to Form widget cannot be used as the user needs to know the exact name of the college which is not possible

    is there a way to do this?


    regards

    harish

  • Profile Image
    jonathan
    Answered on April 27, 2019 at 08:47 AM

    Please check on Dynamic Dropdown widget https://widgets.jotform.com/widget/dynamic_dropdowns

    I think it will work for what you need.

    Let us know how it goes.

  • Profile Image
    jonathan
    Answered on April 27, 2019 at 09:21 AM

    Thank you for the clarification. I guess it will be to tedious if using Dynamic dropdown widget in this case.

    The other workaround I come up with was using Spreadsheet widget + Autocomplete widget.

    1556371034zzz 2019-04-27 21.13.57.png

     

    Since the users will need to know what is the college name first, you can use the Autocomplete widget to list down the colleges names.

    1. They can select the college name from the list and the value will be copied to Spreadsheet to Form widget filter field.

    2. Then click on Autocomplete this field button in Spreadsheet widget to auto populate all the other fields.

    Here is a screencast video of the concept.

    1556371244autocomplete.gif

     

    I hope this help. Let us know if you need further assistance.

  • Profile Image
    harishkota.general
    Answered on April 27, 2019 at 10:31 AM

    Hi Jonathan

    Thank you that worked for me

    regards

    Harish