10 Advanced Tips & Tricks For Google Forms

Ads by Google

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.

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.

Ads by Google

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.

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.

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).

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.

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.

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.

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!

Join live MakeUseOf Groups on Grouvi App Join live Groups on Grouvi
Web for Kids
Web for Kids
20 Members
Deep Web Communities
Deep Web Communities
35 Members
Awesome Websites
Awesome Websites
69 Members
Best Music Services
Best Music Services
26 Members
Ads by Google
Comments (39)
  • Liam

    Hi there,

    I’m currently experiencing following problem:
    Under Question type, I chose Multiple choice and I checked the box “Go to page based on answer”. One of the answers, I set the option to go to “Submit Form” because I want my correspondent to stop there and submit the form. However, when people filled out my form and chose the above option, it didn’t take them to the Confirmation page to submit the form. It let them continuing with the survey.
    Please let me know if I’m doing something wrong or it’s actually a bug and if there’s a fix or work-around for this. I want an option where the correspondent must stop the survey and go to the confirmation page to submit the survey.

    Thank you!
    Liam

    • Abhijith Thulaseedharan

      Well , I m not a programmer, but create another mutliple choice question at the last of that section. and ask the users whether they want to continue to the next page (mention the content) or go to the last page/ submit confirmation page..

  • Scott

    Helpful article. I also have a couple of questions.

    1. Assume I send out a Google Form via email to a list of 100 people. Instead of asking them to include any of their identifying info (name, email, etc), is there a way to automatically track who submitted a response…be it through a hidden field or some other means?

    For example:

    I send a form to “johndoe@yahoo.com”. When John Doe responds and submits the form, my excel spreadsheet automatically recognizes that the form was submitted by John Doe?

    2. Is there a way to automatically populate a field based on the answer provided in a previous drop down menu?

    For example:

    A respondent selects the state they live in from a drop down menu. When she selects “California” for example, the next drop down menu pulls up all the relevant cities in California.

    Thanks!

  • shivapriya

    Google forms is diificult to edit from an android phone. if there was an android app to create forms, it would have been nice.

  • shivapriya

    Google forms is diificult to edit from an android phone. if there was an android app to create forms, it would have been nice.

  • Jennie

    Hi,
    I was just wondering if there was a way to only allow a video to play once?

Load 10 more
Affiliate Disclamer

This review may contain affiliate links, which pays us a small compensation if you do decide to make a purchase based on our recommendation. Our judgement is in no way biased, and our recommendations are always based on the merits of the items.

For more details, please read our disclosure.
Affiliate Disclamer

This review may contain affiliate links, which pays us a small compensation if you do decide to make a purchase based on our recommendation. Our judgement is in no way biased, and our recommendations are always based on the merits of the items.

For more details, please read our disclosure.