Pinterest Stumbleupon Whatsapp
Ads by Google

If Google Forms Use Google Forms To Collect Contact Info On A Mobile Device Use Google Forms To Collect Contact Info On A Mobile Device Using Google Forms, you can collect names, emails, and other contact information on your computer or mobile device that supports mobile browsing. All the data is saved to a spread sheet which can be used... Read More 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 5 Awesome Reasons To Use Google Forms 5 Awesome Reasons To Use Google Forms If you've ever tried to make an online survey, you've probably tried a few tools here and there. You've no doubt enjoyed some features of one product, and some of another, while being frustrated at... Read More 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 How To Use Google Forms To Create Your Own Self-Grading Quiz How To Use Google Forms To Create Your Own Self-Grading Quiz Are you a teacher or trainer? Someone involved in a hiring process? Do you need to check somehow that other people have the skills or knowledge that you expect them to? Well, you're going to... Read More . 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.


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!

  1. Nicola
    September 19, 2016 at 9:32 am

    Is there anyway to have users exit the survey based on their answer? I need users to answer a qualifying question at the start and if they answer no, I want them to exit the survey. So far the only option is to set it to complete the survey if they answer no. Not ideal as their result is recorded and they have to see the thank you for completing screen which doesn't make sense. Any help please?

    August 28, 2016 at 6:31 pm

    Is there a way to give multiple responses to the same question

    • Ferdinand Cortez
      August 30, 2016 at 10:57 pm

      Are you looking for multiple lines per question? If so, yes. You may use the grid option.
      On the other hand, if this is a quiz with multiple correct answers, you may use the check box option.

  3. Irene
    July 25, 2016 at 6:16 pm

    I need a grid where respondents can mark multiple responses on rows AND columns. It appears that this is not a possibility with Google Forms -- am I missing something?

  4. Stephanie
    July 14, 2016 at 1:46 am

    Is there a way to assign point values to each answer? Like A=1, B=2, etc., so that the student will end up with a score, but not for a grade? (Like if you scored between 0 and 20, then this descriptor, between 21 and 40, this descriptor, etc.)
    Thank you!

  5. Fungai
    June 29, 2016 at 11:55 am

    Hi folks,
    Anyway to make like 100 questions but the respondent only answers 10 and they are randomised?

  6. Ryan W.
    June 29, 2016 at 4:06 am

    Is there a way to filter response destinations based on the answer to a question in Google Forms?

    For example: Tom is from California, and Rob is from New York. Rob will only see responses from those who selected "New York" at the beginning of the form.

    This would be very helpful!

    • Jackie Luckett
      October 19, 2016 at 8:21 pm

      Where you able to find a solution here? Thanks!

  7. Ankit Jain
    June 2, 2016 at 6:28 am

    How can we mark a 'enter' in between a question?
    For ex. my question is

    Select the adjective from the following sentence.

    The Taj Mahal is the world’s grandest monument.

    • Graham
      August 9, 2016 at 9:33 am

      Give them a drop down list question with all of the words to choose from
      Select the adjective from the following sentence;" The Taj Mahal is the world’s grandest monument."


      Taj Mahal

  8. Shayna Amato
    May 31, 2016 at 2:45 pm

    Useful post - I Appreciate the facts . Does anyone know where my assistant would be able to acquire a blank VA DoT VA-5 document to work with ?

  9. Reese Paige
    May 20, 2016 at 6:44 pm

    Does anyone know how when someone is filling out the form, they can upload multiple photos?

  10. Nikki
    May 4, 2016 at 6:11 pm


    I have a google form that is more like a sign up sheet.

    I need to be sure that we don't have duplicate sign ups for each slot. In other words: we need each family to sign up to work a time slot and once they have filled in that slot, no one else should be able to (unless the previous family deletes their sign up.)

    Is there a setting that I'm missing to do this?

    Google forms sure is complicated for something that seems very simple and helpful at first.

    Thanks in advance for responses!!!

  11. Katie
    April 9, 2016 at 2:53 pm

    Is there a way to make a multiple choice answer disappear after being chosen "x" number of times?

    • Bob
      April 15, 2016 at 4:36 pm

      Hi Katie, I think the choice eliminator add on will do what you are looking for.

    • Julian Varga
      May 31, 2016 at 7:28 pm

      I think you can choose to allow only one response, however you will need to require sone sort of credentials to log in, such as an email.

  12. Kenzo
    March 23, 2016 at 8:13 am

    How can i delete a response, which i don't want to show up?

  13. Anonymous
    March 3, 2016 at 9:22 pm

    Is it possible to instal the form so that the people that fill in the form can't go back to change their previous answer?

    • Susan Fitzmaurice
      October 8, 2016 at 12:48 am

      I really need this too/ I especially want it for the email address. A lis of grauate students emails change often.

    • Jennifer Baggette
      October 12, 2016 at 5:15 pm

      Curious about this as well!

  14. Ali
    February 18, 2016 at 9:32 am

    Hi, is it possible to create form where the user sorts responses? So a user could choose "Apple, Orange Pear", or "Orange, Pear, Apple". The application I'm thinking of has 10 possible answers so its too big to have all the possible combinations as answers. But if the user could drag/drop then any combination is possible, surely?

  15. Ivan Sullivan
    February 17, 2016 at 11:33 am

    Hi Angela, is there a way of knowing who took your survey, if the survey was anonymous? Just so as not to bother people with a reminder email

  16. mb
    February 1, 2016 at 2:25 pm

    Is there a way to keep all incoming data sorting in a "z to a" manner? I know how to sort the data, but I want the new data to be recorded following the existing sort. (Just sorting by date and want newest to stay on the top.)

    • Angela Alcorn
      February 1, 2016 at 3:06 pm

      I would just start a new tab (sheet) and put a SORT() function in that for all of the response columns.

  17. vvvv
    January 30, 2016 at 6:22 pm

    This viewanalytics URL is revealing information of any form. This is a security issue.

  18. Cheryl
    January 22, 2016 at 3:02 am

    Two questions:
    1. I am asking for the respondent to enter an email address for a followup survey (will not be the original email the respondent takes the survey with) — is there a way to ping the new email address during the survey to make sure it is a true address?

    2. Is there a way to connect a followup survey to show the respondent’s original survey responses? If the student responds they are going to a particular college in the spring, the follow up survey would ask if they are attending the college they said they were planning on attending.

    Thank you for your help

  19. Cheryl
    January 22, 2016 at 2:02 am

    Two questions:
    1. I am asking for the respondent to enter an email address for a followup survey (will not be the original email the respondent takes the survey with) -- is there a way to ping the new email address during the survey to make sure it is a true address?

    2. Is there a way to connect a followup survey to show the respondent's original survey responses? If the student responds they are going to a particular college in the spring, the follow up survey would ask if they are attending the college they said they were planning on attending.

    Thank you for your help

    • Angela Alcorn
      January 27, 2016 at 4:13 pm

      1. I really don't think there's a way of doing that with things they enter into the form. All it can do is verify it's the right format for an email. But logged-in Google users can have that email address recorded with form results. It might be possible to restrict the form to certain users... I haven't tried.

      2. Forms isn't that smart (sorry!). But there are scripts that can create forms from spreadsheet data, so in theory you could muck about with scripts and create individual forms for each student.

  20. Traci
    January 8, 2016 at 4:29 pm

    I am using Google Forms for the staff at the company that I work for to enter their daily/weekly stats that are used for end of the month reports. I was wondering if there is a way that I can get forms to change to a new sheet at the start of a new month without me having to manually copy and paste the info from the main sheet to a new sheet for each month. Thanks!

  21. Taylor
    December 22, 2015 at 6:07 pm

    I don't know if this is possible or not but what I would like to do is have a form that asks specific information about a sales lead. Based on the date given on the form, be able to give a reminder containing the info submitted every 1, 3, 5 days passed (through google calendars perhaps.)

  22. J. Broekman
    December 16, 2015 at 9:40 pm

    Is there a way to import questions from a word processing document or, better yet, from one of the popular test generator formats into Google Forms? I have thousands of questions (and hundreds of tests) in ExamView format. If my choices are retyping all those questions into Google Forms or printing the tests on paper, I'm going to keep printing the tests on paper...

  23. kkjlk
    November 17, 2015 at 10:01 am

    How can create a google form to know what languages people can read/write/speak

  24. sara.montooth
    October 27, 2015 at 6:32 pm

    Is there a way to "save and finish later" in google forms?
    My form is asking some lengthy questions and need for my students to be able to work on it over several days if needed. How can I do this?

  25. Rachel Ben-Eliezer Tiefenbrunner
    October 8, 2015 at 11:05 am

    I have created a Google form and I would like all responses to reach my email and not go to a spreadsheet. Is this possible ? How do I do this?

    • asa
      November 30, 2015 at 4:26 am

      Use Adds On In goggle forms.

  26. ormanain04
    September 27, 2015 at 11:52 pm

    Hi there,
    I am creating a survey using google form and i want to make sure all questions are answered in a page before moving on to the next page or if there's a way to make sure all questions are answered before the person answering the question can click on the submit button. Can some help me out with this. thanks.

    • Samuel Finlayson
      October 2, 2015 at 5:52 pm

      You probably figured this out already, but all you have to do is check the box next to "Required Question" when you are adding or editing a question.

  27. Liam
    May 23, 2015 at 7:00 pm

    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!

    • Abhijith Thulaseedharan
      June 8, 2015 at 3:40 pm

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

    • Oziel “Ozl” Lozano
      August 10, 2015 at 9:37 pm

      Just Create a Page Break and what ever is under that, it should be the page you need to use as Direction depending on their answer.
      If you want them to finish, just select Submit form.
      Good day!

  28. Scott
    May 21, 2015 at 8:10 pm

    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 it through a hidden field or some other means?

    For example:

    I send a form to "". 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.


  29. shivapriya
    May 12, 2015 at 6:45 pm

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

  30. shivapriya
    May 12, 2015 at 6:45 pm

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

  31. Jennie
    May 5, 2015 at 3:13 am

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

  32. jeberle
    May 3, 2015 at 5:47 pm

    Is there a way to send the person who completes the form, a summary of ONLY their responses? (Without them seeing everybody else's responses?)

    • Cate
      May 19, 2015 at 3:06 am

      If you choose the setting, "Automatically collect respondent's username" then when the user completes the form, they have a checkbox above the Submit button "Send me a copy of my responses"

  33. Jacques Steyn
    April 28, 2015 at 10:08 am

    Hi there,
    Is there a lookup type function? I need to use a process of elimination - e.g. Select the province, then Shopping centres in that province, then Shops in that mall etc.
    I dont want to create 10's of sheets to do this.
    Any help would be greatly appreciated.

    Many thanks in advance.

  34. Tom
    April 23, 2015 at 5:52 pm

    Please help if anyone know. Can I change somehow the paper width in google forms? I made a chart and the part of it doesnt fit in, you must reveal it by scroll bar. Anyone can help me please?

  35. Ramin
    April 12, 2015 at 1:09 pm


    I have had 75 responses to my survey there are fields that have been left completely blank and they contained multiple choice answers and there are questions where i have limited number of answers. How do i fix this ?

  36. jojo bollozos
    April 7, 2015 at 9:04 am

    Help please:

    I create a master file form to monitor number of companies assisted. Is their available script that prompt when encoding the live form that this company already on the list?

    I appreciate it much if someone can give me idea on this one.

    Thanks so much.

  37. Tim
    April 4, 2015 at 3:11 pm

    Is there an easy way of opening up a file (e.g on google drive or could be a url)
    depending on their selection?
    I'd like to give user option to select different audio files and then it would play them

  38. Kathleen Dussault, PE
    April 3, 2015 at 3:49 pm

    Thanks for the tips! I've created a form for field personnel to review handicap ramps for compliance. The form populates the Google sheet with their responses, then I download it to Excel, create a join to my GIS shapefile of ramps in the city and can then query this data thematically.
    I'm also planning to create a Google form for punchlists for construction inspectors to fill out at the project walk-throughs.

  39. Anonymous
    March 25, 2015 at 7:40 am

    Help please!
    I created a survey, then later I added some questions, but the result sheet didn't change with the survey so now I have some answers missing.
    Does anyone know how I can fix that?

    Thank you!

    • R. Garcia
      March 26, 2015 at 9:11 pm

      Once you have "responses" in your sheet you cannot change the Form layout which is how your sheet headers are setup otherwise you will get what happened to you. The "answers" do not know where to go based on the original form+sheet connection. Best thing to do I would think is to change the response destination in your Form to a new sheet to reflect the added Form questions. Hope this helps.

  40. vwentzel
    March 23, 2015 at 8:54 pm

    I have created the self grading quiz using Flubaroo, when i "go to live form" there is an edit button that I do not want students to have access to, how do I get rid of this?

    Everything else works fine, time stamp, name, self grades and sends response to student with grade.


    • R. Garcia
      March 26, 2015 at 9:16 pm

      The Edit button is only there for you to go back and be able to edit your form should you see a mistake that needs to be fixed. Your students will not have access to it.

  41. vwentzel
    March 23, 2015 at 8:43 pm

    I have created the self grading quiz using Flubaroo, when i "go to live form" there is an edit button that I do not want students to have access to, how do I get rid of this?

    Everything else works fine, time stamp, name, self grades and sends response to student with grade.


  42. Jason
    March 23, 2015 at 12:17 am

    On a separate note, does anyone know how if there's a way to disable the back button if you choose to have multiple pages?

  43. Jason
    March 23, 2015 at 12:16 am

    Hi Roz, in form creation mode, at the bottom, there a box you can check labeled "Allow responders to edit responses after submitting". This should do the trick.

  44. Roz
    March 9, 2015 at 1:54 pm

    I am carrying out research for my dissertation and have created a survey using google forms. for one of my questions I have a list of attitude statements and have asked respondents to tick the one statement they most strongly agree with and the one statement they most strongly disagree with. Therefore I have used a 'grid' type question with one column for 'strongly agree' and one column for 'strongly disagree' however my friend ticked one as being her 'strongly agree' answer however she then tried to change it, and it will not let her. Is their anyway I can edit this, so that if you have selected a box, it will then let you remove the original answer.

    I know you can set it, so that the person is only allowed to supply one answer per column - which is what I want. But this does not help for the people that make a mistake and still accidentally tick two. It will result in their response being disgarded but will cause a lot of frustration as they will know they have made an error but wont be able to amend it.

    Any help would be great.

  45. caroline
    March 3, 2015 at 2:09 pm

    Is there a way to create multiple choice answers where more than one choice can be selected?

    • Suzanne
      March 19, 2015 at 5:11 pm

      caroline - choose "checkboxes" then fill in as many options as you like.

  46. Ian
    January 10, 2015 at 3:54 pm

    The one thing stopping me from using Google forms is that there is no way to use dd/mm/yyyy in the date widgets. They cannot be changed from mm/dd/yyyy.

    • Suzanne
      March 19, 2015 at 5:09 pm

      Ian - When I assign a field of type "date", the format on the form is "yyyy-mm-dd" with a drop down calendar. The responses in the spreadsheet can be whatever I use for a format on that column. Are you referring to something else?

    • Michelle
      April 9, 2015 at 3:12 pm

      Hi Suzanne, I'm trying to get the date field to then prepopulate a new form that has a field type of date and I can't seem to determine what format the date needs to be in on the spreadsheet to populate the date in the new form. Have you solved this?

  47. Patricia Adams
    December 23, 2014 at 7:08 am

    This are some amazing tips and tricks for Google Forms, however, I prefer using tools like SoGoSurvey.

  48. Ike
    December 12, 2014 at 12:24 pm

    I've made the field "Name" mandatory only after some had completed the form. I also changed the position of some columns in the response excel sheet. Thereafter, no names appear even though the field is mandatory. Is it possible that the participants did key in their names, but it doesn't show in the response form? How do I retrieve the data then? Thanks alot for your help!!!

  49. Paul
    December 15, 2013 at 12:45 pm

    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?


  50. Rodrigo
    December 10, 2013 at 6:47 pm

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

  51. Angela Alcorn
    September 27, 2013 at 4:02 pm

    I don't think so, sorry.

  52. Daniel
    September 26, 2013 at 10:21 pm

    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.

  53. Samra S
    September 1, 2013 at 9:07 am

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

  54. Dheeraj S
    August 28, 2013 at 3:47 am

    really useful.

  55. Luis Mier
    August 27, 2013 at 4:22 am

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

    August 24, 2013 at 12:54 pm
  57. mike shumake
    August 23, 2013 at 5:17 pm

    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!


    • Emily
      August 29, 2013 at 6:44 pm

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *