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

    Selection of one drop down auto-fills the next field

    Asked by dbruckshaw on February 14, 2014 at 06:41 AM

    Hi,

    I'm simply trying to get my form to auto populate certain fields dependant on the initial selection.

    So, I have a list of customer accounts in my first drop down. I just need the form to then display the specific customers address (pulled from a list) in the next field. What type of field that is, is unimportant, as long as it works!

    Am I asking too much? I appreciate this isn't database software but I would expect it to be standard functionality? It'll save me having to manually type out the full address each time I select a customer.

    Many Thanks,

    Dan

    next Selection select thanks
  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 14, 2014 at 09:44 AM

    Hello Dan,

    Though you cannot pull the customer address from database but it is possible to achieve your requirement. You can take advantage of our conditional logic feature to show hide address field based on the account selection. The following guide should help you:  http://www.jotform.com/help/196-How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry

    I cloned your form and implemented it for one customer (Promote Ltd.) to display the address automatically. Please take a look at the following form and see if this is what you want to achieve:  http://www.jotformpro.com/form/40443377447963

    Feel free to clone this form for closer look. The following guide should help you in form cloning:  http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    I know this will get complicated with show/hide fields because you have a number of customers. The easiest way to achieve your requirement is by adding custom JavaScript code and that will be easier to manage at a latter date for addition / deletion. If you are okay with the form's source code route, I will be happy to create a sample form for you. 

    We will wait for your response.

    Thank you!

  • Profile Image

    Answered by dbruckshaw on February 14, 2014 at 10:00 AM
    Hi Ashwin,
    That’s brilliant! Yes, please could you use my form as you have done already and add the javascript for me, could you make it clear how I would then proceed to make it work for all our customer accounts so I can add/delete without asking you for help going forward?!
    I’m really impressed by how good your user support is, thank you!
    [cid:image001.gif@01CF2994.CA0F6960]
    Daniel Bruckshaw
    IT Infrastructure Manager
    Tel. 01332 85 50 50
    Fax. 01332 85 84 58
    DDI. 01332 85 84 71
    Charterhouse Holdings plc is a company registered in England & Wales with company number 981987 | Registered office: Oakridge Park, Trent Lane, Castle Donington, DE74 2PY.
    ...
  • Profile Image
    JotForm Support

    Answered by ashwin_d on February 14, 2014 at 10:15 AM

    Hello Daniel,

    Sure, I will start my work on your form. Meanwhile do you have a list of address for your customers which you can share?

    I will get back to you as soon as I am ready with workaround implementation.

    Thank you!

  • Profile Image

    Answered by dbruckshaw on February 14, 2014 at 10:30 AM
    Great, thank you once again. I can’t really share the addresses for data protection reasons. However, you could just use any made up address for these purposes and I can edit them as necessary afterwards?
    Kind Regards
    [cid:image001.gif@01CF2999.6A0C7490]
    Daniel Bruckshaw
    IT Infrastructure Manager
    Tel. 01332 85 50 50
    Fax. 01332 85 84 58
    DDI. 01332 85 84 71
    Charterhouse Holdings plc is a company registered in England & Wales with company number 981987 | Registered office: Oakridge Park, Trent Lane, Castle Donington, DE74 2PY.
    ...