TOP 10 tricks to work faster in Google Forms

07/01/2020

Google Forms extend the functionality of the entire G Suite (formerly Google Apps for Work). They allow to create questionnaires and forms for websites. The data obtained in this way goes directly into a spreadsheet, which allows you to analyze the collected information on an ongoing basis, as well as quickly perform a summary of a given survey or poll.

If you have no experience creating online forms, our post on how to create a survey in Google Forms will get you up to speed.

Below are 10 tips that will make using Google Forms even simpler.

Adding colleagues

Google Forms enables several users to manage a single form. In this way, colleagues can work together on one document, all at the same time. To add a colleague, just open the form and click the three dots button in the upper right corner, then select “Add collaborators …”.

adding collaborators

Accepting only one response per person

Sometimes you want just one response per person. This allows users to complete the form only once. To enter such a restriction, open the form, select “Settings” and check the “Limit to 1 response” box. Respondents will have to log in to the form through their Google account.

accepting only one response from one user google forms

Allowing respondents to edit submitted answers

In Google Forms there is an option to allow edits to survey responses. In order for the respondent to make changes in the submitted form, it is necessary to select “Edit after submit” in the “Settings” menu.

Notices for respondents

For some forms, you may need to display a confirmation message to respondents. To set a message for people completing the form, in the “Settings” go to the “Presentation” tab an fill in the “Confirmation message” field.

send notification to responders

Sending an email confirmation to respondents

Google Forms allows you to send respondents an email confirming submission of the form. This is not a built-in function. First, you need to install the “Form Notifications” add-on.

Receive email notifications of new replies

It’s good to know when respondents complete the form. The owner of the questionnaire can enable e-mail notifications for new responses. To activate it, create a form and, click the three-dot button in the “Responses” section. Then, select “Get email notifications for new responses.”

Automatically saving responses in a spreadsheet

There is a function which allows to save form results in a separate document. To enable it, look for a green icon with a white cross in the “Responses” section (the Google Sheets symbol). From there, you can create a new document or select an existing one. Click “Create”. The information will be stored in the user’s Google Docs.

Change the form’s background color

The owner of the form can also take care of its visual side. To change the background of the questionnaire, run the form and then click “Customise theme” in the upper right corner. The user can choose the background image, customize the font and background color, and change the font.

View responses in real time

In order to analyze the answers submitted by the respondents, visit the “Responses” section and open the “Summary” tab. There are numerous pie charts and other visual analyzes of the responses of people who have filled out the form. You can also view each completed questionnaire.

Embedding a Google Form on a website

To conduct a survey on the website, you can take advantage of the embed option. However, it only works if the page is built using HTML. In other cases, IFRAME will be needed to display the questionnaire. To insert a form on a web page, click “Send” in the upper right corner, and then generate the HTML code for pasting onto the web page.

Google Forms is a great application that will help you streamline many aspects of your business. The above tips will certainly allow you to use all of the features of Google Forms more efficiently. For those who would like to make even better use of the G Suite package, we recommend the G Suite training (in-house or online).

See Also: 

TOP 10 tricks to work faster in Google Forms

07/01/2020

Google Forms extend the functionality of the entire G Suite (formerly Google Apps for Work). They allow to create questionnaires and forms for websites. The data obtained in this way goes directly into a spreadsheet, which allows you to analyze the collected information on an ongoing basis, as well as quickly perform a summary of a given survey or poll.

If you have no experience creating online forms, our post on how to create a survey in Google Forms will get you up to speed.

Below are 10 tips that will make using Google Forms even simpler.

Adding colleagues

Google Forms enables several users to manage a single form. In this way, colleagues can work together on one document, all at the same time. To add a colleague, just open the form and click the three dots button in the upper right corner, then select “Add collaborators …”.

adding collaborators

Accepting only one response per person

Sometimes you want just one response per person. This allows users to complete the form only once. To enter such a restriction, open the form, select “Settings” and check the “Limit to 1 response” box. Respondents will have to log in to the form through their Google account.

accepting only one response from one user google forms

Allowing respondents to edit submitted answers

In Google Forms there is an option to allow edits to survey responses. In order for the respondent to make changes in the submitted form, it is necessary to select “Edit after submit” in the “Settings” menu.

Notices for respondents

For some forms, you may need to display a confirmation message to respondents. To set a message for people completing the form, in the “Settings” go to the “Presentation” tab an fill in the “Confirmation message” field.

send notification to responders

Sending an email confirmation to respondents

Google Forms allows you to send respondents an email confirming submission of the form. This is not a built-in function. First, you need to install the “Form Notifications” add-on.

Receive email notifications of new replies

It’s good to know when respondents complete the form. The owner of the questionnaire can enable e-mail notifications for new responses. To activate it, create a form and, click the three-dot button in the “Responses” section. Then, select “Get email notifications for new responses.”

Automatically saving responses in a spreadsheet

There is a function which allows to save form results in a separate document. To enable it, look for a green icon with a white cross in the “Responses” section (the Google Sheets symbol). From there, you can create a new document or select an existing one. Click “Create”. The information will be stored in the user’s Google Docs.

Change the form’s background color

The owner of the form can also take care of its visual side. To change the background of the questionnaire, run the form and then click “Customise theme” in the upper right corner. The user can choose the background image, customize the font and background color, and change the font.

View responses in real time

In order to analyze the answers submitted by the respondents, visit the “Responses” section and open the “Summary” tab. There are numerous pie charts and other visual analyzes of the responses of people who have filled out the form. You can also view each completed questionnaire.

Embedding a Google Form on a website

To conduct a survey on the website, you can take advantage of the embed option. However, it only works if the page is built using HTML. In other cases, IFRAME will be needed to display the questionnaire. To insert a form on a web page, click “Send” in the upper right corner, and then generate the HTML code for pasting onto the web page.

Google Forms is a great application that will help you streamline many aspects of your business. The above tips will certainly allow you to use all of the features of Google Forms more efficiently. For those who would like to make even better use of the G Suite package, we recommend the G Suite training (in-house or online).

See Also: