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.
Autofill from google spreadsheet databaseAsked by poopselfie on February 17, 2014 at 04:33 PM
Hey guys, quick question. Is it possible to create an autofill search box that will populate the box using autofill based on a google spreadsheet?
As in; if i have my form being output to a google spreadsheet, could I then create a search box using Jotform to search through that spreadsheet and autofill as the user types.
I am attaching an example; in the top search bar i have predefined values right now, but would it be possible to pull those predefined values from the google spreadsheet being submitted by the bottom form.
JotForm create search bar search box
If this is not an integration, it would be a really great widget or app.
Any other suggestions are welcome, would be great to figure this out.
Hi, as far as I know there is no such a widget for that in the Google Spreadsheet integration, but you may try the Data Grid widget, it works like spreadsheet, and it comes with a "search bar" field.
On regars of Autofilling the form from a database, I think that would required to download the full form´s source code, and do some PHP programming.
You might like to enable the autofill feature in your form, it will make the form autofill with the last updated info, if users close the window or refresh the screen while filling the form out, the info will be still there.