Collect Data using Google Docs

Forms to automatically populate spreadsheets and integrate into ones communication systems –e-mail, blogs and websites — then the collation of data could become a lot easier. Forms can be e-mailed, viewed on line and embedded into websites. The resulting spreadsheet can also be downloaded in Excel format and therefore integrated with existing workflows

Experimentation

The best way to learn about these kind of things. I have created a form. Its a simple questionnaire about football and culture and their value to the business mind, constructed to support a debate about Urbis.

1. View the form online – HERE
2. See what it looks like via e-mail: SEND ME E-MAIL

Display Data with Google Charts

Google Charts has a neat mechanism to embed charts, graphs and maps into blogs. You incorporate them as you would an image. The code below generates the graph below it.

When editing your blog view HTML and add the code there. eg

<img src=”http://chart.apis.google.com/chart?chs=250×100&amp;chd=t:60,40&amp;cht=p3&amp;chl=Hello|World” alt=”Sample chart” />

Forms to automatically populate spreadsheets and integrate into ones communication systems –e-mail, blogs and websites — then the collation of data could become a lot easier. Forms can be e-mailed, viewed on line and embedded into websites. The resulting spreadsheet can also be downloaded in Excel format and therefore integrated with existing workflows