Google Spreadsheet integrates another functionality: Forms. You can collect information by publishing these forms or sending an email and then review the data direct from the spreadsheet.
To give an example, I have created a spreadsheet; added a form; sent the form to recipients; added the form gadget in iGoogle; and reviewed the data online and in the spreadsheet itself.
To participate, click here. To view the result of the test, here.
Create a Spreadsheet. Go to Google Docs and create a spreadsheet.
Add a Form. Go to the Share tab. Click on Invite people to fill out a form. In this view, you can edit or resend the form, turn it off, or go view the live form.
Edit and Send the Form to recipients. By clicking on Edit or resend form, you create the form details including title, description, question type (text, paragraph text, multiple choice, checkboxes, choose from a list); and identify recipients individually or from you Gmail contacts.
Next, choose recipients.
The sent email will look like this. Once user clicks on the Submit button, a prompt will appear confirming the action.
Add Gadget in iGoogle. You can also add the forms function as a gadget in iGoogle.
The Form Online. You can view the form here. A shot is shown below.
This is the view within the spreadsheet. The replies are date and time stamped.
Nice job Google!
Filed under: Web Application | Tagged: Form, Google Docs, Google Spreadsheet
[...] Posts Google Spreadsheet integrates FormsKnickerPicker online dressing room shows real life modelsWhere to get Super Tuesday coverage2008 [...]
[...] China, Innovation, SecondLife, RedTubeKnickerPicker online dressing room shows real life modelsGoogle Spreadsheet integrates FormsGoogle Analytics tutorialWhere to find Mac keyboard shortcutsAboutHappySlip is back with new Adsense [...]
[...] Google Spreadsheets as database in the cloud Posted on March 5, 2008 by Carlo Maglinao Googler Jeffrey Scudder will introduce Google Spreadsheets API in creating a database in the cloud. We have seen a glimpse of how Google Spreadsheets can work as a database with the Forms feature, which we previously covered here. [...]
[...] March 19, 2008Randy Pausch’s Last Lecture: six months laterGoogle Maps allows users to edit mapsGoogle Spreadsheet integrates FormsWhere to find Mac keyboard shortcutsKnickerPicker online dressing room shows real life [...]
[...] example, with Spreadsheet’s Forms, you can create surveys or financial entries that are stored in your spreadsheet, which you can further process with Google [...]
[...] checking this TechBays post on Google Form and at the bottom of the post you’ll find at least three Possibly related posts. Screenshot [...]
[...] 3, 2008 by Carlo Maglinao When Microsoft announced its intention to acquire Yahoo!, we created a survey via Google Forms, which was also a new GDocs feature at the time, asking readers to vote whether the acquisition by [...]
[...] mine. We also began to play with Wufoo – a bells and wistles, pay version of Google Docs’s forms. I first thought I’d make some form about how students can link the concepts they learn in [...]
[...] mine. We also began to play with Wufoo – a bells and wistles, pay version of Google Docs’s forms. I first thought I’d make some form about how students can link the concepts they learn in [...]