The most complete guide to Google Forms you've ever seen. Experience of using Google Forms for surveying new employees Yandex forms as in Google

Hello blog readers!

There are times when you need to collect some data from your readers, conduct a mass survey, accept several applications, etc... Usually this is done through a form feedback or in the comments. But this is not very convenient and aesthetically pleasing. I propose to consider the option with the form from Google services. In my opinion, it is convenient, functional, nice and, if desired, can be easily integrated into the page, and if necessary, you can publish the results separately. You will see an example below.

Google Forms.

I don’t remember why it was the first time for me, I needed such a form, but I met her about 3 years ago. Since then, it has grown significantly with new features. Usually used to accept applications for participation in the competition, enroll in training, and once conducted a survey. If you think carefully, there are many applications. And so, let's start creating the form.

We go into our mail gmail.com, on the right side at the top we see a grate near our name, by clicking on which the main Google services open. Your location of the icon may differ from mine, as I arranged them in a convenient order for me.

Now we turn our eyes to the upper left part of the opened disk and click on the “create” button. From the drop-down menu, select "form" and proceed to its creation and design.

First of all, we enter a name and select a theme for our form. These settings can be changed after creation.

After that, the form itself opens for creating questions, which can consist of different elements. I will list the main ones:

  • Text
  • Paragraph
  • One of the list
  • A few from the list
  • Dropped off the list

And it is also possible to insert pictures, video, scale, date, time, etc... If you want to make any of the questions mandatory, then do not forget to check the corresponding checkbox.

To add the next element (question) at the bottom there is a corresponding button.

Well, in conclusion, click "send", a window appears with a link to the form. You can also enter email addresses people to whom you want to offer to fill out a form (questionnaire). And if you want to embed the form into a blog page, then click on the button of the same name, copy the code and paste it into the desired part of the page.

Let's see what Google form we got.

When embedding a form on a page, consider the dimensions for correct display. The width is usually 600, and the height depends on the number of elements in the form.

The survey below is working and you can answer questions, the answers can be published or left confidential.

If you want to publish the form on a separate page, then you first need to create this page and then also insert the iframe code. An example can be seen in my post, click on the picture below, the application form for participation in the competition will open.

You can not create such a page, but use it, the link is given immediately, before the iframe code is received.

Updated February 12, 2019. Lesson no longer works. With the help of Google, it is no longer possible to create a feedback form.
Today you will learn how to create, make a survey or questionnaire for your blog using a google form. This form can be embedded in a blogspot blog, wordpress, joomla site, ucoze, google site, etc. Let me remind you that in the last article we looked at how to create a form using .
Pros of google form:

  • ease of creation
  • loading fast,
  • free,
  • reliability.

There is only one minus - a backlink to google.
To create a form in the constructor from google, registration is required. If you are already a user of youtube, google + or blogger.com, then you have a google account.
Go to google docs, click on the button Create –> Form

The constructor will open in a new window:


On the top line instead of untitled form you need to enter a title. On the line below (“you can include any text or info that will help people fill this out”) you can give a short description of the form.
Below you see 2 fields Sample Question 1 and 2 (simple questions). In order to change these fields, click on the field edit sign (pencil icon on the right):

The next icon means the item is duplicated, and the trash can icon means the item is deleted.
Now let's start editing:


Question title - question, help text - auxiliary text, question type - element type from the following options:

Check mark next to the item Make this a required question adds an icon * – required to fill out.
To add an additional element to your profile or survey, click on the button and select the element type.
Button - save changes.
The button will take you to a new window where you can choose a theme.
Button will allow you to track the results of the survey.
Konka More actions –> embed to get the code to embed into the blog. Paste it into a blog post, page, or html/javascript widget (use the latter if space permits).
If you select the Edit confirmation option below, you will be able to edit the message that users will see after sending the message / survey results.


This is the sample form I came up with. You can try it in action.

You can view the results of the survey by opening the saved survey document (go to Google Docs again). You will see in the form of a table. Special tools will allow you to analyze the received data, edit, print, download and much more). These are the results of the questionnaire I got a few hours after the publication of this entry with the questionnaire.

