Managing subscription to events through Google Docs
There are more sophisticated ways to let users subscribe/cancel to events,
but they are usually commercial and forms in Google Docs could be a good enough
solution for most cases.
Forms let users enter bits of information (Text, Paragraph text, Multiple
choice, Checkboxes, list, etc.) and data is saved into a spreadsheet.
The form can be accessed either throught its URL or by embedding it into
an HTML page (iframe).
Google Forms have the following drawbacks:
- No captcha to prevent SPAM, ie. automated subscriptions
- No way for users to unsubscribe from an event
- Doesn't send a confirmation e-mail, so users can't tell for sure whether
they've actually subscribed/cancelled
But it's free, it's easy to use, and again, could be good enough for most
users. If you need something richer, there are zillions of PHP/.Net/Java/Python/Perl
scripts out there.
- First, connect to Google through your Gmail acccount
- Click on the red Create button on the upper left-hand corner, and choose
- In the menu bar, choose Form > Edit the form:
- Change the default "Untitled form"
- (option) Add some text to explain what the event, where it will
be held, etc.
- Edit the question: Title (eg. "Enter your e-mail address"),
Question Type (eg. Text, for an e-mail address), and if needed, check
the "Make this a required question"
- Click on "Done"
- If you need to remove any unneeded question, move the mouse onto
it and click on the icon on the far right that looks like a trashcan
- Click on Save in the upper right-hand corner, and close the page
- Back in the main Google Docs page, in the list, you should now see the
new form you just created
- Click on this form, and you'll see its data displayed as an empty spreadsheet.
Pretty normal, as no one has used the form to enter any data yet
- To try the form, select Form > Go to live form. Once done, close
the form page
- Back in the spreadsheet, the data you just entered through the form
should be available
- To embed the form into a web page on your site, select Form > Embed
form in a web page, and paste the HTML code into your page (it's an iframe)
And voilą! Poor man's event subscription :-)