10 Advanced Google Forms Tips and Tricks
Whatsapp Pinterest
Advertisement

If Google Forms is not yet your go-to form maker, it’s time for us to change your mind. There are a lot of powerful tools hidden away in places you may not find unless you know what you’re looking for. We’re here to make sure you know some advanced Google Forms tips and tricks.

Unlock the "Essential Google Drive Keyboard Shortcuts" cheat sheet now!

This will sign you up to our newsletter

Enter your Email

1. 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 them within the form. However, you may not know which one to choose or why.

You can choose your results destination by clicking the More (three-dot icon) button and picking Select Response Destination. Then either create a new spreadsheet or add the responses as another tab to an existing spreadsheet.

Select Response Destination Google Forms

If you want to quickly send your responses to a spreadsheet, you can also click the green Create Spreadsheet button. Or to download right to your computer, Select More > Download responses (.csv).

If you decide to create a new spreadsheet, it will reside in Google Sheets with the name you assign or the default which is the form name. If you choose to add to an existing spreadsheet, you’ll pick the one you want in the pop-up window for Google Sheets.

Using a spreadsheet to store results is ideal if you want to manipulate the data. 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 Sheets spreadsheet.

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

2. Receive Notification for Submissions

If you would like to receive email notifications when someone submits your form, you can set this up in just two clicks.

Click the More (three-dot icon) button on the Responses tab and pick Get email notifications for new responses. The email address you will receive responses to is the address for the account you use to log into Google Forms.

Get Notifications for Responses Google Forms

3. Insert Google Forms Multiple Pages

In order to spruce up your form and make it seem more manageable to respondents, it’s possible to add multiple pages by inserting sections.

Go to the last block on your page and click the Add Section button from the toolbar. You can assign a header and description to each page, which allows you to clearly separate questions of a certain kind or for a specific type of respondent.

Add Section for Multiple Pages Google Forms

4. Embed an iFrame of Your Form

If you want to use Google Forms to create a contact form for your website How to Create a Free Website Contact Form With Google Forms How to Create a Free Website Contact Form With Google Forms Need a contact form for your website or blog, but don't like the default options? Use Google Forms and collect responses in Google Sheets! Read More or for some other purpose where it’s useful to embed the form as an iFrame, it’s easy to do so.

Click Send on the top right of the form page. Then, click the Embed icon, adjust the width and height of your iFrame if you like, and click Copy. You can then paste the code where you need it.

Get Embed Code Google Forms

5. Create an Auto-Grading Quiz

For teachers, an auto-grading quiz in Google Forms is a really easy way to save some time. On your main Google Forms page, click Template gallery at the top. Scroll down and under Education, pick Blank Quiz.

Click Add Question from the toolbar, enter the question, and click Answer Key to provide the correct answer and point value for the question. When your respondents finish the quiz, they will see an option to View Score. This shows them all questions answered, marked as correct or incorrect, and the points they received.

Auto-Grading Quiz Results Google Forms

6. Turn a Form Into a Quiz

If you create a form that you want to use later as an auto-grading quiz, this is simple. On the form page, click the Settings (gear icon) button on the top right. Select the Quizzes tab and turn on the toggle for Make this a quiz and click Save.

Make Form Into A Quiz Google Forms

You can then go to the form and insert the answer keys and point values just like if you created the quiz from the start.

7. Obtain a Pre-Filled Link

You might want to pre-fill some answers on a form for your respondents. For example, you could use this to jumpstart a contact form on your website. Click More on the top right of the form page (next to Send) and then select Get pre-filled link. Next, just fill the form out as you would like the respondents to do for any given question and click Get Link.

You’ll then see on the bottom left that your link is ready, just click Copy Link and then paste it where you want to share it.

Get Link Auto-Filled Form Google Forms

8. Adjust Defaults for Emails, Required Questions, and Point Values

If you plan to create forms down the road and always want to collect email addresses, you can mark a setting to make this a default. In addition, if you intend to make all questions required or use the same point value for quiz questions, you can set these defaults as well.

Click More on the top right of the form page (next to Send) and then select Preferences. Now in the pop-up window, mark the checkboxes for any or all of these options. This is a great time-saver if you plan to use the same settings on forms moving forward.

Change Default Settings Google Forms

9. Add 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 choose a certain age range as an answer, you could have age-appropriate questions afterward.

You can use this for any question where the user can give one answer from a choice of set answers. Click the More (three-dot icon) button for the question and pick Go to section based on answer.

Then select where you want to direct your respondent from the dropdown box. You can also have them submit the form instead of sending them to a new section.

Logic Branching Google Forms

10. Use Scripting

