Industry guru Dave Taylor offers tech support on technical and business topics, including iPhone, iPod, Microsoft Windows, Sony PSP, cellphones, online advertising, CSS, Web design, business, Unix, Linux, SEO, Mac OS X, and shell script programming.     


How can I create a form in Google Docs?

How do I make a copy of a form or a document from Gmail email and then complete the form using the computer? I have tried and have achieved the level of "No Luck". So I wind up printing the form and completing the form manually. Then I scan it and send it to whomever. There has to be an easier way. I thought maybe using HTML might be the answer, but I can't seem to find out how to use it instead of the standard language of Gmail.


Dave's Answer:

There is indeed a good solution and it's one that involves software from Google, but it's not part of Gmail itself. In the never-ending race to compete with office software applications (e.g., against Microsoft Office, the killer suite of MS Word, MS Excel and MS PowerPoint), Google has been slowly but surely buying up innovative startups and tightly integrating quite a few different utilities to create Google Docs.

Most people think of Google Docs because of its ability to replace MS Word and let you do word processing right within a Web browser, with your document living in the so-called cloud rather than on your disk or trapped on your computer. It lets you do that, and nicely, but there's quite a bit more that you can do with Google Docs once you sign up for an account.

I'm involved with the Modern Media Man Summit and we're using Google Docs extensively for our document and data management tasks, including having Google Docs, by way of a form, manage the entire speaker submission process.

Let me show you how to set up a basic data input form and you'll see that it lets you quickly and easily create just the kind of form you seek.

One caveat before we start, however: it works, and it's pretty easy, but Google Docs is also quite crude in terms of customization options and I am hoping it'll be rewritten to offer greater flexibility. No word on that yet, however.

First things first. Log in to Google Docs, then on the top left, look for the "Create new" button:

google docs create new form

Choose a new Form and it pops up an untitled template:

google docs create form untitled

Start by giving your form a title and adding some basic explanatory text. I'll use this:

google docs giving form a title

Not too complicated, but the fun part starts after this: the second section of the form template is an input prompt skeleton and it's up to us to define it, label it, and configure it for our needs. For this form, I'll ask users for their name, zip code and favorite movie, then add a set of radio buttons that let them indicate whether they most recently saw the film in the theater, on TV, on a pay channel, on a DVD or on a Blu-Ray disk.

Ready?

google docs form sample question text

For this first question, we've indicated that the prompt should be "What's your name?" and that the resultant information should be text (that is, an open text field where they can type in anything) and that it's a required question: the form cannot be submitted without the user adding something here, though there's no way to know if it's really their name or "john doe" or something.

For the second question, we want to ask for their zip code. Same basic thing. To add a second question to the form, however, I'll need to use another text field because there's no "numbers only" field or really any method of form validation...

google docs form creation add item

Click on "Text", enter a prompt, click on the little "done" button, and now you suddenly realize a bit of a weirdness about Google Docs form creation:

google docs three fields entered

Where do you go from here? You have to keep using "Add Item", but before we do, there's an unused question that's crept into the mix, "Sample Question 2". To delete it before we proceed, you need to move your cursor over the right side of the question area, at which point a few buttons magically appear:

google docs delete unused question

Click on the tiny trashcan and the question vanishes from your form. Now click on "Add Item" again to add the question about favorite movie.

Now we want to select "Choose from a list" for the radio buttons ("radio buttons" is the HTML designer name for the element where you have more than one option, but can only choose one of them, just like radio stations on a car stereo). Choose it and the result is a bit different:

google docs add choose from list radio buttons option

The options we want to list are "Movie Theater", "Blu-Ray DVD", "Regular DVD", "Cable Movie Channel" and "Broadcast TV", so I add those, one at a time:

google docs form create select from list options

It seems like there's an extra option, but you'll see, it magically vanishes once we're done editing.

The next step, now that we have the fields we want, is to pick a nice theme so that it's a bit less boring. On the top there's a button "Theme: Plain". Click on it and you'll see the set of themes available to make the form a bit more interesting:

google docs forms choose theme

There are lots more, but I like "Finance Chart" so I'll click on it. Google Docs now shows me a preview of how that's going to look:

