How to do "vlookup"?

  • Profile Image
    brsilvafe9
    Asked 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
    EliezerN
    Answered 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.

    Thanks

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