JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Is it possible to achive Excels Vlookup function using JotForm?Asked by csfltd 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?
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.
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.
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.
Hope this information helps! If you are referring to something different, please let us know. We will be happy to assist.