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

    How to do "vlookup"?

    Asked by brsilvafe9 on December 06, 2013 at 02:22 PM

    For example, if an option be inserted in a field, another field bring a information - for viewing only.

  • Profile Image

    Answered by EliezerN on December 06, 2013 at 03:47 PM

    From my understanding, what you need is to show some information based on a previous answer. Is that correct? Please take a look at this example form: http://form.jotform.co/form/33386558610863

    If you check the box of the question Show Text? a text field will appear.

    That can be accomplished by applying conditional logics, specifically applying the Show/Hide a form field method:

    And this is the condition a created:

    Please let us know if this is not what you are looking for.


  • Profile Image

    Answered by wirelesszone on April 18, 2014 at 12:46 PM

    I have the same type of question.  Here's an example:

    I have a spreadsheet with 250 Last Names, Addresses and Zip Codes. I would like to have a drop down box with the last names and then when one is selected, the address and zip code are prepopulated in another field or even in a text field.  It would cut down on redundant steps

    Conditions work GREAT, but only on a few things, it would be nice to incorporate the table so I can have the 250 names (or any mid-sized data set) without having to set up all of the conditions.

  • Profile Image
    JotForm Support

    Answered by BDAVID on April 18, 2014 at 02:34 PM

    Hi @wirelesszone, since this is an old thread, I created your own one, so I will answer your question there :http://www.jotform.com/answers/364440. Each time you have a different question, please open a new thread, we will be glad to assist you.