Excerpt from:  FAS Talk
.
August 31, 2008

Google Docs Replaces Survey Monkey

For simple data collection, Google Docs is a practical (and free) alternative to SurveyMonkey.com.

For a long time, we've used SurveyMonkey.com to create simple online questionnaires.  But from the beginning there was one gotcha that always bugged me... SurveyMonkey.com does not offer any means of notification--no e-mail, no RSS, no API, nothing.  As a results, we were continually logging into SurveyMonkey.com to see if we had any new submissions.

Well, a couple weeks ago, we went a few days without checking and, as Murphy would suggest, we failed to notice a new RSS feed order for a few days.  That was the straw the broke the camel's back.  I went looking for an alternative solution--and I found a great one in Google Docs spreadsheets.

As it turns out, its is very easy to create a web form to that captures results into a Google Docs spreadsheet.  And since Google Docs provides a flexible mechanism for e-mail notification, sharing access with other users, online backup, access to data in multiple formats, this turned out to be a much better solution than SurveyMonkey.com.

So, with very little effort, I replaced the MyST Enterprise RSS Setup Questionnaire with a form that feeds into a secure Google Docs spreadsheet.  Now, the right folks within MyST get e-mail notification the moment a new submission occurs.

If you're looking for an easy-to-use form capture mechanism, take a look at Google Docs spreadsheets.

Comments
.

Google Docs Survey

How-To's ?
I've read on several other boards that one of the main differences between the two services is that SurveyMonkey allows the survey to be taken only once per address.  Can this be done in Google?
.
.

Google Docs as Form Capture

@Annie: I'm not sure if there is a way to limit number of responses per address.

Our requirements have been for basic form data capture and we were using SurveyMonkey because it provided a really simple form layout and publishing mechanism. I've not had the requirement to limit responses--I actually wanted multiple responses in most cases--so I've never investigated your question with respect to Google Docs.

.
.

RE: Google Docs Replaces Survey Monkey

thanks and question
Thanks for posting this, definitely sounds interesting. Could you please explain how you went about setting this up on Google docs? I have a google group already set up for our account team (if that helps). We would like to set up a survey for a client that I think would probably just be a little freaked out by using anything that included the word "monkey," lol. So I am very curious as to how to go about using Google docs as an alternative . ..
.
.

RE: Google Docs Replaces Survey Monkey

@Rachel: How to set up the form

To create the custom form, I used Google Docs to create a Google-hosted form.  Then I simply looked at the generated form, lifted the relevant HTML, and pasted it into my own CMS (MyST Blogsite, in this case, but any HTML web page would do.)

I basically rewrote the generated HTML to simplify it, style it the way I wanted, and to add some simple JavaScript form validation logic as you might in any web form.  The key was starting with the Google-generated form so I had the appropriate field names and action address.

To see the detail, feel free to view the source of this page:
http://myst-technology.com/public/enterprise-rss/setup

(Search the source for "SETUP_FORM" to find the custom form.)

There is a little HTML/JavaScript trickery that may not at first be obvious.  This is not absolutely necessary, but I added it to provide a little smoother user experience.

First, there is a hidden DIV element that contains a thank you message.  The JavaScript shows this DIV after the form is submitted.  Search for "ID_Response" to find this DIV.

Second, there is an empty IFRAME (search for "id_result") that is used to hold the response from the form submission.  This is accomplished using target="id_result" on the custom FORM element.  And, since we present our own "thank you" message for form submission, we really don't need to see Google's response, so I set the height of the result IFRAME to 1.

Topic Tags:  ,
.
.

RE: Google Docs Replaces Survey Monkey

This works great, but I've got one question.  How do you get google to email the responses to your inbox?  I don't see an option for that.

Thanks!

.
.

RE: Google Docs Replaces Survey Monkey

@Laura
To get notifications, set your notification preferences in Google Docs.  You can set it up so you receive a notification each time the document changes.
.
.

RE: Google Docs Replaces Survey Monkey

There's something even easier now
Just been using http://www.alphastudy.com and have to admit it was even easier than SurveyMonkey and GoogleDocs. It allowed me to create the questionnaire and surveys I wanted, could also share it on my FaceBook. Worth a look.
.
.

RE: Google Docs Replaces Survey Monkey

It's useful if you need a way to feed spreadsheet data through an online form.  But for questionnaire based surveys it's better to use a tool like limesurvey or Rational Survey as a great survey monkey alternative.

.
.

RE: Google Docs Replaces Survey Monkey

I've been using http://www.mobosurvey.com to create surveys for mobile phones. A very easy and intuitive way to create surveys with desktop and mobile preview.

Topic Tags:  
.

Syndication OptionsRSS (Rich Site Summary) Feed Atom Feed OPML (Outline Processor Language) Feed MYST-ML (MyST Markup Language) Content Feed MS-Office Smart Tag Subscription