Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo
Workplace Software and Skills

5.5 Creating Forms in Google Docs

Workplace Software and Skills5.5 Creating Forms in Google Docs

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Learning Objectives

By the end of this section, you will be able to:

  • Create a fillable form using a template
  • Create a fillable form from scratch
  • Distribute the form and view responses

Google released Google Forms in 2008 as a feature of Google Sheets. It became a stand-alone product in 2016 and became its own program, which enabled Google to add more features to it. Forms helps you create an online form that tabulates responses and analyzes information gathered from the form. This is the main advantage of using Forms over creating a fillable form in Word. Forms not only collects the responses, but can also summarize the responses for you. You just need to plan the questionnaire, write and design the questions, and email the form link to respondents. It has an easy-to-use interface, like other Google products, and includes additional features to help you sort through and understand the form responses. Because you are collecting the responses electronically through the Forms app rather than having the responses saved in a document file, you have many more options for how to view and summarize your responses. In the Forms app, you have options to view individual responses, download the responses to Sheets, and view graphs that summarize all of the responses collected.

In the marketing department at WorldCorp, there are many uses for Forms. Forms might be more useful to the marketing department at WorldCorp because it is much easier to create a form and collect information in Google as compared with creating the form in Word. The process to create a form in Google is much more direct and Forms also summarizes the information collected right in the application. As the Google programs are web-based, we will use the web browser to construct the questionnaire, and the clients will receive an email with a link. After respondents answer the questions, Forms can automatically create graphs to summarize the responses, which you can import into other documents or programs if needed.

Form Templates

Creating a Form is like creating any other Google file. Begin in your Google Drive, select the New drop-down menu, and find Google Forms, as seen in Figure 5.49. From here, you have the choice of creating a survey from a Blank form or From a template. For this walk-through, we will choose From a template, but we will review how to create one from scratch in Creating a New Form. The advantage to using a template is that you can choose a form that is already similar to the one you might have in mind. Using a template from the Template Gallery (Figure 5.50) will help save you time, as all you will need to do is modify the questions and answers, and then add some new questions as needed.

Some of the templates in the Template Gallery are designed with specific purposes in mind: event invitations, contact information requests, order forms, work requests, and customer feedback surveys. As Figure 5.51 shows, most templates just have a few questions, and are meant to be modified and added to.

A pane displays options Folder, File upload, Folder upload, Goggle Docs, Google Sheets, Google Slides, Google Forms, More. Google Forms is selected and opens to Blank form, Blank quiz, From a template.
Figure 5.49 To begin creating a form in Google, you can either start from scratch (blank form or quiz) or use a template. (Google Drive is a trademark of Google LLC.)
A Template gallery is visible with options for templates shown in a variety of types and styles: (Event Feedback, Order Form, Job Application, Time Off Request, Work Request, and Customer Feedback (selected)).
Figure 5.50 When creating a form from a template, choose a category that is close to what you want to create. (Google Forms is a trademark of Google LLC.)
Customer Feedback template offers sample questions and options. A Feedback * window runs along the bottom. A toolbar offers options: Add question, Import questions, Add title/description, Add image, Add video, Add section.
Figure 5.51 Most form templates have only a few sample questions to get you started. (Google Forms is a trademark of Google LLC.)

Creating a New Form

If you want to create a form from scratch, select Blank form from the drop-down menu. The form will start with a blank document that says “Untitled form.” As in Docs, rename this file by clicking on the title bar to type the new name of the form. All new forms also have a blank space for a description, just below the form’s title. The respondent will see the description, so it needs to be informative to them, as Figure 5.52 shows. It is important to name the form; otherwise, you are not going to be able to find it easily in your Drive later.

Now, you can begin typing the questionnaire. Use the first sample item in the blank form—a multiple-choice item—or choose a different type of question using the drop-down menu on the right. There are eleven types of questions, as Figure 5.53 shows. Table 5.1 explains each type of question and what it is used for.

Question tab is selected. The survey title and description are at the top. The next pane is titled Untitled Question and a checkable bubble is shown for Option 1.
Figure 5.52 Add your first question to the form by choosing the type of question from the menu. Be sure to customize the form with a title and short description. (Google Forms is a trademark of Google LLC.)
A survey displays a Question type pane with options: Short answer, Paragraph, Multiple choice, Checkboxes, Dropdown, File upload, Linear scale, Multiple choice grid, Checkbox grid, Date, and Time.
Figure 5.53 Forms has similar question types compared with Word’s form controls. (Google Forms is a trademark of Google LLC.)
Type Description
Short Answer These are open questions (the answer can be anything). Similar to the “plain text” controls in Word.
Paragraph These are open questions. Similar to the “plain text” controls, but you can answer with a lot of text and paragraphs. There is no Rich Text Format control in Forms.
Multiple Choice The multiple choice question is like the “combo box” in Word. You can include an “Other” option. The “Other” option can be typed.
Checkboxes The checkboxes are the same as in Word controls, but in Forms, you can have an “Other” open answer as well.
Drop-down The drop-down is like the “drop-down list” control in Word. The survey taker has to choose one option. There is no “Other” option.
File Upload The survey taker can upload a document or a picture file (or any other file extension).
Linear Scale It is a scaling question that can be configured to start from “0” and end at “10.”
Multiple-Choice Grid This is a kind of multiple choice, which the survey taker has to choose one per row or column. There are many rows/columns.
Can be used for Likert scales.
Tick Box Grid This is a kind of checkbox, which the survey taker has to choose one per row or column. There are many rows/columns. Can be used for Likert scales.
Date This makes the user choose a date, like the “date picker” control.
Time This makes the user choose a time. It can be 24h or AM/PM format.
Table 5.1 Types of Form Questions Choose the question type that will give you the information you need. You have eleven question types to choose from.

