Build a bug tracker in 5 mins

I like this. From mattf’s shinily resurfaced blog .

  1. Go to google docs, click new spread sheet
  2. Click form, create your form with title, description, severity (1 minor .. 5 epic fail), who’s responsible in a dropdown and reported by.
  3. Save your form
  4. Add conditional colouring in spreadsheet on severity
  5. Add a completed/status column
  6. Embed form onto a page/email form to bug hunters

Love the simplicity of this.

The only thing I’d add is that you should go into the resulting spreadsheet, go to Share | Set Notification rules and have it email you whenever anyone submits a form right away.