Google Forms is an integral part of Google Spreadsheet. Its primary use is to collect user responses.
8
votes
5answers
5k views
How to remove answers from a Google form?
I wanted to tabulate our lunch break hearts scores on a Google form, so I sent it to the guys I play with and one of them entered his name as winning 20 times and I want to get rid of that. I removed ...
8
votes
3answers
10k 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 ...
6
votes
3answers
3k 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
1answer
2k views
Limiting the amount of Google doc's forms that can be submitted
I'm arranging an event where im 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 ...
5
votes
2answers
1k 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".
...
5
votes
2answers
1k 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
237 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 ...
4
votes
3answers
8k 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
1answer
105 views
Save data from Google Spreadsheet history
I used a Google form and inadvertently deleted a few rows.
I need to use the rows again. I see them with history but I can't save them and I can't print them.
How can I restore the data?
4
votes
1answer
243 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 ...
4
votes
2answers
960 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 ...
3
votes
2answers
1k views
How can I get Google Docs to stop formatting a form response as a date?
I have a Google form 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 Docs renders the response ...
3
votes
1answer
2k views
Google Documents - How to add a question which have multiple choice with single selection?
I am creating a Google Doc Form for company's internal survey.
Currently there are 7 question types
Text
Paragraph text
Multiple choice
Checkboxes
Choose from a list
Scale
Grid
I am looking to ...
3
votes
1answer
150 views
How can we view the whole spreadsheet instead of just the form in Google forms?
I have been given a link to a Google docs form where I was supposed to enter some data. The URI looks something like this:
https://docs.google.com/spreadsheet/formResponse?formkey=foo
Is there ...
3
votes
1answer
40 views
How to report which checkboxes were left unchecked on a Google Forms submission?
I have a Google form that stores its responses in a Google spreadsheet. It's set up so that whenever someone submits the form, I receive an email report of the responses. There are many places in the ...
3
votes
1answer
3k 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?
3
votes
1answer
170 views
Single mandatory question with multiple “I accept condition X” (checkboxes?) in a Google Docs Form?
I have a form with several fields (name, a URL, etc.) that's part of an approval request process. I'd like to have a question with several checkboxes which all must be checked before a form can be ...
3
votes
1answer
1k views
Figuring out who is the owner of a Google Spreadsheets form
I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
2
votes
6answers
7k 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
1answer
1k views
Pass Data to Form to Store in Google Spreadsheet
I am collecting addresses in a Google Spreadsheet using a web form. But I am collecting those addresses for multiple purposes. I would like to store an "identifier" in the spreadsheet which I can pass ...
2
votes
1answer
224 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 ...
2
votes
1answer
1k 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?
2
votes
1answer
3k views
How to insert an image into Google Forms?
Last time I tried, you can't put an image into a Google form. Example, if you want people to vote on pictures, you can't do this. People use hacks to put in their own image. Am I missing something ...
2
votes
0answers
372 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 ...
2
votes
2answers
189 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 ...
2
votes
1answer
747 views
How do I embed a Google Form into a WordPress page?
WordPress doesn't support iframe embeds on it's 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 ...
2
votes
1answer
187 views
Calculate monthly sum() on pivote table
I have a Google Form. Upon submit following fields are populated:
Timestamp
Product Description
Unit Price
Quanitity
I have generated a pivot table from this data, in a Google Spreadsheet. The ...
2
votes
1answer
439 views
Google Apps Script - Want to email specific spreadsheet row data on event
Scenario
Basic support ticket clone:
Users submit a form (e.g. answering fault reporting questions)
Data is obviously stored as rows in the corresponding spreadsheet
I've added an onEvent trigger ...
2
votes
0answers
817 views
How to limit each user to fill a form just once?
Is there any quick way to ensure that each user filled the form just once?
I've already seen this question: Limiting the amount of Google doc's forms that can be submitted . But it doesn't answer my ...
1
vote
2answers
4k views
1
vote
1answer
844 views
Collecting identifying information about users filling in a Google Docs forms
How can I get Google Docs to register IDs of people taking a survey generated from by the form? I have a database of users and I'd like them to take a survey and also have the form link with their id ...
1
vote
1answer
118 views
How to see individual answeres in Google Forms
I have made an survey with Google Forms. My problem is that I can't see the individual answers. Is that possible or can I only see the overview?
1
vote
1answer
192 views
Make new responses appear as a row at the top of a Google Spreadsheet
I made a web form based off of a Google spreadsheet. New responses currently manifest as new rows on the bottom of the spreadsheet. There is a "Timestamp" column marking the time of submission.
How ...
1
vote
1answer
511 views
How do you add a date created to Google Forms / Google Spreadsheets
We have a Google Spreadsheet
It has a few columns
Issue
Raised By
Date Raised
We've turned this into a Google Forms which we want anyone in the business to be able to answer.
The problem is ...
1
vote
1answer
175 views
How to setup form for multiple answers for one question
I want my google docs form to allow up to three days to be chosen by our users for lab reservations. I've tried allowing them to enter text, but they make errors. I have tried putting 1-31 as list ...
1
vote
1answer
2k 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
0answers
48 views
Google Spreadsheet: the script enabling email sending to a cc list doesn't always work
We have a Google Forms that, when filled, is sending out a list of people put on cc. This doesn't always work.
How can this issue be solved?
1
vote
0answers
101 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 ...
1
vote
0answers
67 views
How to share with others a poll results as a chart?
I've created a form on google drive, the form is public, anyone can see it and respond to it. I would like to also provide a link to the data gathered by the form, however I would like to provide the ...
1
vote
3answers
346 views
Online forms with spreadsheet functionality?
I had hoped to get this from Google forms but, after a quick run through the online docs, it doesn't look nearly sophisticated enough.
Problem: I need an online form where the questions asked are a ...
1
vote
0answers
48 views
Filtering Form Feedback using Google Docs
Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
1
vote
0answers
244 views
How to display calendar for a question in Google Form that asks for date input?
Is it possible for a form that was created in Google Docs to display calendar of a current month so a user can answer a question that asks about a date?
1
vote
0answers
214 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
559 views
Reseting responses in a GoogleDocs Form
I want to reuse a GoogleDocs Form, with (almost) the same Form, but with fresh Responses.
I did copy it, but I don't know how to reset responses (not reseting the form itself, i.e. Form/Delete Form).
...
0
votes
1answer
166 views
Google Spreadsheet: Adding formulas to Google Forms
I have a sheet with form data in several columns, say A:G. Some of the data are numerical and I'd like to have some calculations done on them, e.g. in columns H through J. I have already found out any ...
0
votes
1answer
356 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
11 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 ...
0
votes
0answers
51 views
What is the better way to collect ordinal data for top three activities from a list
What might be the preferred way to post a list of 24 activities and then ask visitors to choose their 1st, 2nd & 3rd favorites? They were to provide a response: Why are you choosing this? What is ...
0
votes
0answers
13 views
How to automatically create an online survey with hundreds of questions? [duplicate]
Possible Duplicate:
Creating an online form - by Importing the questions from a spreadsheet?
I have a spreadsheet in which more than 100 things are listed. I want to send a survey to ...
0
votes
0answers
260 views
Submit confirmation by e-mail on Google Docs form
I'll create a Google Docs form to get some votes from certain group of people and I would like to avoid votes from people that aren't on that group.
I would publish my form only for Google users, but ...
