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
16 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
68 views

How can I get my set values and formulas to populate to a row of values received from a Google Form?

When I receive submissions from a form I am trying to find a way to include my formulas and set values in the same row as the information submitted by form. My form is only collecting 14 values but my ...
1
vote
1answer
67 views

Google Apps Script with forms to check if a doc url is 'shared'

Does anyone know "IF" it is possible to use Google Apps Script with a Google form to auto check "IF" a document URL pasted into the form is a "shared" document? I'm a teacher and I use Google forms ...
0
votes
0answers
13 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 ...
6
votes
2answers
222 views

How to add fields to a Google Form visible only to specific users

Is it possible to add fields to a Google Form which are visible only to specific users (based on their email ID)? Or allow only users whose email IDs fall in a set to fill the fields?
1
vote
1answer
23 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
117 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
1answer
17 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 - ...
1
vote
1answer
264 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
31 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
16 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 ...
1
vote
1answer
40 views

Email copy of filled-out Google Form including boilerplate

I have constructed a Google Form used to book a community hall, and the form includes some Terms and Conditions that the user is agreeing to. I've displayed the Ts&Cs using the description field ...
1
vote
1answer
172 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
2answers
133 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 ...
3
votes
2answers
437 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
517 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
53 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 ...
7
votes
3answers
384 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 ...
1
vote
1answer
12 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
1k 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
539 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
40 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
553 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
379 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
189 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
28 views

Is there a way to prevent oversubscription using Google Forms

I am in a team of people organising an event. . So in the picture, for the first session, each person only attends one of the strands and not both. I would like to know if there is a way of ...
1
vote
1answer
92 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 ...
1
vote
1answer
46 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. ...
3
votes
2answers
149 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
29 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
30 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
39 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
55 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
77 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
14 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 ...
0
votes
0answers
37 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
10 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
47 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
45 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
25 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 ...
2
votes
1answer
136 views

How to get more than 1 question to populate the same field/column in the Spreadsheet?

I am looking for some way to get the submitted answers to 2 or more questions to populate in the same column in the response spreadsheet, but on the next row. e.g. When gathering data from ...
3
votes
2answers
5k views

How do I embed a Google Form into a WordPress page?

WordPress doesn't support iframe embeds on its free sites, but it does provide a Shortcode option for Google Apps. It seems to automatically convert the iframe code from the older version of Google ...
0
votes
1answer
39 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
1k views

Google Spreadsheets: add unique QR code field to a spreadsheet based on a form in google docs using Script Trigger

At the end of each row filled in, using a custom Google Form, I'm adding three more columns: Date of creation Unique ID QR code (it is a list of computers) Unique ID and QR code are unique. QR ...
3
votes
1answer
29 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
27 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 ...
1
vote
1answer
102 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
2
votes
2answers
3k views

How do I create a multiple choice question in Google Forms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have ...
1
vote
3answers
398 views

Google Spreadsheet changing cell references on its own

I have created a Google Form with an attached spreadsheet. Within that spreadsheet I have created several sheets to sort the answers to my liking. Sheet 2 is just an exact copy of all the original ...
4
votes
1answer
162 views

How to have multiple users complete a single form in Google Forms

Using Google Forms, is there a way to have a user complete a section of a form, share the form and have another user complete another section of the same form, thereby keeping the combined inputs as a ...