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.
Searchable Form Query and Posting ResultsAsked by Andrew Eickstead on April 23, 2016 at 08:11 AM
I help manage a site for a roofing company in San Antonio, Texas. Last week we had the largest hail storm on record. They are requesting a form on their website where customers can enter their information and then see where they are in "line." In other words, I type in my name and address, and when I hit enter, I get a result that says, you are in line to be job 13 out or 147. This seems doable, but I am not sure what is the right tool to make it happen. Can you help? I have attached an example.
If I understand correctly, you will be needing 2 kinds of forms - one form that will allow users to submit a job request (this job request will then be queued) and another form where users can query their request using name and address.
The first form that you need where use can submit job request is doable using the basic features. You can use How to Create Your First Web Form as your guide.
The second form where user needs to query their job request is more complicated, we currently have no feature that allows users to query using form. If you have a background in using PHP and MySQL, one workaround is to save the requests submitted through the first form to your own database. This way, you can create your own page that can query to the said database using PHP. Please see How to send Submissions to Your MySQL Database Using PHP for more details.
I hope these help.
Yes, thank you, that is helpful. I was hoping we could connect the form to an excel spreadsheet or google spreadsheet and just have the customer's type in their information in the web form and then have the spreadsheet searched and pull and post where the customer was in line for repair. This might be possible, just curious. Thank you for the quick response and helpful information. If you think the spreadsheet idea has any possibility of working, I'd love to hear how it might work and if this is a safe way to do things without risking opening up our customers to stolen personal information.
It is possible to connect your form to Google Spreadsheet so that when user submits information, it will be saved in one row of Google Spreadsheet. Please see for more How to Integrate Form with Google Spreadsheet details.
safe way to do things without risking opening up our customers to stolen personal information
How do you want to limit the access of users to information? You can set that access level to your Google Spreadsheet but that is outside JotForm. Please see https://support.google.com/drive/answer/2494822?hl=en for more details.