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

1
vote
1answer
162 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
68 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 ...
3
votes
1answer
55 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
63 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 ...
2
votes
1answer
70 views

Combining data from two columns to one (in separate rows - not comma separated) and removing blank lines

I have a Google Sheet which receives information from a google form. I would like to collate some of this data in a separate sheet (within the same document). I would like the new sheet to combine ...
0
votes
0answers
50 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 ...
2
votes
1answer
460 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 ...
0
votes
0answers
58 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 ...
2
votes
1answer
256 views

How to limit one response per email for Google Forms

I am creating a survey in Google Forms and I'm going to that use inside our organization. I am going to send the form link to everybody inside organization using their internal email. The form will ...
1
vote
1answer
57 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
vote
2answers
60 views

Google Sheet Cell Link to Google Form test score

I have a pre-made Google Sheet which has cells to be marked as "pass" or "fail" depending on the person's score. Is it possible to link a Form response to record a pass or fail mark depending on the ...
1
vote
1answer
75 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 ...
-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
312 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 ...
2
votes
1answer
35 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
94 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 ...
1
vote
0answers
32 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
57 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 ...
3
votes
2answers
577 views

How to delete a single answer in Google poll/survey

I started a survey with Google form. Everything is fine. But one Answer was accidentally given twice. As I understood, there are two locations of the answers. Internal, of the form and a copy of each ...
1
vote
1answer
121 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 ...
0
votes
1answer
35 views

How to save logic branching in lines, not in columns

Is there any way to save new information that comes from logic branching questions into new lines, instead of new columns? I'm trying to have something like this on my Answer Spreadsheet: Provider - ...
3
votes
1answer
87 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
189 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 ...
2
votes
1answer
1k 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
606 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?
1
vote
1answer
517 views

Retrieving user email address from Google Form survey results

I am a Google Apps user. Is there a mechanism or script which allows me to retrieve the respondents email address from a survey? I can see the timestamp but there is no respondents email field. ...
1
vote
1answer
102 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
1answer
259 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?
3
votes
2answers
355 views

How do I record the value of GET parameters passed to a Google form in hidden inputs?

My question is basically the same as this one asked on StackOverflow, too old to migrate, but which seems to be a better fit here. This answer (more authoritatively, here) suggests a way to add a ...
1
vote
0answers
20 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 ...
1
vote
0answers
214 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 ...
0
votes
0answers
28 views

Items move unpredictably when I try to change the order of questions on a Google Form

When I drag and drop a question, other questions move in random order. Just as I get one question where I want it, three others move themselves. How can I prevent that from happening?
0
votes
0answers
165 views

Making specific questions appear only after particular answers on Google Forms via Formfuse

The answer to the question "Set up specific questions to appear only after particular answers on Google Forms", was very clear and helpful. I am using the Formfuse add-on to automate the creation ...
1
vote
1answer
63 views

Google Forms - Survey data storing

I am trying to capture and store data into a spreadsheet using google forms. Everything will be stored in google drive. How do I set up forms/ spreadsheet to input the data captured in the form into ...
1
vote
1answer
132 views

Auto-update a google form?

Is it possible to write code that automatically changes the questions on a Google Form? Would love to be able to automatically sync our signup form with a spreadsheet which lists the chapters around ...
0
votes
1answer
108 views

Google Form : Allow ONLY one response each day

I want to allow each user ONLY one response each day. i.e After login i submit the form, it shouldnt allow me second response today, which is possible easily, but it should be allow 2nd response ...
3
votes
1answer
83 views

Capture Created Date from form that allows for editing

I've looked through the previous posts and can only find information where it looks like the responder assumes that the form is completed in one go, so the TimeStamp column is the obvious answer to ...
4
votes
1answer
132 views

How do I use a time stamp from a Google Form in a Google finance function?

I have students enter a value in a form which determines which currency they want to buy. I want the Google Spreadsheet to look up and record the price when the form is submitted. Since I want to ...
2
votes
2answers
418 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.
1
vote
1answer
39 views

Trouble linking entries from two sheets for automatic update

How do I have text information from one column (Sheet 1, column C) automatically feed into Sheet 2 column A so that, when Sheet one is updated through the Google form it is linked to, the information ...
2
votes
1answer
63 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 ...
2
votes
1answer
68 views

Google Form responses to match OU membership

We have some forms that we send out Domain wide, and require the user to login with their Google credentials. I'd like to collect the responses and display OU membership of the user, so we can ...
1
vote
1answer
187 views

How can I get a unique ID when I submitted an answer in Google Form?

I am using Google Form for my customers to submit their opinion. I read this and this, but I have some questions which these two posts haven't mentioned. Is it possible for my customers to know their ...
1
vote
0answers
88 views

Using a Live Google Form inputs for calculations

Spreadsheet is not recording responses from form I am able to see from responses appear fleetingly before they vanish. They are however indicated in summary I have tried un-linking, re-linking, ...
0
votes
1answer
41 views

Who participated in my poll (Google Forms)

Is there a way to find out who voted on my Google Forms poll, given that I required login when created the poll? Also, on the flip side of the coin, is there a way to authorize only defined users to ...
0
votes
1answer
297 views

Google Form keeps changing Spreadsheet cell entry

I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then ...
11
votes
3answers
4k views

How to create a countries drop-down list question, without entering all countries manually?

I am creating a Google Form, and as the final question I want to ask the participants what country they come from. As it often comes up in polls, I am surprised that this country component is not ...
0
votes
1answer
124 views

Applying formula to lookup value in array of cells in Google Form Responses

I have a Google Form response sheet, part of which contains several columns (say B:G) that will only have a single value between them. The form asks respondents for their county of residence and then ...