Questions tagged [google-forms]

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.

Filter by
Sorted by
Tagged with
21
votes
7answers
73k 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?
4
votes
3answers
6k views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
12
votes
1answer
45k 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
2answers
7k 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 ...
6
votes
2answers
23k 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 ...
8
votes
6answers
5k 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 ...
10
votes
1answer
100k 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 ...
7
votes
1answer
28k views

Apply custom CSS styles to Google Forms

Google forms are presented for the user to embed in his/her website as an iframe, which means they can't be styled by the website's own CSS. How can a Google Form be inserted into a website with a ...
0
votes
1answer
1k 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 ...
6
votes
10answers
30k views

Importing data into a Google Forms response sheet

I have some Google Forms and would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've been ...
8
votes
2answers
53k views

Can Google Forms send emails automatically?

I used Google Forms to create a form for people to register for an event, by entering their name and email address. I would like to set it up so that when a person enters his name and email, the ...
3
votes
3answers
13k 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 ...
10
votes
3answers
127k views

How to add attachment option in Google Form?

I need to make a Google Doc Form, in which the users need to upload a Word file. Is it possible to do so using Google Docs form? If yes, then how?
3
votes
1answer
1k views

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

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
2k views

How to set input type = “tel” to the answer input field?

In my Google Form I've got multiple text questions with answers with data validatation set to numbers only. Unfortunately when I enter the answers using the mobile browser the keyboard shown is full, ...
1
vote
2answers
14k 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 ...
5
votes
1answer
3k 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 ...
4
votes
1answer
11k views

Link Google Form responses To Already Existing Google Spreadsheet Tab

I have a Google Form. I had all of my Google Form responses linked to a specific tab in my Google Spreadsheet. Somehow my form responses were unlinked from my tab. When I go to re-link my form ...
3
votes
3answers
3k views

Google Forms quiz submit ONLY when ALL correct

I would like to use Google Forms to create a simple 5 question multiple choice quiz. When the user has selected their answers and clicked Submit I would like to display immediate feedback on the same ...
3
votes
2answers
3k views

Send a google form result to an email

I need help with the google form. The problem is this: I want to receive an email with its results for every user who completes the form. For example, if you had a form that required email, name and ...
0
votes
1answer
856 views

How can I make a minimal, unstyled HTML form which works with Google Forms?

I want to embed a Google Form in my website, but make it unstyled, etc., so it looks neat and can be placed in widget form.
0
votes
1answer
6k views

Can you style Google Forms (from Google Apps)?

While Google makes themes available to style forms in Google Docs, there seems to be no provision for styling forms yourself. I have a two-column layout and want the form on the right. There are ...
10
votes
3answers
15k views

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms 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 Sheets renders the ...
3
votes
1answer
2k views

Google forms hierarchical multiple choice questions [duplicate]

Supposing I have 2 multiple-choice questions concerning: Country students are from: ..... (choices include USA, UK, China ....) States where they are from: then if they selected USA in the first ...
2
votes
1answer
60k views

How do Google Forms handle the “Other” field in Multiple choice/Checkboxes/Drop-down questions?

We use the "Other" option on our multiple choice questions but get inconsistent results recorded for the field on both the form "Responses" tab and the connected spreadsheet as well. There seems to ...
2
votes
1answer
4k views

Google Form can be edited, or not viewed at all - where is the view only option?

I am trying to create a Google Form. I am unfamiliar with Google Forms, but I am familiar with Google Sheets and Docs. I'm having a problem with the form, however. When I go to the Sharing Settings ...
10
votes
7answers
21k 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)?

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 that as new options were added to the list in the spreadsheet (or ...
24
votes
4answers
87k views

How to create a countries drop-down list question, without entering all countries manually?

I am creating a Google Form, and as the final question I want to ask the participants what country they come from. As it often comes up in polls, I am surprised that this country component is not ...
5
votes
1answer
10k views

Auto-create and name new sheet in Google sheets from names being filled from a Google form

How can I automatically create and name new sheets in a Google Spreadsheet from a list of names which are being input in the sheet from a Google Form? I would like each new sheet to be created when a ...
4
votes
3answers
36k views

Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
4
votes
1answer
9k 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 ...
9
votes
1answer
60k 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 ...
8
votes
1answer
43k views

How to delete a single answer in Google poll/survey

I started a survey with Google form. Everything is fine. But one Answer was accidentally given twice. As I understood, there are two locations of the answers. Internal, of the form and a copy of each ...
7
votes
1answer
1k 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 ...
6
votes
3answers
27k views

How to limit one response per email for Google Forms

I am creating a survey in Google Forms and I'm going to that use inside our organization. I am going to send the form link to everybody inside organization using their internal email. The form will ...
5
votes
1answer
54k 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?
5
votes
1answer
17k 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 ...
4
votes
1answer
24k views

Retrieving user email address from Google Form survey results

I am a Google Apps user. Is there a mechanism or script which allows me to retrieve the respondents email address from a survey? I can see the timestamp but there is no respondents email field. ...
2
votes
1answer
5k views

Validate age (>18) Google Forms?

I working on this form that has to be filled only by those over 18 years old. I was wondering if is possible to ask for the date of birth or the age in the first question and if is over 18 then the ...
2
votes
1answer
2k views

Copy submitted form data to new automatically generated Google sheet

I have created a new sheet for every new name entered in the form using the following code. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; SpreadsheetApp.getActiveSpreadsheet()....
2
votes
1answer
668 views

Using a script to process form input every time a form is submitted

I'm trying to have it that every time I submit a form, it adds automatically some data. This is the script I have: function onFormSubmit(Test) { var sheet = SpreadsheetApp.getActiveSheet(); ...
2
votes
4answers
9k views

How do you automatically align incoming form responses in Google Sheets?

I like to have each of my form responses aligned in the center of their cells. However when I submit any new information through Google Forms, they are always automatically aligned to the left, and so ...
2
votes
3answers
27k views

Is it possible to recover deleted responses from Google Forms?

Here is the context of this question. We used Google Forms for an election of 6 people. I want to know if it is possible to delete individual responses and then recover all responses (deleted and not ...
1
vote
1answer
6k views

Email respondents a copy of their completed Google Form

I am the new coordinator of a high school theatre awards program. I have created an evaluation form for the judges to fill out after they have seen their show. They would like to have a copy of their ...
1
vote
1answer
1k views

Share Google Drive Folder with submitters of Google Form

I have a Google Form that is used as a sign up form. This form has a question requesting emails. It uses the email validation. I have a Google Drive folder that I want everyone who signs up to be able ...
1
vote
1answer
898 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 ...
0
votes
1answer
1k views

Arrayformula+VLOOKUP find value of non-empty reference (callback/recursion problem)

Similar to An arrayformula to find the previous non-empty cell in another column. I have two worksheets like this: "" = Blank cell () = Sheet Name Worksheet One (Form Responses 4) is the input ...
10
votes
5answers
85k views

Adding hyperlinks in a Google Form

How can I add hyperlinks in Google Form?
6
votes
2answers
5k views

Limiting the amount of Google doc's forms that can be submitted

I'm arranging an event and I'm 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
1answer
8k views

Google form anonymity in organization

I have a Google account that's part of an organisation. There's this form that only people in the same organisation can respond to. Is there a way for the owner of the organisation to find out that it ...