Google Forms is an integral part of the Google editors' suite. Its use is to collect responses. It can work with or without Google Sheets.

learn more… | top users | synonyms

2
votes
1answer
128 views

Google Form with an alert

I created a registration form with Google Forms. Now I would like to have an alert displayed before the submitter starts filling out data. This is my code: function onOpen() { FormApp.getUi() ...
2
votes
1answer
49 views

Using a script to process form input every time a form is submitted

I'm trying to have it that every time I submit a form, it adds automatically some data. This is the script I have: function onFormSubmit(Test) { var sheet = SpreadsheetApp.getActiveSheet(); ...
7
votes
1answer
28k views

Set up specific questions to appear only after particular answers on Google Forms

I am currently creating a survey using Google Forms. It's quite a long survey, so I would like to make it as quick as possible for everybody doing it. A lot of the survey questions are repeated and ...
1
vote
1answer
91 views

Google Sheet not being populated and responses summary not getting incremented after Google Form submission

My wife has a paint & wine party business and I've been using an embedded Google Form for registration on her site for nearly a year without issue. Last week I updated the photos in the ...
2
votes
1answer
177 views

Customize the “other” box of a Google form

I have a Google form and I want the "Other box" of a multiple-choice question to say something other than “Other”. For example: Other programs:[ ] How to do it, if this is ...
1
vote
2answers
106 views

Sorting Pre-Sorted Google Form Data by Timestamp

I have Google Form checkbox data that I am separating out into another table so that each checkbox selection generates its own line. I received some help in pulling the data over, and the resulting ...
0
votes
0answers
79 views

How to make special subquestions in Google Forms?

I want to make form with different length dependent on some previous responses. I can do this with page break, but I would like to do something like this https://support.google.com/docs/contact/...
2
votes
2answers
1k views

How to edit a particular sheet using Google Forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form. I wanted users to select a category and ...
2
votes
1answer
395 views

Make some responses in Google Forms private

I am creating a Google form as a questionnaire and would like to allow people to see some parts of the responses but not others. I am not a programmer, so not really into using scripts to sort them ...
1
vote
1answer
217 views

Email respondents a copy of their completed Google Form

I am the new coordinator of a high school theatre awards program. I have created an evaluation form for the judges to fill out after they have seen their show. They would like to have a copy of their ...
1
vote
1answer
97 views

“sort” function results in all of my data going to the bottom of the sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. I would like to be able to have any staff member add jobs that need to be taken,...
3
votes
1answer
65 views

How to get information from Google Sheets to send it via form emailer?

I created a Google Form. There is a field called email. With this I can receive emails from the submitter. I want to send them a confirmation email taking some information from the sheet. How can I do ...
2
votes
1answer
75 views

Rearranging Google form data in a new sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. The thought, being any of the staff could add jobs that need to be taken, by ...
1
vote
1answer
22 views

Appending the content of one cell to another cell

I'd like to automatically create the content of a cell, based on the value of another cell. For instance: Cell content: 1337 Cell content 2, automatically created: http://www.superuser.com/1337 ...
0
votes
1answer
180 views

Simple sum of checkboxes

I created a form in Google Forms with three checkboxes for each question. Each group of checkboxes starts with the same repeating words (as in: Vata - xxxx, Pitta - xxxx, Kapha - xxxx). I want the ...
0
votes
0answers
73 views

Finding old Google Forms edit links

How do I find old Google Forms edit links for which I don't have the direct URL any more? I have submitted a few forms recently where I didn't bother to take note of the edit URL. Now I want to check ...
1
vote
0answers
36 views

Google Form doesn't show all answers in Summary

I've created a Google Form and got 26 answers. When I go to "Summary" it only showed 22 answers. I tried to refresh the browser cache but it didn't fix the problem. Trying with another internet ...
2
votes
1answer
607 views

Simplifying Google Form Checkbox Responses into Itemized List

This is more of a Google Sheets question than a Forms question. I want to receive form responses from checkbox questions (which unfortunately cannot be separated into separate rows) and flip the data ...
1
vote
1answer
65 views

Creating Google Form with many list options

I am creating a dropdown list in Google Forms, and have approximately 300 options that my users can choose from. Is there an efficient way to add the options to the Google Form as opposed to manually ...
1
vote
2answers
27 views

Google Forms submits times that are not numerically consistent with those in a spreadsheet

When I submit a Google Form, and I fill in a time the number that is entered into the spreadsheet is not the same number the spreadsheet will use for that time. ie. If I enter 3:30 PM in a form and ...
-1
votes
1answer
17 views

Google Survey Help

How do I share a google forms (survey) in a computer lab for several students to rotate through to complete without getting the error message that one has already completed the survey?
3
votes
1answer
439 views

Is it possible to link a Google Form to a desktop Excel sheet so that when someone fills in the form the data goes into the Excel sheet?

I work for a sporting organisation and track all sorts of monitoring variables using Excel spreadsheets. Up until now I have used macros in Excel to do this, but this requires players taking it in ...
1
vote
0answers
251 views

Google Script: setValue function on form submit

I have written the following code function myFunction(e){ var options={cc: 'x@abc.com'}; MailApp.sendEmail(e.values[2], "New SMS Blast request", "A new SMS blast request has been entered, the ...
2
votes
1answer
44 views

Limiting access to a Google Form

I am using Google Forms for yearbook quotes and need to only allow the seniors to use the form/ The form is posted on our web page however all of the grade levels have Google accounts. Can I put ...
0
votes
0answers
113 views

Specific questions based on answers of multiple questions on Google Forms

In Google Forms, how can we display a question to the user based on what he/she selected for two other questions? I know how it can be done based on the answer to one question, by making use of Go to ...
3
votes
1answer
6k views

How to view history of filled in Google forms?

I have filled in many Google forms for an interview in last month so I want to view details of what I have entered in those Google forms. How can I get the history of all my filled in Google forms?
14
votes
5answers
28k views

When sharing a Google form, how can recipients see the form and not the spreadsheet?

I'm using Google Docs to build a survey as a form for various recipients to take. The form itself is built and, as a form, functions magnificently. (Seriously, it's a work of art. I'm really good at ...
5
votes
7answers
13k views

Is there a way to link a “Choose from a list” style question in a Google Form to a list of data (e.g. in a spreadsheet)?

Would really appreciate some help from any experts in Google Forms. Is there a way to link a "Choose from a list" style question in a form to a list of data (e.g. in a spreadsheet)? This would mean ...
2
votes
1answer
62 views

An answer in column B on Google Sheets generated from a Google form sends email to collaborators including all data in that row

I'm a school teacher using Google Forms and would like to generate an email to myself, and if possible other collaborators, based on an text answer of "YES" in column B from the sheet generated by ...
1
vote
1answer
176 views

Report/process only using the last entry made by the user in a Google form

I have a form where students can enter choices: for instance the specialisation they want to pursue, and the semester when they will start that specialisation. An example entry form is here, but it ...
1
vote
1answer
426 views

How to share with others a poll results as a chart?

I've created a form on google drive, the form is public, anyone can see it and respond to it. I would like to also provide a link to the data gathered by the form, however I would like to provide the ...
3
votes
1answer
98 views

What can break the relationship between the onFormSubmit function and a spreadsheet that is attached to a google form?

I had a working Google form, Google spreadsheet, and GAS script which would be called when the form was submitted. It worked fine until the did (one?) of the following things: Cleared out the ...
2
votes
0answers
245 views

How can I insert a text item (question) with multiple response fields (and descriptions) in Google Forms?

I'm trying to create a survey/Google Form specifically to export data into an Excel sheet. This isn't very important because I can tweak the arrangement after the fact, but naturally I have a lot of ...
3
votes
2answers
603 views

Google form to spreadsheet, create new column

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C ...
1
vote
3answers
3k views

How to see names for survey responses?

How can I show the name or email address for responses to form survey in the results spreadsheet? We want to see each other's responses but results sheets seem to be anonymous and only show time ...
2
votes
1answer
2k views

How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?

I have a filter view in Google Sheets that does not refresh when new data comes in via Google Forms. To refresh the filter view, I can remove the filter and apply it again, or even just click "OK" in ...
1
vote
1answer
857 views

There is no “revision history” option in my Google Survey

I am using Chrome and I am the owner of a survey but I do not have the option of revision history when I click on "File". I really need to view an earlier version of my survey. What should I do?
4
votes
3answers
2k views

How can I get Google Sheets to treat my form-submitted strings as plain text and preserve leading zeros?

I have Google Forms where users enter information, some of which contains leading zeros (e.g. zip codes, ID numbers). However, when this data is saved to the Google Sheet, it doesn't treat it as ...
3
votes
3answers
1k views

Google Form removing leading zeros in response spreadsheet [duplicate]

I have a form that I'm using to collect responses on in Google Forms. One of the question includes a response that usually starts with a leading zero (like an account number). When the response is ...
2
votes
1answer
79 views

Asking specific questions for three groups of people

Here's my dilemma. I'm trying to set up a google form for people RSVPing to my cousin's bar mitzvah. There are three events: the service, a dinner, and a party. But not everyone is invited to every ...
1
vote
1answer
757 views

Google Docs Forms: Create Checklist Item with adjacent Textfield

Using Google Docs Forms, I'd like to create a checklist with a "quantity" and "comments" textfield adjacent to each checklist item. Is it possible to do this without writing a custom script?
4
votes
1answer
565 views

Limitation of participants Google docs

I would like to create a registration form for a serie of lectures participants could sign up for. However, depending on the lectures, there is a different limitation of numbers of participants that ...
0
votes
1answer
365 views

Responses missing in Google Forms under the 'Checkbox - Other' question

I have a Google Form with a checkbox question and I can see from the responses summary that two respondents have ticked 'Other'. But, I can't see what they have typed, even in the responses ...
1
vote
1answer
328 views

“other” response not collected in Google Forms [duplicate]

I have created a survey using Google Forms many of which are multiple choice with an "other" option at the end and a small box for users to enter their own response. In the results spreadsheet it ...
3
votes
2answers
459 views

How can I give people view access to a Google Form so they can make a copy of it without editing the original?

My uncle works for a dog breeding company and asked me to create a survey for him with about 20 pages of questions. I finished the form using Google Forms and then he asked me to make a guide for ...
2
votes
1answer
76 views

Google Forms: Multiple Parties Editing a Single Response

I have a google form with 5 page breaks, each navigating to a different section of a customer's profile. I have created the necessary edit.urls, however, when section 2 is edited, it erases the ...
1
vote
1answer
134 views

Make Google Forms in plain text?

I'm looking for a way of creating Google Forms with some sort of plain text syntax and then uploading it to Drive. Are there any addons that might make that possible? If that's not something that ...
2
votes
2answers
567 views

How to change Google Forms date format to MM/YY?

Is there any way to change the Drive Forms date format in the survey question to MM/YY? It currently only seems to allow dd/mm/yy? I'm not interested in the day and it will confuse my respondents.
2
votes
1answer
332 views

How to post responses from Google forms to a specific sheet in a Google spreadsheet

I have a form, a Google form, and I'd like to post user's responses to a specific sheet in the Google spreadsheet. Is this possible?
1
vote
0answers
23 views

Narrow sample space down with Google Forms evaluation

I got the results from a survey I did with Google Forms. The survey results are stored in a Google Spreadsheet (150 rows). I really like the feature to get the results in diagrams automatically, but ...