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
0answers
5 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
9 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
495 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
33 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
58 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
545 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?
1
vote
1answer
63 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 ...
6
votes
2answers
210 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?
0
votes
1answer
100 views

want a simple sum of check boxes

I created a form with three checkboxes for each question. Each group of check-boxes starts with the same repeating words (as in: Vata - xxxx, Pitta - xxxx, Kapha - xxxx). I want the total number for ...
4
votes
1answer
367 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
173 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
27 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
80 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
34 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
121 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 ...
0
votes
0answers
10 views

Edit existing google sheet using google form

I have data in a google spreadsheet that I'd like to modify in forms. I'm working on a large scanning project and have a list of all file names and associated utility types in a google sheet. I'd ...
2
votes
1answer
27 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
24 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
35 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
93 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 ...
1
vote
1answer
33 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 ...
2
votes
1answer
39 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
39 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 ...
2
votes
1answer
427 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
0answers
12 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
1answer
467 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 ...
0
votes
0answers
20 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
32 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
43 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
22 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
127 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
4k 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
30 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
26 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
24 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
101 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
367 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
139 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 ...
1
vote
1answer
176 views

Can I dynamically populate a form field in Google forms?

I would like to pass a parameter into my form which automatically populates one of the fields with that value. How can I do this?
2
votes
2answers
3k views

Setting maximum number of sign-ups in Google Forms

We use Google Forms to manage a large school event in which each activity requires sign-up using a separate form. We have a maximum number of students per activity. How do we “close” the sign up once ...
2
votes
1answer
38 views

Appearance of Forms I never created in Google Drive

I have some Google Sheets file which I copy and change monthly. I never used Forms, but they are appearing all the time in the Drive and are related to this G.Sheets file as you can see on the ...
3
votes
1answer
348 views

How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
4
votes
1answer
13k 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
1k views

Script error trying to populate form drop down menu from spreadsheet

We are trying to link a list on a Google Spreadsheet to a drop down menu on a Google Form. The twist is that this Google Spreadsheet list will be continuously updated and needs to automatically ...
2
votes
1answer
360 views

Adding Multi-choice Questions faster in Google Forms

I need to create a Google form using Google Docs, for surveying purposes. Several of the questions I am incorporating in the form consist of multiple choices, which my colleague has listed down in an ...
2
votes
1answer
38 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 ...