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

0
votes
1answer
5 views

How to connect different questions in forms to one column in the responses

I created a form to take the attendance of my students and created one page for each class and one main page that has all the grades that enables me to move to the other pages. The responses sheet has ...
5
votes
1answer
12k 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 ...
3
votes
1answer
145 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 ...
3
votes
1answer
29 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 ...
1
vote
1answer
175 views

Is there a way to generate edit response url for google form

I have a Google Form With a Google spreadsheet to store responses. In my spread sheet I have 4 column: name, email, revenue, and a fourth column Id which is used to identify the particular recipient. ...
18
votes
6answers
34k 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
2answers
29k 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
4k views

How to save users' responses in Google Form survey as they continue from page to page?

I have a long form for users to answer survey questions with about 20 pages. It's long enough that users may want to stop and finish the survey later, or they may abandon the survey altogether half ...
18
votes
1answer
770 views

How can someone answer my survey form or Google form without creating their own Google account?

How can someone answer my survey form or Google form without creating their own Google account? They told me that they can't open my form because they didn't have an account.
0
votes
0answers
28 views

Easy way to create a survey with an image attached to each question?

I'm trying to create an online survey with where each question would be an image plus a textbox for the answer (the theme is "what do you call this thing"). I've started doing it in Google forms, ...
2
votes
2answers
59 views

Google Sheets/Forms/Script: How to send an email then replace “@” with “#”

I am trying to create a script where the user gets an email (column 1) with the body being column 2. However, after that, I want to replace the "@" in the email with a "#" so that they do not get the ...
1
vote
1answer
60 views

Send recurring reminders to Google Form respondents

I need to create a Google form like below : My objective is to send an reminder of Activity Described in < Your Activity > Question Then I need to send reminder email to email mentioned in < ...
0
votes
1answer
40 views

Google Sheet Cell Link to Google Form test score

I have a pre-made Google Sheet which has cells to be marked as "pass" or "fail" depending on the person's score. Is it possible to link a Form response to record a pass or fail mark depending on the ...
0
votes
1answer
24 views

How to dynamically retrieve and display data based on input from google forms

To be very specific, let's say I have a google form where it asks you your name (text box) and how much do you like carrots, with a multiple choice prompt of "very much" and "I hate them!" After the ...
2
votes
1answer
42 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 ...
0
votes
1answer
31 views

How to save logic branching in lines, not in columns

Is there any way to save new information that comes from logic branching questions into new lines, instead of new columns? I'm trying to have something like this on my Answer Spreadsheet: Provider - ...
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 ...
2
votes
1answer
50 views

Automatically creating sheets across different Google Spreadsheets

I have one spreadsheet that collects the Google form data that is submitted. I then created spreadsheets titled "A-D", "E-H", "I-L", and so on to create the alphabet. I would like students to use ...
4
votes
2answers
3k views

How can I create an e-mail field on a Google Form?

When making a Google Form, how can I mark the field as "e-mail" so that it is validated as an e-mail before the user can submit the form?
2
votes
1answer
35 views

How to automatically wrap text to new responses from form?

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet. Now recently I had to remake this ...
3
votes
1answer
37 views

Use a Google Form to update an existing Google Sheet

Is there a way to update an existing sheet in a Google spreadsheet using a Google form? I only see how to update to a new tab (sheet) on an existing spreadsheet.
0
votes
0answers
33 views

Selecting and unselecting checkbox not updating response sheet

I have a Google Form and a response spreadsheet that is updated as soon as a recipient of the form answers and submits the form. I have several different types of field ( multiple choice, grid, ...
1
vote
1answer
74 views

Create question in Google Form where all answer options calculate to 100%

I have this question in a survey I'm trying to build a percentage accumulation like so: Put the % of how much you spend of your salary in the following categories: [Food, Transport, Health, ...
2
votes
1answer
2k 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 } ...
2
votes
2answers
23 views

Google Form list question to send different data from displayed value on select option

