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

learn more… | top users | synonyms

2
votes
1answer
95 views

Geocode in Google spreadsheets, keep results

I have a form for internships and I am passing over the address of the internship provider to a function which gives me latitude and longitude for it, which is then consumed by a webmap using tabletop ...
5
votes
1answer
742 views

Auto-sort column Google Spreadsheet on incoming Google Form response

How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)? I know how to do this manually or by going in and editing a cell, but cannot get ...
0
votes
0answers
66 views

Sort Google Form Responses to Different Sheets [duplicate]

I need to take Google form responses and separate them based upon one of the questions. How can I set this up so that this occurs automatically?
0
votes
0answers
172 views

Filtering data based on dropdowns in Google Forms

Is it possible for me to have a choose from a list question in a Google Form and have two dropdown boxes? Such that, the list items in the second dropdown box will depend on the item chosen in the ...
0
votes
0answers
54 views

Google Forms link sharing to Google Community as Google Page owner

I have a Google Plus Page and Google Plus Community connected to the page. If I share a Google Form link as the page owner to the Google Plus Community I got an error, whereas sharing the same link as ...
1
vote
2answers
626 views

Google forms script to delete responses counter

I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated. My copy sheet function, and delete ...
0
votes
2answers
1k views

Is there a way to keep track of the URL used to edit responses in Google Form?

I would like to use Google Forms to keep track of the progress of an application process (similar to what this websites does for immigration applications). One key functionality that I need is to be ...
1
vote
0answers
233 views

How can I get drop down in grid in Google Docs form?

I have been trying to get drop downs inside the grid type questions in Google Forms but I was not able to do it. I want something like the following: We want to survey multiple designs for ...
2
votes
1answer
565 views

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet?

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet? Some of the responses on one will be public and viewable by anyone, but others will be private.
1
vote
3answers
172 views

Access to a Google form once people have used it

I created a form for students to submit their assignments. They copy their URL of the Google document, then paste it in a form. When I get their responses, I can't open their URL, it says I am not ...
1
vote
0answers
54 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 ...
1
vote
0answers
421 views

Google Docs Forms: Create Checklist Item with adjacent Textfield

Using Google Docs Forms, I'd like to create a checklist with a "quantity" and "comments" textfield adjacent to each checklist item. Is it possible to do this without writing a custom script?
4
votes
1answer
392 views

Google Forms Submit and Return to a page within the form

I am trying to get my Google form to return to a page within the form after submitting. This is a payroll form in which there are 5 locations in which each of the managers will choose there location ...
0
votes
1answer
142 views

Google Forms: Auto-update other sheets

Response are automatically added to the sheet "Form Responses". I want to apply certain formulas in a sheet called "Student Answers". However, "Student Answers" doesn't auto-update from the submitted ...
2
votes
4answers
953 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 ...
0
votes
1answer
175 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 ...
2
votes
0answers
98 views

How to see who has already received a Google Form

I need to send a Google form again but do not want to send it to people who have already received it. Is there a way to see who I have already sent the survey to (including those who have not ...
1
vote
1answer
693 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
214 views

Is there a way to speed up the auto-increment routine in Google Spreadsheets?

The solutions that have been provided for this question does the job, but when more people submit data at the same time, things go wrong. The same number is used in multiple rows. Is there a way to ...
1
vote
0answers
125 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?
1
vote
1answer
471 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 ...
3
votes
1answer
261 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 ...
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 ...
3
votes
0answers
390 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
119 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 ...
3
votes
0answers
805 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 ...
3
votes
1answer
3k 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 ...
5
votes
5answers
3k 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
2answers
3k 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 ...
2
votes
1answer
1k 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 ...
1
vote
0answers
186 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
5answers
2k views

Online forms with spreadsheet functionality? [closed]

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 ...
3
votes
1answer
411 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 ...
4
votes
1answer
164 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
76 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
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 ...
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
1answer
610 views

View individual answers in Google Forms

I have made a 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?
2
votes
1answer
452 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 ...
4
votes
3answers
19k 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
5answers
15k views

Google Form, How to add Hyperlink?

How can I add Hyperlinks in Google Form?
1
vote
1answer
620 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 ...
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 ...
2
votes
1answer
752 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
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 ...
3
votes
1answer
371 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
7answers
18k 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 ...
7
votes
1answer
306 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
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 ...
12
votes
4answers
20k 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 ...