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

    Using Conditionals to populate multiple fields based on one drop down

    Asked by icsnetuk 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

    multiple fields populate multiple
  • Profile Image
    JotForm Support

    Answered by BDAVID 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

    Answered by icsnetuk 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
    JotForm Support

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