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
90 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
28 views

When creating a 'Checkboxes' question in Google Spreadsheets, what formula do I use to add a mark to each box ticket correct to the answer?

I am creating a Google Spreadsheet for the first time and I have suddenly become stuck. When filling out my spreadsheet I do not know what formula to use when adding up the correct answers. I have ...
2
votes
1answer
48 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(); ...
1
vote
1answer
38 views

Can I auto-fill an answer on a form edit URL?

I periodically send out emails to our team to check in on from entries that have a specific field set to "No". And after they complete a certain task then need to change that entry to "Yes". The ...
2
votes
1answer
108 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
85 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 ...
2
votes
1answer
62 views

How do I include multiple fields for each answer (two-part answer) choice?

My specific question is how to set up Google forms to allow a two-part answer. For example, which of the following books have you read and how many days did it take you? So you would have many book ...
3
votes
1answer
105 views

Edit multiple form responses inside a Google form

I am looking an editing form responses on Google Forms. So basically, I was thinking to create a simple form for the fields I need and having a drop down on the top to edit form responses ...
1
vote
1answer
371 views

Is there a way to generate edit response url for google form

I have a Google Form With a Google spreadsheet to store responses. In my spread sheet I have 4 column: name, email, revenue, and a fourth column Id which is used to identify the particular recipient. ...
1
vote
1answer
177 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
76 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
56 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
68 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
88 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
58 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
509 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
59 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 ...
3
votes
2answers
311 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
60 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
65 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
79 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
349 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
41 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
98 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
35 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
59 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
674 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
130 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
37 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
88 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
213 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
676 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
586 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
108 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
287 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
376 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
21 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
224 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
29 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
178 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
64 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
143 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
121 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
91 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
145 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
455 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.