Google Forms is an integral part of the Google editors' suite. Its use is to collect responses. It can work with or without Google Sheets.

learn more… | top users | synonyms

18
votes
6answers
37k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
3
votes
1answer
260 views

Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script

I'm trying to make the edit URL for a Google Form automatically populate in the response Google Sheet that it's attached to. I've seen this already and want to use it, but I'm having issues trying to ...
5
votes
1answer
16k 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 ...
6
votes
1answer
25k 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 ...
4
votes
2answers
6k 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 ...
6
votes
4answers
5k 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 ...
0
votes
2answers
5k views

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

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

Customize the “other” box of a Google form

I have a Google form and I want the "Other box" of a multiple-choice question to say something other than “Other”. For example: Other programs:[ ] How to do it, if this is ...
2
votes
1answer
1k views

How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?

I have a filter view in Google Sheets that does not refresh when new data comes in via Google Forms. To refresh the filter view, I can remove the filter and apply it again, or even just click "OK" in ...
0
votes
1answer
321 views

Responses missing in Google Forms under the 'Checkbox - Other' question

I have a Google Form with a checkbox question and I can see from the responses summary that two respondents have ticked 'Other'. But, I can't see what they have typed, even in the responses ...
4
votes
1answer
4k 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 ...
3
votes
5answers
5k 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
1answer
3k views

Google Spreadsheet: Adding formulas to Google Forms responses rows

I have a sheet with form response 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 ...
1
vote
1answer
119 views

Report/process only using the last entry made by the user in a Google form

I have a form where students can enter choices: for instance the specialisation they want to pursue, and the semester when they will start that specialisation. An example entry form is here, but it ...
2
votes
1answer
849 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.
6
votes
2answers
6k 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 ...
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 ...
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?
4
votes
2answers
47 views

How to add up the correct answers from the check boxes question?

What syntax do I use when adding up the number of correct answers that have boxes checked? My question is; In this example the correct answers are Cotton and Calico. I award the students a total of ...
3
votes
1answer
953 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
59 views

How can we NOT record, but on the fly disregard responses not matching an already existing roster

We use google forms to send out tests to our students and must find a solution for the (as per title) following situation: The scenario limitations: NOT all our students can have a google account. We ...
2
votes
1answer
28 views

When creating a 'Checkboxes' question in Google Spreadsheets, what formula do I use to add a mark to each box ticket correct to the answer?

I am creating a Google Spreadsheet for the first time and I have suddenly become stuck. When filling out my spreadsheet I do not know what formula to use when adding up the correct answers. I have ...
2
votes
1answer
63 views

Rearranging Google form data in a new sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. The thought, being any of the staff could add jobs that need to be taken, by ...
2
votes
3answers
4k 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 ...
2
votes
4answers
4k 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 ...
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 ...
1
vote
1answer
34 views

Can I auto-fill an answer on a form edit URL?

I periodically send out emails to our team to check in on from entries that have a specific field set to "No". And after they complete a certain task then need to change that entry to "Yes". The ...
1
vote
2answers
74 views

Sorting Pre-Sorted Google Form Data by Timestamp

I have Google Form checkbox data that I am separating out into another table so that each checkbox selection generates its own line. I received some help in pulling the data over, and the resulting ...
1
vote
2answers
1k 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 ...
1
vote
1answer
212 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 ...
0
votes
1answer
297 views

Google Form keeps changing Spreadsheet cell entry

I seem to be having a bit of a problem, I'm using Google Spreadsheet and have created a form that people would be able to fill in online. It sends that data to a sheet called 'Raw Entry Form', I then ...