Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [google-forms]

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.

Filter by
Sorted by
Tagged with
30
votes
6answers
126k views

How can someone answer my survey form or Google form without creating their own Google account?

How can someone answer my survey form or Google form without creating their own Google account? They told me that they can't open my form because they didn't have an account.
23
votes
4answers
48k 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 ...
20
votes
6answers
62k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
15
votes
5answers
39k 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 ...
14
votes
2answers
6k views

Internationalization of a Google Form

I have written a Google Form for my French-language website, with French-written fields. Problem: All the generic text is still in English, for instance "Required" or "Go back to the form". Question:...
10
votes
3answers
10k views

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms with a question that contains a drop-down box with the following values: - Fewer than 10 - 11-25 - 26-50 - More than 50 If the user selects 11-25, Google Sheets renders the ...
10
votes
5answers
70k views

Adding hyperlinks in a Google Form

How can I add hyperlinks in Google Form?
10
votes
1answer
27k views

Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script

I'm trying to make the edit URL for a Google Form automatically populate in the response Google Sheet that it's attached to. I've seen this already and want to use it, but I'm having issues trying to ...
10
votes
3answers
111k views

How to add attachment option in Google Form?

I need to make a Google Doc Form, in which the users need to upload a Word file. Is it possible to do so using Google Docs form? If yes, then how?
10
votes
7answers
19k 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)?

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 that as new options were added to the list in the spreadsheet (or ...
9
votes
1answer
57k 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 ...
9
votes
5answers
42k views

How to save users' responses in Google Form survey as they continue from page to page?

I have a long form for users to answer survey questions with about 20 pages. It's long enough that users may want to stop and finish the survey later, or they may abandon the survey altogether half ...
9
votes
2answers
2k 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?
8
votes
1answer
69k views

How to make subquestions in Google Forms?

I want to make form with different length dependent on some previous responses. For example: Q1: Do you like cats? Yes/No Q2 (Q1=Yes): Which kind of cat do you like most? Q2 (Q1=No): Why do you ...
8
votes
6answers
4k 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 ...
8
votes
2answers
513 views

Creating a troubleshooting tree in Google Forms, but it can't embed images or links

I tried creating a troubleshooting tree in Google Forms but appear to be unable to embed either pictures or links. I wanted to create a tree wherein users get directed to different nodes with ...
7
votes
1answer
26k 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 ...
7
votes
4answers
16k 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
1answer
812 views

Google Forms erroneous deletes rows in second sheet

I created a form in Google Docs with quite some questions. For a good overview I created a second sheet to pick the important parts from the survey. There I'm also able to add extra columns to add ...
7
votes
3answers
69k views

Create input field in Google Docs form allowing only images

I need to make a Google Doc form, in which the users need to upload an image. Is it possible to do so using Google Docs form? If yes, then how?
7
votes
1answer
24k views

Apply custom CSS styles to Google Forms

Google forms are presented for the user to embed in his/her website as an iframe, which means they can't be styled by the website's own CSS. How can a Google Form be inserted into a website with a ...
7
votes
3answers
5k views

Google docs forms confirmation email when someone signs up?

When you are using google docs forms so people can sign up to an event. Is it possible to make the form send out a confirmation email when someone registers?
6
votes
7answers
65k views

How to print a Google form?

I made a neat questionnaire Form in Google Docs. I want to print it for hand outs to my testers IRL. But I cannot find a way to print it to paper, or even export it to PDF. There are not many buttons ...
6
votes
1answer
4k views

How to create a question in Google Forms that allows two distinct answers?

I have a question like this (it's a DISC test, if this matters): 1. From the following list, which option is 100% you and which option is 0% you? a. tall b. fat c. happy d. unemployed How can I make ...
6
votes
1answer
7k views

How to add a multiple choice question requiring a single selection?

I am creating a Google Form for company's internal survey. Currently there are seven question types: Text Paragraph text Multiple choice Checkboxes Choose from a list Scale Grid I am looking to ...
6
votes
3answers
20k views

Is it possible to automatically add question numbers to Google Forms?

I'm new to using Google Forms and have added all my questions. Is it possible to automatically add question numbers or do I need to go back and manually write them at the beginning of each question?
6
votes
2answers
5k views

Limiting the amount of Google doc's forms that can be submitted

I'm arranging an event and I'm using Google Forms so people can sign up. I can only have 100 people and want the sheet to stop accepting new signups to the form when the number is 100. Is this ...
6
votes
4answers
9k views

Creating an online form - by Importing the questions from a spreadsheet? [closed]

I've got a spreadsheet where each row of the first column is a question, and the next 4 columns are the optional 4 answers to that question. I want to turn these questions into an online form (like ...
5
votes
7answers
18k views

Importing data into a Google Forms response sheet

I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
5
votes
2answers
30k views

Can Google Forms send emails automatically?

I used Google Forms to create a form for people to register for an event, by entering their name and email address. I would like to set it up so that when a person enters his name and email, the ...
5
votes
2answers
9k views

How can I create an e-mail field on a Google Form?

When making a Google Form, how can I mark the field as "e-mail" so that it is validated as an e-mail before the user can submit the form?
5
votes
2answers
4k views

Can I get an RSS feed of changes to a Google Doc?

If I would like to track edits to a Google Doc or inputs to a Google Form by receiving an RSS feed thereof, how do I go about doing so?
5
votes
1answer
2k views

Auto-sort column Google Spreadsheet on incoming Google Form response

How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)? I know how to do this manually or by going in and editing a cell, but cannot get ...
5
votes
1answer
43k 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?
5
votes
1answer
1k views

Limitation of participants Google Docs

I would like to create a registration form for a series of lectures participants could sign up for. However, depending on the lecture, there is a different limitation of numbers of participants that ...
5
votes
1answer
2k views

How to enable duplicating questions in Google form by the user who is filling it

I have a Google form with two parts. The first part is personal details (name, phone etc.). The second part is other information from the users. For my real needs, each part contains several ...
5
votes
2answers
450 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. Is there a way of preventing oversubscription, ...
5
votes
0answers
407 views

How to send an email with a link to an auto-populated form in MailChimp?

MailChimp always appends the "update subscription preferences" link at the bottom of an email, which links to a page that is auto-populated with the subscriber's name and email. Is there a way in ...
4
votes
3answers
8k views

Is there a way to password protect Google Forms?

I would like to create a check request form but I only want users who either enter a password or whose Google accounts I give permission, to be able to fill out the form. Is this possible? One idea ...
4
votes
3answers
12k 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 ...
4
votes
3answers
4k 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 ...
4
votes
2answers
3k views

How do I automatically expand a =QUERY when receiving submissions from Google Forms?

The Query below 'works' on a line by line basis (when manually filled down), but it does not 'autofill' down when new data is added to the responses sheet. The data being added to the responses sheet ...
4
votes
2answers
1k views

How to update VLOOKUP results in Google Sheets to most recent input from Google form?

I am trying to create a formula that pulls responses from a Google Form and organizes them into rows correlating with a client's name. The name is entered manually in and also appears in a drop-down ...
4
votes
4answers
19k views

Email Google Form daily?

Is it possible to email out a Form created with Google daily? I would like to do this simply to email myself a form for use in personal data aggregation. One specific use I'd like to do this for: I ...
4
votes
1answer
6k views

Auto-create and name new sheet in Google sheets from names being filled from a Google form

How can I automatically create and name new sheets in a Google Spreadsheet from a list of names which are being input in the sheet from a Google Form? I would like each new sheet to be created when a ...
4
votes
3answers
3k views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
4
votes
1answer
4k views

What is the maximum of fields a Google form can contain?

I read on Google Docs, Sheets, and Slides size limits that spreadsheets have a maximum of columns per sheet. Shall I conclude that the maximum of fields a Google Form can contain is 255 (since one ...
4
votes
1answer
12k views

How to undo/ go back to a previous version in a Google Form

I deleted a certain section on my Google Form which has resulted in the deletion of the entire form. Does any one know if there is a way to fix this? Undo button is not working nor is the back button. ...
4
votes
1answer
1k views

Check Google Form entry for duplicate answers

I want to make a new form where I ask people about their "top 15" within a list of elements. I have searched a lot, but I couldn't find anything. I decided to just make 15 questions, "what's your 1st?"...
4
votes
1answer
742 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 ...