You should learn the various question types, as there are many interesting options for how to set up your form. There is a sidebar that lets you add a new question, as well as several additional commands, as seen in Figure 5.54. The additional commands on that sidebar are importing a list, adding a text description (similar to the Design Mode instructive text in Word), and inserting an image or video for the question. Lastly, there is a command for making different section breaks; this can be used as a way to divide up the form, which can be useful if the form is chunked into different topics or if it is several pages long. For example, the demographic questions could all be in one section, and the TV viewing questions could be in another.

Icons displayed: Add question (plus sign inside circle), Import questions (paper with arrow), Add title/descriptions (large/small T), Add image (square with two triangles), Add video (rectangle with triangle), Add section (two rectangles).
Figure 5.54 The sidebar lets you add new questions or import older ones from previous forms. (Google Forms is a trademark of Google LLC.)

There are two toolbars in Forms. The top toolbar is used for themes. The bottom toolbar (Figure 5.55) gives the writer more question-level configuration options. It contains the Duplicate question command, the Delete command (the trash icon), and the Required toggle. If you select the Duplicate icon, Forms will repeat the previous question, so that all you need to do is edit the question instead of writing it again from scratch. The Delete command is for removing the question from the list. The Required toggle allows the form creator to make the question mandatory; in other words, the respondent must provide an answer for this question before sending their final responses. In the form, the mandatory question will be followed by a red “*” to indicate that the question is required. The last item is the three-dots menu drop-down menu that contains a few more question-level settings, like letting you add a description to the question, manage the list of questions, and change the order of the questions.

An icon for Duplicate (two pieces of paper stacked) and Delete (a garbage can) are visible along with a toggle for Required and More options (three dots).
Figure 5.55 The bottom toolbar has tools too, like toggling a requirement of the question. (Google Forms is a trademark of Google LLC.)

Importing Questions

Importing questions means adding questions from another form or form template to your current form. You can do this by choosing the Import button on the sidebar (as seen in Figure 5.56). This will take you to the gallery of form templates (Forms) or your archive of saved forms (Recent) that you have created. Select any one of these, and you will be taken to that form, where you will see the questions on a sidebar, as Figure 5.57 shows. In this example, we selected the Customer Feedback Form Template. Select the questions you want to import by ticking the checkboxes. When you are finished making your selections, select Import questions from the bottom of the sidebar. If you want to add questions from multiple forms, you will have to do the same steps over again for each form.

A toolbar with an Import questions icon is visible to the right of a survey template form.
Figure 5.56 You make creating a form easier by importing questions from templates or from previous forms you have created. You can select Recent to access the files in your Drive to search for the form you want to use for importing questions. (Google Forms is a trademark of Google LLC.)
Import questions pane displays Customer Feedback form selected with options: Select all, Rate your experience (selected), Feedback type (selected), Suggestions for improvement (selected), Name. Import questions (3) button at bottom.
Figure 5.57 You can choose to import all the questions in a form into the current form. (Google Forms is a trademark of Google LLC.)

If you want to import questions from a form that you wrote in Word, the easiest route is to create a new question using the type you need, then copy and paste the text from the other file. This is the most direct approach. Forms will not automatically recognize the type of question you want (such as drop-down list or checkbox), but if you create the question first, then you can paste the specific text into that question. There are add-ons that you can download to help facilitate importing questions from other file types, but using a copy/paste method can be a simple, easy way to get the information from one file into Forms because it involves fewer steps and is often less complicated than using an add-on.

Let’s use the fillable form that we created in Word and copy the information from a couple of the questions into Forms using this approach. First, create a blank form in Docs and open the fillable form you created in Word. Recall that the first line on the office supply order form is “Date.” In the blank form, you can set the first question to use the date question format type. We can then copy and paste the text from the Word fillable form into the question we just created. This approach is not necessarily importing the questions from the Word fillable form, but it provides a simple way to get the information from one file type into Forms.

Customizing the Form Settings and Theme

Although you cannot change the font or text formatting within the form questions, you can change the form theme, which applies some formatting changes globally throughout the form. In the top toolbar in Forms, you will find commands for document formatting and applying themes, as Figure 5.58 shows.

The first command, the painter’s palette icon, is for changing the overall survey form theme. When you select this, a sidebar, Theme options, will appear, with theme and background color configurations (see Figure 5.59). From here, you can choose an image for the header, such as a custom design or a company logo, as well as change the color scheme of the document or change the font type of the whole document. There are only four font types available.

