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
12 views

Google Form keeps changing Spreadsheet cell entry

I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then ...
-1
votes
0answers
4 views

Google form: how to add and add what script to add the total scores of 33 questions to show to the users immediately in the form

How can i add the sum of the 33 questions and give out the total summary scores to the users immediately? what computer script did i need to paste into the Google form to do that?
4
votes
2answers
38 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 ...
0
votes
1answer
30 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
14 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 ...
0
votes
0answers
19 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
36 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?
0
votes
0answers
10 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
17 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 ...
0
votes
1answer
32 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
0answers
12 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
24 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 ...
4
votes
1answer
61 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
20 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.
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 ...
0
votes
1answer
25 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
1answer
975 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?
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
71 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
47 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
20 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
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 ...
3
votes
1answer
76 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
151 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
20 views

Automatically capture browser of respondent in Google forms or Wufoo

Is it possible to capture the browser version of a form respondent in Google Forms or Wufoo? Perhaps this is possible in Google using the built-in script editor?
2
votes
1answer
104 views

Adding a script to Google Forms to identify incorrect phone numbers

I currently use Google Forms as a way for applicants to submit their forms. One of the fields that is required is for their contact information. In my country phone numbers have 11 digits. Is there a ...
0
votes
0answers
76 views

How can I get the response ID of the person opening the form in the onOpen function in Google Forms?

I am using the following code in hopes of getting the responseID for the user who is editing their previous response to a Google Form. The problem is that the ID appears to be related to the ...
0
votes
1answer
444 views

How can I create a timer in a survey in Google Forms?

I need to make a survey form where each page of the survey is timed. Once the timer runs out, the form should automatically advance to the next page. Is this possible using Google Forms?
1
vote
0answers
25 views

How to randomly choose from a list of questions or choose from a list of values in Google Forms

I need to do a transit survey and I've been researching how to do this with no luck. Your help would really be appreciated. I have questions where I give them a choice between 2 trains (A & B) ...
1
vote
1answer
130 views

How to add a text input field along with radio input button in Google Form?

I am creating a Google Doc Form for a company's internal survey. One question is like: 'Do you have a Dental School Program by Another company or organisation, if yes What?' How can I add a text input ...
2
votes
1answer
47 views

How do I add descriptions to Google Forms checklist items?

How can I add a description to each checkbox item in Google Forms?
2
votes
0answers
32 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 ...
1
vote
0answers
132 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 ...
2
votes
2answers
338 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 ...
2
votes
0answers
54 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 ...
1
vote
1answer
87 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 ...
4
votes
2answers
379 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 ...
0
votes
0answers
55 views

Can entries automatically populate different tabs depending on the value entered in Google Forms?

Currently, the values (number of hours) are autopopulating in one tab next to the user's name. How would I create a tab that autopopulates the user's info if he/she enters a number, say, between 20 ...
0
votes
1answer
73 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
2answers
1k views

How can I change the default text on the “Submit” button on a Google Form?

Can somebody please tell me how to change text on the Submit button in Google forms? Please note: I am referring here to the standard Google Forms, the one's that anyone can setup in Google Drive ...
1
vote
0answers
161 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
1
vote
1answer
291 views

How can I sum a row in Google Spreadsheet so that the formula isn't overwritten when Google Forms adds a new row?

I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything ...
0
votes
1answer
60 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 ...
0
votes
3answers
238 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
159 views

Google Forms Plugin - Change the Submit button text

I'm using Google Forms in conjunction with the WordPress Google Forms plugin to add various forms across different pages on my site. The forms are added using to following shortcode from the plugin: ...
4
votes
2answers
754 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 ...
0
votes
1answer
202 views

How do I add a counter value into a cell once a row is added

I work for a small company that monitors all service calls in an old database. I recently moved this database into a Google Spreadsheet and a Google Form. Once a user submits a ticket, I would like ...
0
votes
2answers
130 views

Google Forms - Checkboxes - Edit Option

I've got a google form with a checkboxes question: https://docs.google.com/forms/d/1ngHnWZlyZQ3RirL7X4rHj8_x9gLa_CvVyPiyLkUmQls/viewform I edited an option (to clarify it), and now the number of ...
0
votes
0answers
62 views

How to populate a text box in Google Forms

I would like to make the answer from a choose from a list to populate a text box in a Google Form. Any suggestion on how to accomplish this task?