your favorite color What's your gender How old are you?
8/18/2012 16:14:56 red feminine 27
8/18/2012 16:27:50 white male 21
8/18/2012 16:39:11 black male Z8
8/18/2012 19:12:56 red male years?

I hope you enjoy the new lesson. I look forward to your comments and feedback. Thank you for your attention.

Create an online survey using Google Forms

docs.google.com/

At the very beginning of the master class, we already made presentations using the resource

Google Docs. This service also allows you to create and publish surveys, or

Look at the brief but bright instructions for working with forms (author M. Smirnova)

http://docs.google.com/present/view?id=dgtqtkvs_686ftd3j8dd

Using the suggested tool, create your own form that could

useful in working with students. This could be, for example, a biology assignment.

or questionnaire.

For your convenience, I offer step by step instructions creating a survey "Landscaping

1. Go to http://docs.google.ru, introduce yourself to the system using your login and

password for Google (1 lesson).

2. Using the menu Create select The form(form)

3. Name the survey, write a message to the respondents and/or a brief

instructions for the entire questionnaire as a whole.

4. Having finished with one question, move on to the next and so on until

the entire questionnaire will not be ready.

6. How do I invite other people to take a survey? Please note that below

This is what you need to send to the respondents.

7. How do I view survey results? The service quickly and clearly presents

View responses to open them in Summary or Table view.

8. How do I open the form and responses when I sign in to docs.google.com again?

First, find desired file, open it.

A table with the results of the survey (task) will immediately open.

You can switch to edit mode using the menu Form - Edit

In the same Form menu, you can choose another type of presentation of results -

Show a summary of responses.

How to quickly create a survey on your site using Google Forms?

Sooner or later, almost everyone who has their own website is faced with the need to create feedback forms to collect data (surveys) from site visitors. This may be a form in the contacts section, through which site visitors will send you questions of interest to them, it may be a form for collecting applications from customers (for example, requests for a callback or applications for the purchase of goods), or it may be a form for conducting a survey or voting on topic that interests you. There are several approaches to creating such forms: Forms can be made using HTML tags and bind pressing the "Submit" button with sending the entered data to you by email. You can make a PHP + MySQL bundle (or any other programming language and database) and save all the entered data to the database for further work. If your site is made using some popular CMS (for example, Joomla, Drupal or WordPress), then you can search the web for plugins, modules and components that simply allow you to create forms. And you can use free tools to create feedback forms for everyone famous Google.Docs And in this article I would like to show you how you can easily and quickly create all kinds of survey forms for your sites using Google.Docs. So, let's begin! The first thing you need to do is to log into your mailbox in the Gmail mail service (in your account in the google service): https://accounts.google.com/ Next, at the top vertical menu select Disk.
On the page that opens, in the left vertical menu, press the "Create" button and select the "Form" item from the drop-down list
After that, we find ourselves in the free form editor from Google.Docs, and it is in it that we will create our forms. In the first window, the google form editor asks us for the name of our future form and offers to choose a design theme from existing themes.
After the name is entered and the choice of theme is made, click the "OK" button, and we get to the page for editing our form. I will not talk about all the features and settings of the Google form editor in this article, because. most things are known by the “poke method”, plus everything, there is not the worst help from Google: support.google.com/drive/bin/topic.py?hl=en&topic=1360904&parent=2811744&ctx=topic. Here I want to dwell only on those points that you need to know in order to create your first form right now. So, here is the interface of the Google form editor:
At the top of the editor there is a small horizontal menu responsible for the basic settings of the form. In it, you can change the design theme, change the settings for saving the input data (save to a new Google.Docs table or to a new tab of an existing table), and also open the created form for viewing by clicking on the "Open Form" button Remark: Be sure to set the save settings by clicking on the "Save answers" button. If you select "New Table" in the save settings, Google will automatically create a new table for you, the name of which will match the name of the form you created and the postscript (Answers) Below are the visibility settings for your form. Using these settings, you can allow the form to be viewed by everyone (uncheck all checkboxes), or vice versa, make the form available only to users of this domain and you will need to go through authorization to fill it out. Be careful with visibility settings. Although there are only two checkboxes from all the settings, but if you make a mistake in them, then your entire survey may fail, people simply will not get access to the form. Next, there are buttons for editing the element added to the form. At any time, you can change the caption for the form element, the hint (explanation), change the type of the element (Google offers us a choice of 7 different elements, from a simple clock input field to a whole two-dimensional array of radiobutton elements), any element can be made mandatory for filling, etc. At the very bottom of the page with the editor is the block "Change confirmation". Here you can allow the form to be re-filled, make the link to the results of the survey being conducted visible to everyone, allow respondents to change their answers after filling out, and change the confirmation text that will be displayed to all respondents who completed the survey form. The ability to change the text displayed after filling out the form will give you the opportunity not only to thank the respondent who completed the survey more exquisitely, but also, for example, give him a link to download some gift as a reward for the work done. After all the necessary form fields have been added, click on the "Open form" button in the top menu and you will see your brainchild with all the elements and input fields:
Next, you can send your created survey form by mail, send a link to this form to the respondent, or embed it into your website. Embedding in the site is elementary. You just need to select the “File->Embed into Web Page…” item in the top menu of the form editor and the system will generate an iframe for you to insert into your website, blog, etc.
That's it, our new site visitor survey form is ready! All data filled in by respondents will be available to you in Google Spreadsheets. In addition, at any time you can see general statistics on the dynamics of filling in the fields of your new form in the section of the upper horizontal menu "Answers->Summary of answers":
As you can see, such a tool is quite flexible in settings and will allow you to create and conduct a survey of visitors to your site or any other group of respondents in a matter of minutes. At the same time, you do not need to create an HTML form yourself, you do not need to organize interaction with the database, you do not need to search for plugins, modules and components suitable for the CMS you use. Also, there is no need to code interfaces for displaying statistics with displaying survey results. Plus, if you throw a lot of traffic on such a survey form, then with a high probability Google servers will withstand it! And all the data entered by respondents will always be available to you in your Google account.

