Using Conditionals to populate multiple fields based on one drop down

  • Profile Image
    icsnetuk
    Asked on July 02, 2016 at 03: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

  • Profile Image
    BDAVID
    Answered on July 02, 2016 at 08: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: 

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

    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.

  • Profile Image
    icsnetuk
    Answered on July 13, 2016 at 04: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?

  • Profile Image
    Mike
    Answered on July 13, 2016 at 06: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.

    Thank you.