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

    Is it possible to have JotForms to prepopulate a field using an external file value as a lookup table?

    Asked by welsweb on November 25, 2015 at 02:41 PM

    Example: I have 1000 schools that I want to appear in a dropdown selection box. It would be great to conditionally pick by zip and have those schools with that zip only appear in the dropdown rather than all 1000. Possible?

     

    No form yet created. Determining if JotForm is the best solution.

    table lookup
  • Profile Image
    JotForm Support

    Answered by BDAVID on November 25, 2015 at 06:02 PM

    You might accomplish this, but you will have to manually enter the schools in separate Drop Down fields:

    And use conditional logic to show only that specific Drop Down if a specific zip is entered(In another field): http://www.jotform.com/help/316-How-to-show-or-hide-a-field-in-the-form-based-on-the-other-field-input-or-selection

    Try this example: https://form.jotform.co/53045347522855

    Hope this workaround helps, let us know if you have more questions.