Pull Information From Google Spreadsheet To Jotform

M732burke
Asked 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.

I want to an employee information 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 Forms with Google Sheets
Sean
Answered on February 02, 2015 at 11:29 AM

Hello M732burke,

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.

Cheers!
Sean
Arnault
Answered on February 09, 2015 at 02:07 PM

There is another way to do that!

Use your last column to pre-populate your form url:

http://www.jotform.com/help/71-Prepopulating-fields-to-your-JotForm-via-URL-parameters

If you need more jobs done, you can use zapier.com to do more :)

I also use the respond email to send an invitation template with the unique url to a client using the form for him the first time :)
Jeanette

Jotform Support

Answered on February 09, 2015 at 03:13 PM

@M732burke

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.

@Arnault

Thank you for your input. Zapier is indeed a good option.
Aytekin

Jotform Founder

Answered on February 11, 2015 at 01:49 PM

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:

http://import.jotform.io/
etiaccess
Answered on September 01, 2015 at 11:53 AM

Hi Aytekin,

I guess this solution is good for static spreadsheet. But do you have any solution for spreadsheet in which data changes constantly.
Charlie
Answered on September 01, 2015 at 02:23 PM

@etiaccess

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.

Thank you.
dorsetholidaylets
Answered on September 29, 2016 at 06:17 PM

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.
Chriistian
Answered on September 30, 2016 at 02:13 AM

Hi @dorsetholidaylets,

This seems to be an old 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.