Random notes about Google Doc Spreadsheet Web form lameness

I set up a Google Docs webform to allow parents in my kid’s classroom to enter the books their kids are reading.

Here are some lameness notes about Google Docs Spreadsheet Webform that I found:

Connecting a webform to a spreadsheet has not been appreciably enhanced since feature was introduced, specifically:

  • Cannot add notification rules to email others (or email lists)
  • Cannot customize the report
  • Cannot add minimal permissions based access to the webform and summary. For example, I would like:
    1. people to login
    2. enter information in the web form fields
    3. have one of the columns( UserSubmitting ) be the login user id (automatically generated like timestamp is)
    4. Be allowed to see a summary of only the data that has their login id in the UserSubmitting column
  • Allow multiple selection fields to be computed based on a VLOOKUP. For example, if the person enters “2 yellow” as the reading choice, the book choice should be based on an sheet:
    Reading level Book Title
    1 yellow Snowmen Play
    1 yellow Dogs and Cats Living Together
    2 yellow Bunnies and Hungry Dogs with sharp teeth
  • No ability to select from a list or enter an alternative not on the list.
  • No ability to enter a value for a field and then have it apply for multiple entries. This would be simple to do by having multiple pages. On the Thank you for submitting page, the user would have a link that would allow them to go back to marked pages. This could be configured when creating page breaks when creating the webform.
  • I know how to do this, but there is no cookbook/boiler plate examples for embedding the form in another webpage.

Final lameness, Gmail does not allow emailing tarred/gzipped google summary page because it contains executable content!

This entry was posted in broken, rants. Bookmark the permalink.

One Response to Random notes about Google Doc Spreadsheet Web form lameness

  1. Mike G says:

    Good thing it’s free then!

Leave a Reply

Your email address will not be published. Required fields are marked *