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

learn more… | top users | synonyms

0
votes
0answers
3 views

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?
3
votes
1answer
186 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: ...
1
vote
1answer
62 views

Publish last 5 entries from a Google Form

We currently create and html table to list our last 5 Webinars. This is done manually. We are adding external contractors into the mix and would like to give them the ability to enter basic webinar ...
0
votes
1answer
44 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
0answers
14 views

How to send automatic email with number in Google forms

How to send automatic email to a circular form filled out, in need to add a number that starts from 10000 and each time increases by one, like an invoice?
0
votes
2answers
66 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
1answer
40 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
1answer
135 views

Auto sort of Forms responses

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
1
vote
1answer
320 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
921 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 ...
1
vote
1answer
44 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
336 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
1answer
580 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 ...
2
votes
1answer
20 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 ...
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 ...
1
vote
1answer
769 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 ...
0
votes
0answers
18 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
33 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?
0
votes
1answer
232 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
481 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
1answer
963 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?
1
vote
2answers
754 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?
7
votes
1answer
324 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 ...
2
votes
2answers
2k 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
1answer
67 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. ...
1
vote
0answers
14 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) ...
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 ...
1
vote
1answer
59 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
19 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
29 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
47 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
2answers
261 views

How do you automatically align incoming form responses in Google Sheets?

I like to have each of my form responses aligned in the center of their cells. However when I submit any new information through Google Forms, they are always automatically aligned to the left, and so ...
2
votes
2answers
105 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 ...
-1
votes
1answer
135 views

Google Form to Spreadsheet formula questions (index/match array and 24hr-12hr clock)

I need help with a Google Spreadsheet populated by a Google form. I cannot get the following formula to work correctly with my form submissions: =(ARRAYFORMULA(if(row(H:H)=1,"Language",(INDEX('INDEX ...
2
votes
0answers
21 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 ...
2
votes
0answers
90 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 ...
1
vote
1answer
340 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 ...
3
votes
1answer
4k 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 ...
0
votes
0answers
44 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 ...
10
votes
5answers
20k 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 ...
4
votes
3answers
24k 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?
5
votes
5answers
4k 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)?

Would really appreciate some help from any experts in Google Forms. 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 ...
3
votes
7answers
20k 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 ...
2
votes
5answers
2k 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 ...
2
votes
4answers
1k 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 ...
1
vote
0answers
113 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 ...
2
votes
2answers
422 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
1answer
190 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
0answers
103 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: ...
2
votes
2answers
2k 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?