Google Docs: Forms, Templates and Tracking
We are huge fans of Google! Not only do they provide the best in search results, but they offer a variety of free services that make our lives easier. Honestly, if you haven’t looked into all the products that Google has to offer, you really should. Each working day, every staff member at Skybox Creative has at least one Google app open in their web browser.
From the awesome Google Calendar that lets you share your schedule or embed on your website to Google Wave for collaborative projects, Google Feedburner to update followers of new blog posts right to their inbox, to Google Docs for file sharing and form tracking…Google has what you need to make your business run more smoothly!
This post is specifically about Google Docs and the ability to create surveys, or any other type of form for that matter, and track the results in a spreadsheet. You even have the option to “Show Summary of Responses” where the data is compiled into bar graphs and pie charts – so easy a child could understand. There are a variety of templates to choose from (although we hope they add more template design options or at least the ability to customize colors sooner than later, nonetheless, they get the job done). You can create a form with ease, specifying whether you want a checklist, multiple choice question, paragraph answer, etc. Once you have completed the form, you have the option to email it or embed it on a web page (see below).
The results are tracked anonymously in a spreadsheet. You also have the option to share the ‘Results’ spreadsheet through Google Docs sharing options (now available for individual docs and entire folders). We have embedded our Client Satisfaction Survey below so you can see what it looks like. We had to force the width and height of the iframe in order for it to fit in our blog – not perfect, but again, gets the job done. If you embed the form on your blog, make sure to click on the HTML tab first, then paste the code. You can easily adjust the dimensions, just make sure to calculate the proportions to make sure it displays optimally. It’s also good to know that (for whatever reason), if you tab back to Visual, it might erase the iframe code – for this reason, we recommend copy/pasting the code in a text editing application so you can grab it again if needed!
Clients ONLY: Feel free to fill out the form with your feedback! All others, if you are interested in speaking to us about the services we offer, please email us at info@skyboxcreative.com