The second command, the eye icon, is for previewing, and it displays the survey how the survey taker would see it. This can be a handy tool for previewing the form before it is sent to the survey takers.

The third command, the gear icon, is the Form Settings. When you access the Form Settings, you will see three tabs. The General tab gives you configurations for the survey takers, such as letting you collect the emails of survey takers, sending the survey takers an email receipt, limiting the takers to only do one survey response, and other configurations, as shown in Figure 5.60. In the Presentation tab, you can change some of the appearance options for your survey, such as the confirmation message, the order of questions (e.g., shuffled or in the same order each time), and other options. The third tab is Quizzes, which contains configuration settings for survey types and is used more commonly in the education industry.

Icons for Customize theme (a paint palette), Preview (an eye), and Settings (a gear) are visible with a Send button and More options (three dots stacked on top of each other).
Figure 5.58 The top toolbar is for previewing the form or for settings. (Google Forms is a trademark of Google LLC.)
Theme pane options: Text style (Header, Question, and Text (with options for font and font size in a drop-down menu)), Header (Choose image), Color (various colors displayed), Background (various colors displayed).
Figure 5.59 The colors can be adjusted to reflect your company’s brand. (Google Forms is a trademark of Google LLC.)
Theme options are visible for a form with tabs for selection.
Figure 5.60 You can add your company’s logo on the theme options. (Google Forms is a trademark of Google LLC.)

Now, go back to your Office Supply Order Form. Build out the rest of the questions from the form that we created in Word. We can use some of the tools now to customize the theme to make it more visually appealing and professional in appearance. Figure 5.61 shows an example of some customizations that you might choose to include in the form.

Required questions in a form are followed with an *. At the top of the form *Required is visible in red font.
Figure 5.61 Notice the asterisk following the questions that are required. (Google Forms is a trademark of Google LLC.)

Distributing the Form

The last command of the top toolbar is the Send button, which lets you start the actual surveying process. After you press Send, you’ll have four options of how to distribute the survey: you can type your clients’ email addresses and send it to them directly; get a public link, which you can paste into an email; embed the survey into a website; or post the survey to a social media account (Figure 5.62).

If you choose to send it by email, you will need to copy and paste or manually type in all of the recipients’ email addresses. You’ll be able to write the body and subject of the message, but there are limitations to the length and style of the message. You cannot do any text formatting or add graphics in this interface like you would if you constructed the email in your email program and included the form link. Note that the recipients will not see the other recipients’ email addresses in the list. Also, there is no way to use the email addresses in your Google Contacts or other contact list. This approach is best for a small number of recipients. If you expect to send the form to a large number of people, it is better to use your email program to send the form with the link.

The second option is to send the form via a public link. You can copy this link and paste it anywhere. For example, you can save it for later use, and send it to clients after a business activity has passed (e.g., after a successful purchase). You could also paste it into an email and send it to your recipients that way.

The third option is embedding, which will give you the .html code so that you can insert the form link on the company website. When you choose this option, the HTML code will be displayed. You can then copy that code and use it to embed the form on a website. This option can be used when you want the responders to go to your company’s website to answer the questions.

Send form window displays tabs for Send via, along with icons for Send by email, Send via public link, Embed html, and Social media buttons for Facebook and Twitter.
Figure 5.62 There are four ways to share the survey to the clients. Choose the link option to send the form through your email program. The form can also be embedded into a website using the html option. (Google Forms is a trademark of Google LLC.)

Lastly, you can send the form via social media. Forms has Facebook and Twitter (now X) icons on the right side of the Send form dialog box. Selecting one of these will allow you to embed the form directly onto your social media page or feed for others to access.

Viewing Responses

Once you send the survey, you may want to wait a few days for individuals to respond. You can consult the response statistics by going to your form and looking at the top of the form screen. By default, you are viewing the Questions tab, as seen in Figure 5.63.

A Quarterly Office Supply Order Form includes tabs for Questions (highlighted), Responses (3), and Settings. Images of office supplies scattered on a desk along with a coffee cup are visible.
Figure 5.63 Even before the survey is complete, you can check the response statistics. (Google Forms is a trademark of Google LLC.)

If you choose the Responses tab, you’ll be taken to the responses report page, as shown in Figure 5.64. At the top of the Responses report, there is a Google Sheets icon command; if you choose this, all the report output will be exported to your Sheets app, and from there you can download the file as an Excel file or CSV. Forms provides some basic visualizations for the response. If you want more in-depth analysis, you might use other programs more suited for statistical analysis.

When you want to close the form to new responses, you can toggle the Accepting responses lever on the right side of Responses tab. This means that no one can submit any more responses to your form.

Responses 3 tab is selected on a form. View in Sheets is hyperlinked at the right and a toggle for Accepting responses is indicated. A Summary tab displays information about the responses.
Figure 5.64 When you are finished accepting responses, you can get the results in Sheets. (Google Forms is a trademark of Google LLC.)
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.