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

How to link two forms in Google Forms

Is there an option where I can link two forms? Example: I have a form running in production say "A", I am introducing new form say "B", in the new form "B" for a particular question the question type ...
0
votes
0answers
167 views

Google Forms: Add numeric values and use them for billing in paypal on form submission

I am using a google form to let people signup for a conference that lasts 3 days. A user has options to pay for a day, 2 days or the full conference. He/she has the option whether or not to pay for ...
0
votes
0answers
77 views

How create a Google Doc from a Google Form Input?

I would like to create a Google Form where the user input will do the following: fill in a Google Docs based on a template name the document according to the input place the document in a folder ...
2
votes
0answers
93 views

How to enable duplicating questions in Google form by the user who is filling it

I have a Google form with two parts. The first part is personal details (name, phone etc.). The second part is other information from the users. For my real needs, each part contains several ...
0
votes
0answers
45 views

Delete a q‚Äčuestion in a Google Form

I want to delete a row in the Google Form, and it disappears well enough in the spreadsheet, but it is still in the presentation. I also want to modify the contents of the investigation, but it does ...
1
vote
0answers
58 views

Google Apps Script with forms to check if a doc url is 'shared'

Does anyone know "IF" it is possible to use Google Apps Script with a Google form to auto check "IF" a document URL pasted into the form is a "shared" document? I'm a teacher and I use Google forms ...
1
vote
0answers
141 views

Make some responses in Google Forms private

I am creating a Google form as a questionnaire and would like to allow people to see some parts of the responses but not others. I am not a programmer, so not really into using scripts to sort them ...
2
votes
0answers
2k views

How to limit each user to fill a form just once? [closed]

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 ...
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 ...
2
votes
1answer
120 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
1k 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
2answers
2k 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
1answer
1k views

Get the Id of the response from Google Forms via a Google Apps Script

How do I get responseId ? var form = FormApp.openById('myGoogleFormID'); var response = form.getResponse(responseId); function onSubmit() { // Here I'd like to get the id of the current response } ...
6
votes
2answers
5k 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 ...
4
votes
3answers
6k views

Is there a way to password protect Google Forms?

I would like to create a check request form but I only want users who either enter a password or whose Google accounts I give permission, to be able to fill out the form. Is this possible? One idea ...
1
vote
1answer
942 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?
1
vote
1answer
312 views

Can I have the results of Google Form sent to someone else?

I'm making a health info form for my boss, but I want the results to be only viewable by her and not by me. Is there a way to do that? Or would she have to make a copy of my form and then delete me ...
0
votes
1answer
113 views

What Infomation is collected by a Google Form

I have a question about what information will Google Forms collec. Will the form creator ever know who fills the form (the Google Account that the user is logging in) ?
1
vote
1answer
827 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
278 views

Google Form and Group email

I have set up a group email that I'd like to use within a Google Form. Currently the Google Form is pre-filled with my personal email and I'd like to change it to the group email. Any help in ...
3
votes
1answer
115 views

Google form at specific time

Is it possible to create a Google form that will accept responses only during a particular time period?
1
vote
1answer
903 views

Is it possible to feed multiple form drop down lists?

I am using Tom Horwood's code which has worked for me for updating one drop-down. But my form has multiple drop-down lists which I would like to make dynamic. Is this possible? Tom Horwood's code ...
1
vote
3answers
299 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 ...
4
votes
2answers
4k views

How do I implement a script that creates a unique ID for a Google form submission?

I need to create a unique ID upon submission of a form which will be used as a project number for tracking. The number needs to be unique but not based on rows or other changeable data because ...
2
votes
0answers
43 views

Send form daily/automatically [duplicate]

I was wondering if anyone knows a way of sending a Google Form daily and automatically to someone? More specifically, I am a tutor who would like to send a HW check-in to my students daily, but I ...
13
votes
4answers
23k 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 ...
4
votes
1answer
727 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 ...
1
vote
2answers
796 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 ...
5
votes
1answer
392 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 ...
1
vote
2answers
271 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 ...
2
votes
1answer
707 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.
5
votes
2answers
3k 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?
1
vote
0answers
520 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?
2
votes
0answers
122 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 ...
3
votes
1answer
344 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 ...
4
votes
1answer
3k 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 ...
0
votes
1answer
3k 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
150 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
751 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

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 ...
2
votes
1answer
973 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
3k 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
85 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
197 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
246 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
550 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
570 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 ...
5
votes
2answers
5k 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
3k 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 ...