- poopselfieAsked 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.Page URL:
- poopselfieAnswered on February 17, 2014 at 04:36 PM
If this is not an integration, it would be a really great widget or app.
- poopselfieAnswered on February 17, 2014 at 04:38 PM
Any other suggestions are welcome, would be great to figure this out.
- JotForm SupportBDAVIDAnswered on February 17, 2014 at 07:01 PM
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.