Quite often a task arises when it is necessary to conduct a survey of site visitors. Standard Tools, are usually a simple multiple-choice survey and almost never provide handy tool for analytics (especially when you want to publish real-time analytics).

The article describes the main steps for creating and integrating a survey form into a site page, as well as the main analytics tools and the possibility of embedding it into site pages.

The survey, you guessed it, will be conducted using Google Forms

Step one. Create a survey form

We will not consider how to correctly compose questions and how to group them - this is not the purpose of our article, but we will consider the process of creating the form itself.

1 Form creation

After that, we immediately open a new form:

Do not forget to give a beautiful and understandable name.

2 We form questions

I will not describe in detail the process of creating questions and placing them, as this is worthy of a separate article. (here is a link to the article). Consider only the types of questions and how best to use them.

Text - can be configured to contain a number, e-mail or URL, the first in processing is convenient to use the rest mainly for identification and communication with the respondent, we are not interested.

Text (paragraph)- not the most convenient type of question for automatic processing

One of the list- a good option for a clear answer (the main thing is not to add the "other" option)

A few from the list- if the answer does not contain commas, then it is possible to process, but still quite difficult: try to refrain from such questions

Drop-down list- essentially the same as one of the list

Scale- a convenient way to get some kind of assessment, just as easy to process

Grid- in fact, an array of scales, but the answer is not in the form of a number, but in the form of a column heading, hence the more complex processing of answers

the date- a very convenient way to get a date or date + time, easy to process

Time- similar to a date, you can also get the duration, easily processed

Based on how familiar you are with data processing methods (especially text data), you should form a list of questions and their correspondence to types.

If you want to embed the survey directly in the site page, then use File --> Embed in Web Page

Width and height can be specified as a percentage, below is inline with a width of 95%

For HTML gurus who want to integrate the survey form specifically into their site, you can copy the tag from the form page

with all the content and customize the styles yourself.

Step two. Collection of responses and their analysis

To do this, go to the automatically created table with the answers to the form

A table with answers will open.

