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.
Pull Information From Google Spreadsheet To JotformAsked by M732burke on February 02, 2015 at 10:25 AM
I want to do the revers...I want to store info in a spreadsheet (like Google sheet) and have the form pull data from the spreadsheet to populate the form.
For example, when I enter an employee name, I want the form to retrieve the employee number, hire date, and rank I've entered on a spreadsheet. How do I create a field that goes to a lookup table and gets the correct line/cell of data?
This is a re-post of a comment on How to Integrate Form with Google Spreadsheet
If I am not mistaken, you would like the Google Spreadsheet Integration to work in a reverse manner where the information is not sent to the spreadsheet but pulled from the sheet and displayed on your form. I am afraid I did some checks on this and I was not able to locate any widget that supports this feature. I was not able to find any setting within the Google Spreadsheet Integration to support this feature also. The Google Spreadsheet Integration was specifically designed to send submitted information to a spreadsheet. I hope this answers your question. Feel free to contact us for further support if needed.
There is another way to do that!
Use your last column to pre-populate your form url:
If you need more jobs done, you can use zapier.com to do more :)
I also use the respond email to send a invitation email with the unique url to a client using the form for him the first time :)
JotForm Support Manager
We do not have a current solution (either app or widget) to do the opposite, but this can be a good feature request for which I have opened a ticket.
Thank you for your input. Zapier is indeed a good option.
Here is the solution:
1. Download the Google Spreadsheet as CSV
2. You can then upload this CSV file to your form using import.jotform.io app:
To better assist you, I went ahead and opened a separate thread for your concern, please refer to this link instead: http://www.jotform.com/answers/652785. We will address it shortly.
Hi back in February 2015 Jeanette suggested (see above) the feature to populate a form with data from a spreadsheet would be a good new feature request. Has anything be done to develop this. Even something simple like integrating the VLookup command in spreadsheet into Jotform to look up data should and fill the form would do it.
This seems to be an older thread. To better assist you and avoid any confusion, I have moved your question to a new thread. Please follow this link to view it: https://www.jotform.com/answers/946557. We shall answer your question there. Thank you.