Google Forms is an integral part of Google Spreadsheet. Its primary use is to collect user responses.

learn more… | top users | synonyms

0
votes
1answer
58 views

“other” response not collected in Google Forms

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
339 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 ...
0
votes
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 ...
0
votes
1answer
24 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 ...
0
votes
1answer
710 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?
1
vote
1answer
84 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 ...
1
vote
1answer
799 views

Google Spreadsheet Form Responses in to an already made sheet

I have a template form and matching spreadsheet that need to be copied multiple times. When I make copies of the two, the copies are not linked for the form responses to go to the newly copied ...
4
votes
3answers
32k 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?
2
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 ...
4
votes
5answers
25k views
0
votes
1answer
30 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 ...
0
votes
1answer
10 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 ...
8
votes
1answer
367 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 ...
-1
votes
1answer
13 views

Including Google surveys in email

Pressing 'submit' on google survey Sorry to bother you but I am having problems creating a google survey. I would like to get people to fill in the survey on the email without being re-directed. I've ...
3
votes
1answer
171 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
326 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 ...
3
votes
1answer
614 views

Single Response Spreadsheet (with multiple sheets) from multiple forms

I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response ...
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 ...
0
votes
3answers
216 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 ...
0
votes
0answers
17 views

Send to respondents a number between 1 and 10 using Google Forms?

My idea is to give to respondents by mail a number reference between 1 and 10. The idea works as follows: You have 10 boxes. When a response is submitted, automatically the form will send a email ...
0
votes
1answer
80 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
2k 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 ...
0
votes
1answer
25 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?
14
votes
6answers
24k views

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

I use a Google Form to retrieve feedback from our customers. I then download this info into our offline system. Is it possible in Google Form to give a unique value to each row it inserts into the ...
3
votes
1answer
274 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: ...
0
votes
1answer
71 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 ...
2
votes
5answers
3k views

Importing responses into a Google Docs Form (spreadsheet)

I have some Google Docs Forms and I would like to import legacy survery data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but ...
0
votes
0answers
9 views

Google Forms - Go to list of pages based on checklist

I'm making a survey that parents can fill out with their opinion on the teachers that teach their children. Is there a way to have a list of teachers on the first page, and based on which teachers ...
1
vote
0answers
13 views

Combine checkbox and paragraph in Google Forms

I am trying to create a new survey. The question will be directed to the patients about their current pharmacological therapy. I prepared a checkbox list of medications, but I can't add a textbox ...
4
votes
2answers
739 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 ...
1
vote
0answers
299 views

How to build a decision suport app with Google forms or other Google Apps Script resource?

I want to create an app which helps newbie employers to take some decisions. So, using their answers to a form, the app asks new questions based on previous responses, something similar to a decision ...
3
votes
1answer
73 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 ...
3
votes
1answer
141 views

Created a Google Form; can't find the Spreadsheet

Long ago, I created a survey that I sent out by email. The responses were recorded in a Google Spreadsheet by filling out a Google Form. I would like to use that data again, but I cannot find the ...
1
vote
0answers
11 views

Google Forms: Accepts forms with a specific sum of numeric fields

I am building a voting lottery form for my friends. Each participant should guess the number of seats that every party will gain in the upcoming Israeli elections. Each party is a required field, ...
1
vote
0answers
21 views

Can I make a list option unselectable in Google Forms?

Similar to the HTML <option> attribute disable, I want to make a Google Forms list have some options that are visible but unelectable. Is this possible?
0
votes
1answer
20 views

How do I put the timestamp in the “check in” or “check out” column based on the user's response in the Google form?

I created a Google form that allows users to clock in/out. The form asks two questions, their pin number and whether they want to check in or out. When the user clicks on "check in" and submits, the ...
2
votes
2answers
331 views

Google Form removing leading zeros in response spreadsheet

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 ...
3
votes
2answers
350 views

How to move a question from one page to another in Google Forms?

I have two pages in a Google Form. I have created a question in Page 1, and now I want to cut and paste it out of Page 1 and put it into Page 2. However, using drag and drop doesn't seem to work. Is ...
4
votes
0answers
55 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
0answers
19 views

Restricting date selection

Is there a way to restrict the user of a Google form from selecting today's date? I always want them to be able to select the next day but never the same day.
6
votes
4answers
3k views

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

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 ...
0
votes
1answer
22 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
0answers
522 views

Google Drive Form doesn't display on Google sites if not signed in on chrome

I have a site, hosted by Google Sites that includes a Google Form. Normally, the page loads, then a second or so later the form loads. In the problem case the page loads, but the form doesn't. It ...
1
vote
0answers
34 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 ...
0
votes
1answer
24 views

Transferring a custom add-on to another Google form

I created an add-on for a Google Form: After saving it, I can see it in the add-on list: How can I use this add-on in another Google Form?
0
votes
0answers
11 views

Read-Only Text Won't Display

How do I get the read-only text on my forms to display? It displays in my back office, and on my website, but not in the email notification that's sent out to my client and myself.
2
votes
1answer
69 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 ...
1
vote
0answers
129 views

How to use Google Forms for data entry in a lab, keeping track of which computer input each entry?

I wanted to use Google Forms for the following: People come into the lab, seated at 1 computer desk each. They do not sign in with any personal info. They enter addresses from a phone book (through ...
1
vote
0answers
46 views

Allow multiple votes for the same option in Google Forms

I am trying to make a Google Form where users are allowed (or required) to cast two votes, and they are allowed to vote twice for the same option. Is that possible? I haven't been able to figure it ...
0
votes
0answers
19 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 ...