A simple way to collect data

So you have some questions you want to ask you members?  A survey would be great, but they are expensive to mail and your return rates will probably be low.  I have just discovered a nice way to collect data in a form and have each participants results saved to a Google Spreadsheets.

So assuming you have signed up for Google Apps for Domains, you have everything need, for free.  Google Spreadsheets lets you create forms that can be filled out by anyone.  So you can create a form and email to your members.  They can fill it out directly in their e-mail.  Or you can build the form and publish the URL.  People can then fill out the form on Google's site.  Want to see it in action?

Here is how you create the form.

Log into your Google Doc & Spreadsheets account.  Remember this part of your Google Apps for Domains package.

image

Create some questions:

image

Choose the share tab.

image

See the 'to fill out form" choice?  Choose it, it well worth the mouse click.

image

Now we press the the big start editing you form button.

  image You can see that hovering over field reveals an edit option.

Let's do some editing.

image

Ready to send.

image

Want to see the finished product?  Please fill out our survey.

If you are using this approach to collect member's opinions I would love to hear how it worked out, or not.

Digg It!  StumbleUpon  Reddit  Del.icio.us  NewsVine  Furl  BlinkList  Ma.gnolia  Technorati