Using Conditionals to populate multiple fields based on one drop down

  • icsnetuk
    Asked on July 2, 2016 at 3:21 PM

    Hi,

    I understand how to specify and set the value of a field based on a value set in a different drop down box. 

    What I want to achieve is to update multiple fields based on one drop down ... ie. by selecting a person from a drop down then their phone number, email, job role and address is then selected either from a CSV or from a manual list entered into the form code

  • David JotForm Support Manager
    Replied on July 2, 2016 at 8:30 PM

    What you required is complex, it would be best to download your form source code, and hire a programmer that would create the queries to pull the data from your own database.

    However, this can still be accomplished through our tool, but it would required many conditions to pull the data from one person.

    So, based on this guide: https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-Conditional-Logic , you will need to create a condition for each field you want to populate, so a specific text is inputted in it if a certain selection is made: 

    Using Conditionals to populate multiple fields based on one drop down Image 1 Screenshot 30

    Example: https://form.jotform.com/61837571322961 

    Using Conditionals to populate multiple fields based on one drop down Image 2 Screenshot 41

    If you would like to populate person's B data, the you will need to create another set of conditions for each field.

    You may clone my form, so you can inspect it further, so you can consider the viable way to accomplish what you need.

    Let us know if you have more questions.

  • icsnetuk
    Replied on July 13, 2016 at 4:56 PM

    Hi,

    Another way I've thought of achieving this is to use URL field completion tags. I.e. If I include https://JOTFORMURL?fieldname=requiredvalue then this fills my fields as required. 

    So all I need to do is have a drop down box that when a value is selected it redirects the user to another webpage (which I would set as the one with the extra parameters in the URL).

     

    Is it possible to direct a user to another webpage once a value is selected from a drop down via conditions?

  • Mike
    Replied on July 13, 2016 at 6:10 PM

    A redirect is only available upon a form submission. The form can be auto-submitted based on a custom time frame with a Global Countdown widget.

    Using Conditionals to populate multiple fields based on one drop down Image 1 Screenshot 20

    Thank you.