Using the combination of a spreadsheet and forms published on the Internet proves to be a ‘killer application’ for me in Google Docs!
I use this combination wherever I can – it saves endless time, headaches and hassle.
For Example
I regularly organise the meeting for a charity concern – the potential 100 or so attendees are spread all across the North East of England. Trying to get an RSVP or any kind of response to a phone call or email enquiry is like drawing teeth! Doing things the old-fashioned way just takes so long and is tedium personified!
These days I set up a new spreadsheet for each event, create a form using the tools in Google Docs and then take the code provided to embed into an easy to remember web page. I then circulate the URL via the email newsletter and wait for responses. I issue reminders at relevant times and gradually the sheet starts filling itself in!
One day before the event I export the data into Excel and use it to print attendance badges – Bingo!
No need for folks to even register or sign in at the event, they just collect their badge and walk straight in.
Think about using the same system for all kinds of tasks where you have a ‘one to many’ relationship and need to gather information from the ‘many’ – quickly, easily and accurately.
How about timesheets for remote workers or requisition of parts or consumables from out of town locations?
Signing up for courses and events is an obvious fit for this application, and the video on this page gives a great demo of how easy it is!
Want to know more? Do you have an IT problem I can help you with?
Get in touch today for friendly help and advice.
To prevent spam, please use the form below or call me on 07950 232926
[wpcf]
Comments on this entry are closed.