Is it possible to achive Excels Vlookup function using JotForm?

  • Profile Image
    csfltd
    Asked on August 22, 2016 at 11:55 AM

    Hi I have an branch listing that has approx 100 stores

    I currently use excel or google sheet to create a vlookup table, where I enter the branch number and below it then display the rest of the address. Is this something that is possible?

  • Profile Image
    Irshad
    Answered on August 22, 2016 at 01:15 PM

    Yes, it is possible. You can create a form with "text box" field or "number" field where you can enter the Branch number. And below that field, you can take the Address field from the "Quick Fields"

    If you face any issue, or need further assistance, feel free to revert back. 

  • Profile Image
    grade4pagasa
    Answered on August 22, 2016 at 01:33 PM

    I believe what csfltd means is that: 

    How can he auto-populate the address field based on the value entered in a textbox (or other input fields)?

    Multiple conditional logics would be impractical since csfltd has ~100 stores - and that could be the reason he stated VLookup - as an analogy to auto-populate fields within the JotForm platform. 

     

  • Profile Image
    Kiran
    Answered on August 22, 2016 at 03:06 PM

    As Mr. Randy (@grade4pagasa) mentioned, it can be possible to setup multiple conditions to read the values based on the selection. However, more conditions and fields on the form put more load on the form and it may cause the browser to freeze. 

    If you just want to display the address on the form for information purpose and to read to a text box field, you may consider assigning the addresses as the calculation values to the select box so that the address can be displayed on a Textbox field using a single condition. Please see the screencast below that can help you in this regard.

    You may also consider using Text field so that the calculation field from the Select box is displayed in the Text field by using the field name and no conditions are required. 

    Please see the screencast below:

    Here is the demo form that might help you and please feel free to clone it to your account.

    https://form.jotform.com/62345330626956

    Hope this information helps! If you are referring to something different, please let us know. We will be happy to assist.