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
2k 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 ...
1
vote
0answers
124 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 ...
2
votes
1answer
471 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
1k 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 ...
3
votes
0answers
825 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
1answer
774 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 ...
0
votes
1answer
2k 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). ...
1
vote
0answers
77 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 ...
4
votes
1answer
165 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?
1
vote
0answers
198 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 ...
3
votes
1answer
424 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
8k 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 ...
3
votes
1answer
389 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 ...
4
votes
2answers
3k 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 ...
2
votes
1answer
4k 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 ...
3
votes
1answer
2k 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 ...
7
votes
3answers
4k 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?
1
vote
1answer
2k 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 ...
9
votes
2answers
3k 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
1answer
4k 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 ...