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?

  • Profile Image
    David Wood
    Asked 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
    Answered 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

    Show another address field if delivery address is different from billing

    Show new sets of drop downs for each selected option

    Show different font images depending on font selection


    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!