What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
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 to allow users to search directly on the form?Asked by StrawberryDesi on May 30, 2016 at 10:43 AM
I'd like for my form entitled "Weekly Meeting form" to be able to collect names & phone numbers and then keep them in a database that is searchable. I'd like to have the database list the names in alphabetical order if possible. How can this be done?
I have inspected your form and I saw that are using User Contributed Dropdown widget. This widget allows your form users to add an option to your drop down field, in your case name and phone number. However new name that is added will be placed at the bottom of existing names. It is not possible to list them alphabetically automatically.
To collect names and phone numbers you can also add Full Name and Phone fields to your form.
You can also search for names that were entered inside of your form on Submission page of your form. Inside of this guide you can find how to view submissions:
On submission page there is a textbox to enter information to be searched from the submissions received data. you can also list your names in alphabetical order.
You can also export your data in excel report and then you can sort your data in alphabetical order.
Hope this will help. Let us know if you need further assistance.
Thank you. That answer was interesting and I hadn't thought of doing it that way. But, I need for the person completing the form to be able to do the search DIRECTLY FROM THE FORM. How can I make that happen?
Unfortunately it not possible to add search field inside of the form, so that you users can use it.
Possible workaround is to use Auto Complete widget. You can place all the information (names) inside of Auto Complete widget. Inside of this guide you can find how to add widget to your form:
However this widget will not allow your users to add new options. You will need to update your widget manually inside of Form Builder.
Let us know if you need further assistance.
Thanks for your help, BJoanna.