Thursday, June 25, 2009 9:08 AM
Collecting information from coworkers is something that many of us do every day. Whether you're chasing after sales figures, budget projections, product feedback or TPS reports, the basic business of requesting, collecting, and processing information is, well, a basic part of business.Here at Google, we use spreadsheet forms for employee surveys, volunteer lists, product feedback and managing events like team offsites. Forms chase information so that we don't have to. Send a form with simple, straightforward questions via email -- and behind the scenes, your form busily updates your online spreadsheet with responses in real-time.
If you're already a convert to forms and were struggling to explain how they work to your co-workers, check out this short video we've created and then pass it along:
4 comments:
That's all nice in theory, but
- how do you reset the summary after entering a few test submits?
- how do you prevent people submit more than once, or how do you get their latest submit only?
- how do you prevent the summary to be skewed because of errors?
- how can you easily work with checkbox type questions, of which all ticked go into one cell?
- how can you edit the submitted data in a form like interface?
- how do you prevent the dreaded "You've temporarily exceeded your email quota. Please wait for a while and try sending again." keeping you from sending out your survey at that last minute?
- how can you limit the number of responses to your survey, e.g. when no more free tickets are available to your symposium?
- how do you edit the form - or your spreadsheet - without either of them getting jumbled up?
- how do you get the latest sumbits show at the top instead of at the bottom of the (spread)sheet?
- how do you filter out that SPAMmer that got hold of the form URL and now is filling the spreadsheet with garbage submits?
- and so on...
Looks really nice. I will give it try to see how it works.
Thank you
i wanted to use it, really! so i started off and added a second table to the spread-sheet with a summary report to show my boss. i printed it, and ... my boss asked me what all the grid-lines are doing on an official report.
i only wish i could use it. printing without gridlines really would make it usefull.
Won't print or save pdf's! Only get 403 FORBIDDEN. I need these things - stranded on a cloud. No thanks, utterly useless unless of course you don't need what you saved.
Post a Comment