Net Results

Google Forms can unclog company data bottlenecks

Challenge: In many organizations, filling out and processing business forms is a painful, messy and costly nightmare – the Guantánamo Bay of modern management.

You know these corporate detainees too well: travel expense claims, sales reports, satisfaction surveys, budget forecasts, employment applications and countless other "fill in the blank" documents. Yuck.

Forms are a necessary part of any business, but they're typically horribly designed, a soul-sucking chore to complete and constantly divert you from your "real" work. They're also expensive beyond measure: paper-based forms (which still inexplicably flourish) are often hastily completed, error-filled and manually rekeyed at least once (sometimes two or three or more times to different database silos).

All this adds hidden costs and time delays to critical business information flows. So how do you quickly transform all these data capture negatives into a more positive and efficient process – and all without spending a penny?

Solution: Google Forms at http://bit.ly/googleonlineforms may be your answer. Free when you register for a Google account, the service allows you to develop customized web forms with a few simple clicks.

To get started, choose from seven question types – such as multiple choice, free answer, check box, scale and grid. Add as many questions as you like in whatever type and combination. Embed explanatory text if necessary. Make the form short or long. Tailor it exactly to your information-gathering needs. Even spice up the look and feel of the form by selecting from more than 60 colourful themes.

Once your form is finished, send it out as an email, automatically generate it as a webpage or embed it into your website or blog. Invite whomever you want to respond, whether one person or thousands. Now sit back and watch as the data flows back into the spreadsheet in real-time.

You can even download and share the form data in Excel, pdf, text and csv formats.

How Google Forms can help your business: The tool has the potential to lower your paperwork costs and speed up information workflows. At last, you can reduce or eliminate the hassles of handwritten, paper-based, pain-in-the-you-know-what forms.

Being a Google tool, the service and all your forms are stored "in the cloud," or online. This means no more data silos: the forms are available any time, anywhere from any web-connected device. All data is accessed through secure connections, stored redundantly and automatically backed up. Can your existing system do that now? Didn't think so.

Usage tips: Start by looking at all your paper-based forms. Use Google Forms to capture that data online if possible.

Receive any updates by email or in Excel spreadsheets or pdf attachments? If so, create web forms that allow your colleagues to input that data directly on the web. You'll reduce errors, save time and speed up your workflow.

Also check out the "show summary" button, which automatically generates sophisticated charts and rich visuals from your data.

Bottom line: While Google Forms lacks some key features – a calendar date picker and an image upload capability that would allow you to add your own logo to the form and show pictures as options – the tool still packs a powerful punch. It allows you to instantly and easily create your own customized electronic form processing system at no cost. That's amazing when you think about it. Until recently, this capability was hugely expensive and available only to elite companies with big budgets. Thanks to Google Forms, small businesses of all stripes now have this power at their fingertips – power which can be used to improve online collaboration, transform data capture and optimize business performance.

comments powered by Disqus

More from BIV

BIV election coverage: Premier Christy Clark discusses her plan for B.C. businesses ...

Premier and B.C. Liberal Party leader joins Business in Vancouver's Hayley Woodin and Kirk LaPointe to discuss British Columbia's 2017 election.

Read Article

AI recruitment woes stall B.C. business expansion plans

Province lost nearly 300 software professionals to other regions in 2016 as AI funding flees

Read Article

Voters’ choice: government or ‘free market’ housing solutions

Read Article

BIV on Roundhouse April 28: Christy Clark talks Trump, Trudeau, trade and ...

Read Article

Anti-Horgan campaigns go dark

Third-party advertisers conduct media blitzes then go quiet after election is writ dropped 

Read Article

Subscribe to our mailing lists

* indicates required

Newsletters

* You can modify your newsletter subscriptions at the bottom of any newsletter you receive.
×