How can I select a name from a dropdown list and fill in another field

  • nathangold
    Asked on September 14, 2017 at 11:17 AM

    Hello,

    I love your product and use it a lot. Thank you for keeping it so simple and powerful.

    Question: I very often have the need to work with 10-20-or even 50 people at a time. I always use a Jotform to evaluate their presentations and your product is perfect for this.

    How can I use a file that has the company name and email address in a dropdown list so that when I choose the company name from the list, Jotform automagically fills in the email address associated with that company?

    I need to do this very often and for many companies at a time. I would prefer to NOT hard code this if possible.

    What do you suggest?

  • Elton Support Team Lead
    Replied on September 14, 2017 at 12:36 PM

    Thank you for using JotForm and for your kind remarks. We greatly appreciate it. :)

    There are 3 ways to achieve that but here's the easiest one to start with.

    1. Add a dropdown field to your form.

    How can I select a name from a dropdown list and fill in another field Image 1 Screenshot 50

    2. In the dropdown settings, add your companies into options.

    How can I select a name from a dropdown list and fill in another field Image 2 Screenshot 61

    Then under it, enable the calculation value and assign the email address on each of the company.

    How can I select a name from a dropdown list and fill in another field Image 3 Screenshot 72

    You can leave the empty option blank.
    You can also paste the values in the calculation value if you want to.

    3. Add Form Calculation widget to your form and label it email address. 

    Then in the calculation wizard, add the company field and switch states to A-Z. This will capture the value into string format. See screenshot below:

    How can I select a name from a dropdown list and fill in another field Image 4 Screenshot 83

    Here's a demo: https://form.jotformpro.com/72565086152963

    If you need further help, let us know.