Is there a way to have a Google Form list-type question pass different values on the backend (e.g., to its linked Google Spreadsheet) than what are displayed? For example, under Provinces at ...
2
votes
1answer
107 views

How can I get my set values and formulas to populate to a row of values received from a Google Form?

When I receive submissions from a form I am trying to find a way to include my formulas and set values in the same row as the information submitted by form. My form is only collecting 14 values but my ...
0
votes
0answers
10 views

How do you make a drop list dependent upon another drop down list? [duplicate]

I work with schools and districts. I would like the form to have a drop down menu for the district, then based on that choice, another drop down menu for the school choice. Is that possible?
0
votes
1answer
11 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 ...
9
votes
2answers
278 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
21 views

Is there a way to check data entry consistency in Google Forms this way?

In the questionnaire I'm working with, there's a question like this: What was your facility's total revenue last year? And a bunch of following questions asking about sources of that revenue, ...
2
votes
1answer
40 views

How do I include multiple fields for each answer (two-part answer) choice?

My specific question is how to set up Google forms to allow a two-part answer. For example, which of the following books have you read and how many days did it take you? So you would have many book ...
1
vote
0answers
24 views

Google Form from Facebook Group

I have a a google form that I would like to only make available to members of a closed facebook group. The form is anonymous and members are free to use it as often as they would like. The problem is ...
4
votes
1answer
44 views

Check Google Form entry for duplicate answers

I want to make a new form where I ask people about their "top 15" within a list of elements. I have searched a lot, but I couldn't find anything. I decided to just make 15 questions, "what's your ...
9
votes
3answers
2k 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 ...
2
votes
1answer
64 views

Automatically copy and paste cells that have just been updated to a list from forms

I have a spreadsheet that collects information from two different forms. Each form feeds a different sheet in the spreadsheet. There are 3 other sheets that the info from either of the first two forms ...
0
votes
1answer
15 views

Is there a way to specify multiple conditions for “Go to section” feature in Google Forms?

I'm learning to use Google Forms to create a survey questionnaire, whose skip patterns of some variables need multiple conditions. For example: Question 1: When did you have veggie yesterday? ...
1
vote
2answers
76 views

Email copy of filled-out Google Form including boilerplate

I have constructed a Google Form used to book a community hall, and the form includes some Terms and Conditions that the user is agreeing to. I've displayed the Ts&Cs using the description field ...
3
votes
5answers
4k 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
26 views

Cannot plot null values in Google Forms

I have a Google Form with questions that I collected the responses from. Now I am trying to create the charts. I click on Responses -> View responses, then I click on Explore to see the chart. The ...
2
votes
1answer
33 views

How can I round a Google Form input to nearest .5?

I'm trying to write a script that will calculate based on user input from a Google Form and then send a customized email based on the input provided. I've written an apps script bound to the ...
2
votes
1answer
84 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 ...
4
votes
2answers
40 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 ...
2
votes
1answer
51 views

Edit multiple form responses inside a Google form

I am looking an editing form responses on Google Forms. So basically, I was thinking to create a simple form for the fields I need and having a drop down on the top to edit form responses ...
0
votes
1answer
33 views

Pre-filled Google form with varying number of questions

So I am doing a client check in...some clients have 5 things about which I need a status, some have only 1. How/Can I create a Google form with pre-filled answers and questions that would vary by ...
3
votes
1answer
34 views

My students are losing their answers before submitting the form

I do my assessments using Google Forms. Things have been good so far until today. This morning, two of my students who were taking their assessment, found that all of their responses had been ...
2
votes
1answer
24 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
41 views

Google Form with an alert

I created a registration form with Google Forms. Now I would like to have an alert displayed before the submitter starts filling out data. This is my code: function onOpen() { FormApp.getUi() ...
2
votes
1answer
29 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(); ...
6
votes
1answer
20k 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 ...
1
vote
1answer
60 views

Google Sheet not being populated and responses summary not getting incremented after Google Form submission

My wife has a paint & wine party business and I've been using an embedded Google Form for registration on her site for nearly a year without issue. Last week I updated the photos in the ...