How can I load a Google spreadsheet directly into a form?

247Oversight

Asked on September 30, 2016 at 1:35 PM

Allows user to view the data on the spreadsheet. They will not edit it.
Jan

Replied on September 30, 2016 at 4:38 PM

It is possible to embed a Google Spreadsheet in the form using the Iframe Embed widget. Here's a guide:

1. In Google Spreadsheet, please click the "Share" button at the top right.
2. Click the "Get Shareable Link" button.
3. Edit the permission you preferred.
4. Copy the "Spreadsheet URL".

5. Go to the Form Builder and insert the Iframe Embed widget.
6. Paste the Spreadsheet URL in the URL field. Please specify the height and the width and then click the "Add Widget" button.

Here's the result:

You may also publish the spreadhseet using the Publish wizard in the menu.

Hope this helps. Thank you.
247Oversight

Replied on October 1, 2016 at 9:45 AM

Exactly what I needed.
Thank you.
...
Jan

Replied on October 1, 2016 at 4:51 PM

Glad I can help. If you need anything, let us know. Thank you.
247Oversight

Replied on October 3, 2016 at 7:45 AM

I have everything working correctly.
Last item I need help on.
I have 4 Forms which need to be secure. What I mean is I need the user to
go through a log in process to insure I don't have unauthorized people
using the form or viewing private data. How do I accomplish this.
The sample form I made. Anyone knowing the link can open it.
I will 3,500 authorized club members accessing these 4 forms. Hope to add
additional forms later on for the club membership.
Thank you for your time,
Steve C.

...
John_Benson

Replied on October 3, 2016 at 11:13 AM

I have moved your issue to another thread to assist you better. Here's the link:

https://www.jotform.com/answers/949112

We will attend to your problem shortly. Thank you.
247Oversight

Replied on October 3, 2016 at 8:45 PM

Great information.
Thank you.
...