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

  • Profile Image
    welsweb
    Asked 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.

  • Profile Image
    BDAVID
    Answered 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.