How can I populate many fields based on one drop down field.

  • Profile Image
    hepatel
    Asked on March 30, 2015 at 06:20 AM

    Step 1: Select postcode based on that I will filter another dropdown.

    e.g. Poscode: HA5 6PJ another filter will shows many addresses available for this postcode.

    1 Sky Avenue, London, Middlesex, HA56PJ

    2 Sky Avenue, London, Middlesex, HA56PJ

    10 Sky Avenue, London, Middlesex, HA56PJ

    12 Sky Avenue, London, Middlesex, HA56PJ

    Step 2: From filtered second drop down I have selected following.

    12 Sky Avenue, London, Middlesex, HA56PJ

    Step 3: Based on above selection from the dropdown I would like to populate following fileds automatically.

    Address 1: 12 Sky Avenue

    Address 2: London

    Address 3: Middlesex

    Postcode: HA56PJ

    How can I do that?

     

  • Profile Image
    ashwin_d
    Answered on March 30, 2015 at 10:56 AM

    Hello hepatel,

    Please be noted that it is not possible to dynamically populate the drop down options. To achieve your requirement, you will have to add separate drop down fields for every postcode. You can then take advantage of our "Conditions" feature to show hide the respective drop down based on the postcode selection. 

    Here are the steps I would suggest:

    #1. Add a drop down field and list all the post code in drop down options.

    #2. Add separate drop down field for every post code options.

    #3. Add conditions in your form to check the post code selection and then show / hide the respective address drop down. 

    #4. Take advantage of our "Update a form field value" condition feature to populate the address in address fields of your form.

    Please take a look at the following demo form where I have added conditions to populate one address field:  http://form.jotformpro.com/form/50884047279970? 

    Feel free to clone this form for a closer look. The following guide should help you in form cloning:  http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image
    hepatel
    Answered on March 30, 2015 at 12:30 PM

    Thanks for your response but we have 100 postcodes and respective addresses needs to be filter. Is there any other ways to achieve this ?

  • Profile Image
    Charlie
    Answered on March 30, 2015 at 02:38 PM

    Hi,

    Aside from using the conditions that my colleague mentioned, if HA56PJ is an actual postal code, then it should show in the following widgets:

    http://widgets.jotform.com/widget/autocompleted_address 

    http://widgets.jotform.com/widget/postal_code_search 

    If they do not exist there, I believe the only way is to manually code and condition the drop down list.

    Kind regards.