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.
how can I pop up the address of the person on the form, just by selecting his name from the drop down list ?Asked by resourcessonosite on March 05, 2014 at 02:10 AM
I want to creat a courier dispatch form where i need to create a column for the Consignee address. Now, we have a spreadsheet where all the address are already filled in. I want to put a drop down list in my courier form where the user can select the name of the consignee (Which are pre defined) and the address of the person automatically pops up in the form (at a predefined place). How can i do this so that the user don't have to fill in the address data again and again.
Unfortunately, we do not have such feature to pull the consignee address from excel spreadsheet or any external sources.
How many consignee address records you have? You can take advantage of our conditional logic feature to show hide address field based on the consignee selection. The following guide should help you: http://www.jotform.com/help/196-How-to-Hide-or-Show-Multiple-Fields-at-Once-Based-On-a-Single-Conditional-Entry
If number of consignee are more, using show/hide feature will surely get complicated. Another way to achieve your requirement is by downloading your form's source code and adding custom code to read the data from your excel spreadsheet and populate your form fields. To take this route, you should have some programming knowledge.
Hope this helps.
Do get back to us if you have any questions.