But we are not very interested in this, since we need to visualize the data.

For visualization, we will use charts, and for each table-selection it is necessary to create a separate sheet.

1. We process numerical data on all issues

Processing numbers throughout the table is not a big problem, since it is done with standard spreadsheet editor formulas.
For example:
Average age: = AVERAGE ( "Form Answers (1)"!B:B)
Median age: = MEDIAN ( "Form Answers (1)"!B:B)
A complete list of functions can be found there, a huge number of them.

2. Count the number of text responses

In our case, it will be interesting to calculate the number of respondents by country:
=COUNTIF( "Form Answers (1)"!C:C; "=Russia")
And so for each answer.

3. Get part of the table

Sometimes it becomes necessary to obtain some data from a part of the answers, for example, the average sleep duration of respondents from Russia.

To do this, we will use a more powerful tool that brings Google tables closer to full-fledged databases - SQL queries.

QUERY()

It is unrealistic to consider all query options here, but consider the most basic one.

Problem with formatted cells: data from cells with formats other than numbers and text is not always accepted: force the format "Plain text" on the source table

With the help of such a query, we received all the answers of respondents from Russia; similarly, you can filter by any column.

ATTENTION! You cannot make changes in the table obtained as a result of the query, nor can the table fall into filled cells.

You can process the received data in the same way as in paragraphs 1 and 2

Step three. Visualization

The most important part is to prepare data visualization, for this you can use charts, we will not consider standard charts, but follow in the footsteps of the last article

Diagrams, for order, it is better to keep on separate sheets

If you're not already familiar with the free yet powerful Google Forms tool, now is the time to do so.

Google Forms is a quick and easy way to collect information from your users through online forms. All you need to use them is the presence of an electronic Google mail, and adding them to the site is very simple. Google Forms can be used to create a simple contact form, a customer survey form, or something more complex. And in this article, we will provide you with all the information you need to add a Google Form to your site.

What is Google Forms?

Google Forms is one of many free apps from Google. The forms tool can be used to complete a survey, collect contact information, conduct an exam, take orders, transfer files, and more.

Results and form information are easily accessible and stored in the cloud as part of your account Google drive. To create forms, there is a large selection of ready-made templates, and editing them has an intuitive interface.

If you need to collect information online, such as customer questions, technical support requests, or orders for goods/services, Google Forms is an effective fit. Let's create our first form and add it to our site.

How to create a Google Form

The first step in this process is to create Google account(if you don't already have one). After that, you can go directly to Google Forms.

You will immediately be provided with ready-to-use Google Forms templates that can serve as the basis for your own form. If you decide to start with an empty form, just click on the big block with a plus sign (+).

In addition to common form elements such as fields and buttons, you can easily add a number of other elements to your forms. These optional elements can include YouTube videos, Google Photos images, questions, and plain text.

Changing the look of a Google Form

You can view your form at any time, and you can easily change the design's color palette. With a few settings, you can customize access to it and how the form will work. These settings include the ability to enter multiple responses from a single user, the order in which questions are displayed, whether the user must be authorized, and a confirmation message.

Posting a Google Form

Once you're happy with the form you've created, you can make it available by clicking the button Send in the upper right corner of the screen. The form can be shared via email, via a link, or by embedding on a website page. There is also the option to share the form on social networks.

View Google Form Results

Once you've made your form available to an audience, either through a link or through your website, you can begin to monitor the results of your form submission. This happens through the tab " Answers» in the form designer.

One of the great Google features Forms is a feature that makes it easy to view responses in real time, either individually or as a summary. You can also view the responses in a Google Sheets spreadsheet, which allows you to filter the results in many different ways.

Enable notifications for e-mail when receiving form responses is another useful feature that will help you keep track of user interactions.

How to add a Google Form to a website

by the most fast way Adding a Google Form to your site is copying and pasting the iframe code into the page code on your site.

Sample embed code:

ID FORMS for a real form will be replaced by a unique identifier.

After you insert this short form code into the page code, it will be replaced on the site with the corresponding Google form, which will be ready to interact with your site visitors.

Share with friends or save for yourself:

Loading...