Is it possible to achive Excels Vlookup function using JotForm?

  • 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?

  • Irshad
    Replied on August 22, 2016 at 1: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"

    Is it possible to achive Excels Vlookup function using JotForm? Image 1 Screenshot 20

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

  • Kiran Support Team Lead
    Replied on August 22, 2016 at 3: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.

    Is it possible to achive Excels Vlookup function using JotForm? Image 1 Screenshot 30

    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:

    Is it possible to achive Excels Vlookup function using JotForm? Image 2 Screenshot 41

    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.