google docs form creation theme finance chart

Looks good. Click on "Apply" and you've set a theme for your form. Nice!

You can see the form as a standalone URL -- and share this URL with friends and colleagues, if you want -- on the dark bar at the very bottom of the screen:

google docs forms live form url

Since you want to email it, however, let's do that instead. On the top there's a button "Email this form". Click on it and you'll be prompted for some addresses:

google docs form email form

For a lot of email systems, however, the result isn't quite what we'd hope:

google docs form email message received

Still works, but what I like about Google Docs Form capability is that you can embed the form on a page with an IFRAME tag. I'll show you, I'll actually embed the live form here on this blog post!

To do that, on the top bar, click on "More actions" and choose "Embed":

google docs forms more actions embed

The result is a single line of code:

google docs form embed code

I'll actually paste it in here so you can see what happens:

That's all there is to it. Try entering the info and clicking submit. Thanks! You've just added your movie to the list. Notice that we never moved to a second page: it all transpires neatly within the embedded area.

Now, between all these different options, I hope you can figure out a fast and easy way to create a Web-base form and make your life easier!


More Useful Computer and Internet Basics Articles:
✔   How do I blur my house on Google Maps Street View?
I was poking around on Google Maps looking at satellite views of my neighborhood and when I switched to street view, was upset...
✔   Create a custom vanity URL for Kickstarter?
I was reading some updates on Twitter and saw someone had posted a URL that would let me see what projects they'd backed...
✔   Export or Save Subscription List from Google Reader?
Just heard that Google Reader is going away this summer. That stinks! How am I supposed to read my RSS feeds? More importantly,...
✔   Shrink or Reduce a Photo File Size on Mac?
I'm trying to upload some photos to a social media site and it's complaining that they're too big. They are, as they come...
✔   Can I organize my Yahoo Mail with folders?
I've been on Yahoo Mail for years and while most of my friends are now on Gmail or their own Web-based email programs,...

Let's stay in touch!
Sign up for my weekly AskDaveTaylor Newsletter and you'll receive even more tech and gadget help right to your inbox, along with exclusive news and industry updates. It's good stuff. I promise!
    Enter your name: and your email addr:  





Categorized: Computer and Internet Basics , HTML, JavaScript and Web Site Programming   (Article 9450, Written by )
Tagged: data input, google docs, google forms, microsoft office, ms excel, ms word, surveys, web site builder
Previous: How do I download music / get help for my Nextar MP3 player?
Next: How do I customize my Mac Weather Dashboard widget?




Reader Comments To Date: 1

harry said, on August 3, 2010 7:23 AM:

I would like to create a simple Google Form.

It will be a basic sales lead tracking chart for a small company. I need to have about 3 or 4 instances of "yes" / "no" or "if - then" to route questions and answers properly.

It looks like I can have a "checklist" or "choose from a list" - but it is imperative that I have a way to check from one list in one circumstance, and another for another.

Without this basic capability, it seems like this program is hopelessly crippled. Am I missing something?

Thanks for your help.

Starbucks coffee cup I do have a lot to say, and questions of my own for that matter, but first I'd like to say thank you, Dave, for all your helpful information by buying you a cup of coffee!

I do have a comment, now that you mention it!











I will never send you any unsolicited email. Ever.






Check This Out Too...

 
Look for Answers
Need Help? Ask Dave Taylor!


Follow Me on Pinterest

Find Me on Google+
ADT on G+
© 2002 - 2013 by Dave Taylor. All Rights Reserved.

Note: This web site is for the purpose of disseminating information for educational purposes, free of charge, for the benefit of all visitors. We take great care to provide quality information. However, we do not guarantee, and accept no legal liability whatsoever arising from or connected to, the accuracy, reliability, currency or completeness of any material contained on this web site or on any linked site. Further, please note that by submitting a question or comment you're agreeing to my terms of service, which are: you relinquish any subsequent rights of ownership to your material by submitting it on this site. My lawyer says "Thanks".
"Ask Dave Taylor®" is a registered trademark of Intuitive Systems, LLC.