You are here: Home » Web Media » Displaying Google Docs Form Results

Displaying Google Docs Form Results

In my post Add a Google Docs Form to Your Blog, I showed you how to create a form for your blog to collect data. In this blog post I’d like to show you how to display those results in your blog.

Below is an example using the Embed Iframe WordPress Plugin.

When you start collecting data in a Google Docs Spreadsheet, you can publish the spreadsheet and it creates a unique URL that you can include in your blog post. This URL can be passed to the Embed Iframe plugin so the spreadsheet is displayed.

Here’s the output of the spreadsheet using the Embed Iframe WordPress Plugin.

Here’s the output by selecting the HTML to embed in a web page choice when publishing your Google Docs Spreadsheet. Notice the bar at the bottom with arrows on the right. You would use the arrows if you had more columns to scroll to.

When you publish spreadsheet results, you’ll have the chance to check a box that says, “Automactically re-publish when changes are made.” This is also the same screen that allows you to re-publish a spreadsheet over and over.

I don’t select the auto-re-publish because it will display everything that people enter into the form right away. And of course you can imagine using this technique with the public filling out your form and re-publishing that data automatically. You would end up with some interesting data to display. icon smile Displaying Google Docs Form Results

Here’s the screen shot of choices you can publish a form in:

google docs spreadsheet publishing formats Displaying Google Docs Form Results

Now, the above examples display the spreadsheet results and what I’d like to see is the results formated the way I want them formatted. So I’ll continue playing with this feature of Google Docs Forms and Spreadsheets until I get it the way I want. And of course I’ll be sharing it with everyone here at my blog.

pin it button Displaying Google Docs Form Results

Join My Newsletter


Receive tips, tactics and techniques on Blogging, Internet Marketing, Personal Technology, Search, Social Media, Web Media and more from Bill Bolmeier.


{ 6 comments… read them below or add one }

Kirk December 6, 2010 at 11:54 pm

Here’s another way to embed the results (in chart form):

http://bunkaseminar.blogspot.com/2010/12/sample-questionnaire.html

The charts update automatically as new information comes in. You can see exactly how I did this if you follow the links on this page.

Reply

Bill Bolmeier December 7, 2010 at 2:39 am

Excellent tip Kirk. Thanks.

Reply

Mark Reeves September 19, 2011 at 2:38 am

Discovered while trying to figure out how the heck to track the numbered Traveling Squares of the Square Inches Of Love project (http://squareinchesoflove.com/). Thank you for writing this!

Reply

John July 12, 2012 at 6:55 am

By default form results go into a new spreadsheet:sheet 1 or the spreadsheet:sheet 1 from which the form was created

Anyone know how to set an alternate location of the form’s results? I’d like them on spreadsheet X:sheet y.

A solution by setting a property would be best, but a script could be used.

Thanks.

Reply

adam November 21, 2012 at 5:48 pm

hey bill,

do you know how to order form responses in order of most recent showing up at the top and the oldest submissions at the bottom?

this would be in the form responses sheet stored in drive.

Reply

Ernesto April 19, 2013 at 2:19 am

Hi there,

I am sorry I can’t help. I would like to know exactly the same!

Is there anyway to get the latest response on top?

Many thanks
Ern

Reply

Leave a Comment

Comment Policy: Please leave the best comment you can. Comments like, "Hey Nice Post" or comments that have been automated and make no sense will be deleted. Feel free to argue when necessary, but no name calling. I appreciate it and others will too.

Real Time Web Analytics