10 Advanced Tips & Tricks For Google Forms

If Google Forms is not yet your go-to form maker, it’s time for us to change your mind. You may think you know everything there is to know about Google Forms, but thanks to Google’s use-it-and-you’ll-work-it-out attitude, perhaps you don’t. There are a lot of powerful tools hidden away in places you may not ever find unless you know what you’re looking for. We’re here to make sure you know all the top tricks of Google Forms.

If you’ve been using Google Forms for the occasional survey, you may already know a few great reasons to use Google Forms over the competition. However, you may still be unaware of some of the most powerful tools it offers. Here’s how you can do some of the more interesting things with Google Forms.

Choose Your Response Destination

If you’re a moderate user of Google Forms, you probably already know that you can choose between storing your results as a spreadsheet or keeping it within the form. However, you may not know which one to choose or why. For starters, to choose your results destination, there is a button that says “Choose Response Destination”. Click that if you want to change your response destination to a spreadsheet, or to revert back to storing your results in the forms.

Google Forms Response Destination   10 Advanced Tips & Tricks For Google Forms

You may wish to use a spreadsheet to store results if you want to view them easily, or if you want to manipulate the data (more on that later). You might prefer to keep the results in forms though if you are expecting more than 400,000 responses as that’s the limit of rows in a regular Google Spreadsheet. If your results are in forms, you can always export them as a .csv file and import them into your desktop spreadsheet software any time.

Regardless of which destination you choose, you can always go to Responses > Summary of Responses to get a more visual view of the results, which is perfect if most of your questions were multiple choice or allowed to be graphed in some way.

Google Forms Summary Of Responses   10 Advanced Tips & Tricks For Google Forms

Add Spreadsheet Responses To A New Sheet

A step ahead from just putting your form results in a spreadsheet is that you can put your results into a new sheet on an existing spreadsheet. This means that if you’re doing regular staff surveys, you can get all the data collected on new sheets of the same spreadsheet. That makes it much easier to compare your results over time. When choosing your response destination (as detailed above), just choose an existing spreadsheet and a new sheet will be created for you.

Notification Rules

Although many people know that it’s possible to be notified when people fill out your Google Form, it’s not entirely obvious how you set this up. For starters, it can only be done when your results are going to a spreadsheet (see above for setup). In the spreadsheet, go to Tools > Notification Rules and choose whether you want to be notified every time or as a batch.

Google Forms Notification Rules   10 Advanced Tips & Tricks For Google Forms

Embed iFrame Of Form With Custom Width And Height

If you want to use a Google Form as a contact form on your website, or for some other purpose where it is useful to embed the form as an iFrame, it’s easy to do so. Go to File > Embed and choose the width and height of your iFrame. Then just cut and paste the code.

Google Forms iFrame   10 Advanced Tips & Tricks For Google Forms

Add Page Breaks

In order to spruce up your form and make it seem more manageable to people filling it out, it’s possible to add page breaks. Just click on “Add Item” and choose the Page Break. A header and description can be assigned for each page, which allows you to clearly separate each of the pages into questions of a certain type or for a certain type of respondent. These pages can then be used for threading and logic (see below).

Google Forms Add New Question Page Break   10 Advanced Tips & Tricks For Google Forms

Use Section Headers To Add Passages

To add a section header, use exactly the same process as for adding a Page Break (see above). The best possible reason for a section header is to separate questions that are all related to each other, but don’t need a whole new page. For instance, if you are a teacher you could enter a short passage and follow it with questions relating to the passage. This scenario can also be done using the Page Break as shown.

Google Forms Page Break   10 Advanced Tips & Tricks For Google Forms

Create A Self-Grading Quiz

We recently covered in detail how you can use Google Forms to create a self-grading quiz. For teachers, this is a really easy way to save some time with your quizzes. It also leads you on to many more ways you might manipulate the results of forms to make your life easier.

Create A Pre-Filled URL

If you want to pre-fill some answers for your respondents, go to Responses > Get Pre-filled URL. Then just fill the form out as you would like the respondents to do for any given question and save. You might want to do this on website contact forms in order to change the color of cells when a certain phrase is present.

Google Forms Pre Filled URL   10 Advanced Tips & Tricks For Google Forms

Threading And Flow (Logic Branching)

Logic branching is a fancy way of saying that your respondent will go to a particular page based on the answer they give.

Google Forms Logic   10 Advanced Tips & Tricks For Google Forms

For instance, if you say you’re Australian, the questions will relate to Australian regions. If you give a certain age as an answer, you could have age-appropriate questions afterwards. For any form question where the user can give one answer from a choice of set answers, you can click the checkbox for “Go to page based on answer” and tell the form to skip to the next relevant section for each answer they choose. You will obviously need to set up the relevant pages beforehand.

Scripting

There are no scripts for the forms per se, but there are many excellent ways to use Google scripting with your spreadsheet of results. If you have an inkling of an idea for something scriptable, these Google Script tutorials will get you up to speed and you can create amazing scripts with your form results as the trigger.

Learning More

If you’ve enjoyed learning about advanced tricks for Google Forms, check out the following Google webinar on advanced Google Forms.

What great tricks have you come up with for Google Forms? Let us know in the comments!

The comments were closed because the article is more than 180 days old.

If you have any questions related to what's mentioned in the article or need help with any computer issue, ask it on MakeUseOf Answers—We and our community will be more than happy to help.

10 Comments -

0 votes

mike shumake

Add Spreadsheet Responses To A New Sheet

To the best of my knowledge, this does not work if any other sheet in the spreadsheet is also attached to a form. So your example about multiple surveys coming to one workbook won’t work, I’m afraid. I tried to do this yesterday. If I’m wrong, please let me know!

shu

0 votes

Emily

I’ve found the same thing in our Google Apps for education, which was disappointing. Has anyone seen a workaround? I was wondering if I could “unlink” the spreadsheet from the previous form to keep adding one form at a time.

0 votes

gaguillen.com

0 votes

Luis Mier

This is great share. I am going to try it out myself. Thanks alot.

0 votes

Dheeraj S

really useful.

0 votes

Samra S

Great :) very useful, I m going to try this now :D

0 votes

Daniel

Is there a way of importing question straight into the form from a spreadsheet, rather than cut and paste into each question on the form builder.

0 votes

Angela Alcorn

I don’t think so, sorry.

0 votes

Rodrigo

Is there a away to embed address fields (not email addresses) or a map function in a google form?

0 votes

Paul

I’d like to create a sign-up sheet form, with a list of dates from which to choose.

Once someone chooses a date, we don’t want someone else choosing the same date.

is there a way to make the dates disappear from the form as respondents choose them?

thanks!