JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Can I use JotForm to lookup data on a Google spreadsheet?Asked by CBMCwn on June 08, 2016 at 03:29 PM
I will preload accrued vacation from the last pay period and then look up this data on the spreadsheet to compute accrued vacation hours up to 6 months out. Can I use Jotform to look up a separate or integrated Google Sheet to pull out the data and then compute the future accrued vacation hours?
Unfortunately this is not possible to achieve with JotForm, you cannot get data from a spreadsheet or tell the form to search info into it.
If you want to do it, you will need to get the source code of your form and do your own script to find info in the spreadsheet, this guide will help you to get the source code of your form: How-to-get-the-Full-Source-Code-of-your-Form
You can only send your submitted data to a spreadsheet, but this will create a new spreadsheet, this cannot be done with an existing spreadsheet, here is the guide that will help you to integrate your form with Google Spreadsheet: How-to-Integrate-Form-with-Google-Spreadsheet
You may consider pre-populating some fields of your form generating a link, this can be done by using this app: http://prepopulate.jotform.io/
This will provide you the URL to the form with some fields pre-filled and then you can replace this data with the data from your spreadsheet.
If you want to import this data from the spreadsheet to your form, then you can format it as an Excel file and then import this data to your form, here is a guide that will help you with that: Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm
Hope this helps.
Hi Guys the request to look up data in a database or spreadsheet has been requested so many times, I am surprised you have not created something yet. Your product is great but the ability to look up data and pull it into a form would make it even better.
I organise a large annual bike ride for charity and to be able to populate the form for those that have entered before using their email address would be so beneficial.
I have moved your request to another thread, you will find it here: https://www.jotform.com/answers/943117
This is to assist you better, we will reply to you on that thread as soon as possible.