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 there a form where someone can enter their postcode (zipcode) and it then pulls up an entry from a database that related to that postcode?

    Asked by David Wood on July 29, 2011 at 01:08 PM

    For example, Bod, Jill and Jon are plumbers

     

    Bob works in postcode Ab11

     

    and Jill works in AB12

     

    And Jon works AB13,

     

    someone wants a job doing in AB12, they look at my website, put Ab12 in a box and Jill's details appear.

     

    I can build the database, just don't know how to make it work as described.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on July 29, 2011 at 04:18 PM

    Hi David,

    Unfortunately, we do not have this feature, and to my knowledge, we do not have plans of implementing one.

    There are a couple of workarounds though, which can serve the same purpose as that of what you want to implement. The problem is they will not involve any database, since Jotform cannot interact with databases other than its own (used to store form submissions).

    You can use the Condition Wizard to implement rules that will hide/show certain fields or a free text field (to display the plumber's details) in your form depending on a user's action such as, in your case, entering a postal code in a text box.

    Please click the link below to learn more about conditions

    Conditional Logic in Forms

    Listed below are a few examples which take advantage of conditional logic to display/hide fields

    Show an 'Other' text box when the 'Other' option is selected

    http://form.jotform.com/12055109569

    Show another address field if delivery address is different from billing

    http://form.jotform.com/11304245254

    Show new sets of drop downs for each selected option

    http://form.jotform.com/11031229242

    Show different font images depending on font selection

    http://form.jotform.com/12092159599

     

    Our support team are eager and able to lend a helping hand whenever needed.  If you need further assistance, do not hesitate to ask. Thanks!


    Neil