There are no scripts for the forms per se, but there are ways to use scripting if you like. Select the Settings (gear icon) button on the top right of the form page and choose Script editor. You’ll start with a clean slate in a new tab where you can enter your script. Just click File > Save when you finish.

Open Script Editor Google Forms

For some Google Forms script examples and help, head over to the Google Apps Script page for developers.

Looking for More Google Forms Help?

These Google Forms tips and tricks are just the tip of the iceberg. We’ve also covered how to use Google Forms for your business How to Use Google Forms for Your Business How to Use Google Forms for Your Business A form is an easy way to automate a repetitive task. Here we show you how you can use Google Forms for common work or business routines. Read More and we have a guide that might just be the best guide to Google Forms you’ll find The Best Guide to Google Forms You’ll Ever Find The Best Guide to Google Forms You’ll Ever Find Google Forms is one of the best free web tools available to gather data. This Google Forms guide will give you everything you need to master essential form-building skills. Read More .

Explore more about: Google Drive, Google Forms, Surveys.

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

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

  1. sachin
    October 14, 2019 at 8:54 am

    Dear Team,
    On form Submit, the response to be sent to particular email ID based on google form response.
    e.g.
    - There is a database of cluster names & their owners.
    - The google form takes input of cluster names.
    - We need the form to be automatically forwarded to the particular cluster owner.

  2. MikeD
    March 7, 2019 at 10:14 am

    Alone the fact that Google after all these years does still not understand that the world uses more than 1 date format and consistently refuses support thereof, allthough they frustrate thousands of potential users, is a major reasopn NOT to use Forms. The user has the saying, not Google

  3. Seth Vanderheiden
    February 4, 2018 at 3:13 am

    Google forms changed a lot over the years. Are you planning on writing a new tutorial maybe?

  4. asdfg
    November 22, 2017 at 10:42 pm

    Too old post. The Google forms is not like this anymore

  5. Tasneem
    August 27, 2017 at 2:09 am

    I have a form, where teachers add their classwork for each class they take, which is once a week. Is there a way, in the seperate class worksheets, to import only the newest response for that class?

  6. Christina
    August 3, 2017 at 11:23 pm

    Any idea how to insert emojis on a multiple choice grid? I have questions for a likert scale but I do not want to use the linear scale option. For example, instead of saying agree and disagree I would use a thumbs up picture and a thumbs down picture. Any help would be greatly appreciated!

    • Tasneem
      August 27, 2017 at 2:07 am

      It may be possible with a google forms addon - Zapier.

  7. Janine
    November 1, 2016 at 4:37 pm

    I have a survey with a huge number of options for two of my multiple choice questions. Is there any way to format the survey form so that the font is smaller and/or there is less vertical space between each option, so as to eliminate the need for participants to scroll excessively to find the options they are looking for?

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

    • Matt
      January 11, 2017 at 12:15 am

      Hi Nicola,

      The easiest way to do this will be to have different pages within the form for your first question (the qualifying question), and the rest of the survey. Once this is set up you can then direct the survey where to go based on the answer to your first question.

  9. JOJI S PRAMOD
    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.

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

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

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

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

  14. 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
      eg.
      Select the adjective from the following sentence;" The Taj Mahal is the world’s grandest monument."

      Answer:

      The
      Taj Mahal
      is
      world's
      grandest
      monument

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

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

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

    Hello!

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

    • Angel Van Horn
      July 18, 2018 at 1:07 am

      chrome extensions - eliminator

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

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

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

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

    • Marc Moody
      November 30, 2016 at 4:20 am

      Me too. I'm using logic branching and I don't want them to back and change answers.

      • rach
        May 9, 2017 at 1:18 pm

        You can select only allow one response in the settings

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

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

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

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

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

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

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

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

    • Tasneem
      August 27, 2017 at 1:36 am

      You can add new sheets for each month, and use Query(ImportRange) function to import the newest data, based on the dates, to that sheet. No need to manually copy and paste.

    • Tasneem
      August 27, 2017 at 1:38 am

      Hello
      You can use query, and importrange functions to import the latest or newest rows into the monthly sheets.

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

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

    • Angela Randall
      December 18, 2015 at 1:44 pm

      If you copy/paste that data into a Google sheet it looks like there are a couple of Forms add-ons that could do it. [Broken Link Removed]

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

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

  31. Anonymous
    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?

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

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

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

  34. 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!
    Liam

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

    • Anonymous
      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!

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

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

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

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

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

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

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

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

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

    Hi,

    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 ?

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

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

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

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

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

    thanks!!

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

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

    thanks!!

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

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

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

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

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

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

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

    Hi!
    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!!!

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

    thanks!

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

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

    I don't think so, sorry.

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

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

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

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

    really useful.

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

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

  63. gaguillen.com
    August 24, 2013 at 12:54 pm
  64. 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!

    shu

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