Use Google Docs To Collect Data with Form

7 May, 2009 Posted by SolSie As Tips,WebApp (1) Comment

image Google Docs has been offering online/offline for while. But not everybody got that feature enabled. I just realized my Google Docs had that  function turned on today. After few tests, I can confirm it works very well in offline and sync back to online.

Furthermore, I discover the capability to create a form to collect data that you can send to email recipients or embed to your Web site. The first example is when you want to send out a party invitation and the latter is when you want to set up a simple survey on your Web site.

The data collected will go to the spreadsheet , which can be viewed by all contributors  or by the owner only.

Create a form is truly easy process:

  1. Create a new spreadsheet (New- Spreadsheet)
  2. Just leave the spreadsheet blank and save with a name
  3. Click on “Share” tab on the top right corner
  4. Check on “to fill out a form”
  5. Click on button “Start edit your form”
  6. From here you can follow the wizard
  7. Upon completion, you will be given the option either to email or embed to your Web site (as shown in the below picture)

imageThe recipients  won’t need to sign in, and they can respond directly from the email message or from an automatically generated web page. Responses are automatically added to your spreadsheet. You can even keep a closer eye on them by adding the Google Docs forms gadget to your iGoogle homepage. It lists your recent active forms, with new responses highlighted. Add this gadget to your iGoogle page

Technorati Tags: ,,,,
Related Posts with Thumbnails
Categories : Tips,WebApp

Comments
719 May 8, 2009

I like it!

Leave a comment

(required)

(required)