- Andrew EicksteadAsked 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.
- JotForm SupportChriistianAnswered on April 23, 2016 at 09:08 AM
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.
- Andrew EicksteadAnswered on April 23, 2016 at 09:48 AM
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.
- JotForm SupportChriistianAnswered on April 23, 2016 at 11:25 AM
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.