JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Using Conditionals to populate multiple fields based on one drop downAsked by icsnetuk on July 02, 2016 at 03:21 PM
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
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:
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.
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?
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.