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

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 ...
0
votes
1answer
23 views

Is it possible to show answer based on results in google forms

I want to make a troubleshooting tool where the customer could answer the questions and in the end get the suggestion on how the problem could be solved.the questions are dependent. So if you choose ...
2
votes
2answers
35 views

Is there a way to prevent oversubscription using Google Forms

I am in a team of people organising an event. . So in the picture, for the first session, each person only attends one of the strands and not both. I would like to know if there is a way of ...
1
vote
1answer
68 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 ...
2
votes
1answer
62 views

Creating conditional sub-questions in Google Forms

I have an initial (round 1) question, which asks user to select options (checkboxes) that applies to him/her. There are total 5 checkbox options (#1, #2, #3, #4, #5). Out of the 5 options, let's ...
1
vote
1answer
17 views

Force Google login page to appear when accessing a Google Form?

I'm trying to create a Google Form that is locked to a specific Google Apps domain, however I'm running into the issue where if I send out the link to the form to my users and they are logged in to ...
2
votes
1answer
23 views

I created a copy (B) of a Google Spreadsheet (A). Now the Google Form that used to feed A is feeding B

Is there any way to change the settings of the Google Form so that it again feeds into the same worksheet of the same Google Spreadsheet (A) that it used to feed before I created the copy B? The only ...
0
votes
1answer
35 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 - ...
0
votes
1answer
30 views

“Select Users from organization” field with Google Forms?

So here is my scenerio, I have a Google form that allows users to send a co-worker a digital greeting card, but they have to manually enter the email address of the person they are sending it to. The ...
2
votes
1answer
42 views

Google forms hierarchical multiple choice questions

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 ...
1
vote
1answer
514 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. ...
3
votes
2answers
353 views

How do I record the value of GET parameters passed to a Google form in hidden inputs?

My question is basically the same as this one asked on StackOverflow, too old to migrate, but which seems to be a better fit here. This answer (more authoritatively, here) suggests a way to add a ...
0
votes
1answer
48 views

Google Forms Flow not working as expected

I have a Google Form with 4 sections and it is setup like this: Section 1 - One multiple choice question Yes (Go to section 2) No (Go to section 3) Section 2 - A few questions After finished ...
0
votes
2answers
30 views

Auto entering functions in sheets managed by forms

I want to fill a single column of my sheet with a function, the sheet is being managed by forms. So, whenever a new entry is added it adds a new row and that row will not have the function that I ...
3
votes
2answers
565 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
3answers
5k views

Google docs forms confirmation email when someone signs up?

When you are using google docs forms so people can sign up to an event. Is it possible to make the form send out a confirmation email when someone registers?
0
votes
0answers
50 views

Script to create an edit response URL in Google Sheet sometimes fails

I have been using the "FormMule" addon to create "Form Edit URL" apart from mail merge. However, the triggers for the addon seemed to have stopped working. I found this post answered by Rubén: Show ...
3
votes
1answer
255 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 ...
0
votes
0answers
32 views

Google form that shows calculated quantity

I need to create a Google form with following properties: It should automatically take today's date as input. For many inputs there is point associated with it. The total score is sum of all points. ...
3
votes
2answers
7k views

How do I publish this survey created in Google Docs?

I have a student who created a Form in Google Docs using their Google Apps for Education account. For some reason, we are unable to send this published form so that others can take the survey. Why ...
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 ...
1
vote
0answers
427 views

Filter out reponses to a Google Docs form by a failed “check” value in a multi-choice item

I want to lay traps in a Google Docs form to filter respondents. The form has some questions with answers in checkboxes like so: Question 1 ☐ Answer A ☐ Answer B Question 2 ☐ Answer A ...
2
votes
1answer
136 views

Running a Google survey through an online panel

I will be conducting a survey through an online third-party panel and need to upload my Google survey link but they require a unique ID tag for them to be able to identify unique responses. Do you ...
2
votes
1answer
55 views

Can I add two calculated fields to a Google Spreadsheet based on a Google Form?

I am new to Google Scripts and am hoping for some guidance on improving a manual process I complete in Google Sheets. To analyse the data I receive on a Google Form I run, I manually add-in (or copy ...
-1
votes
1answer
51 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.
2
votes
1answer
132 views

How to automatically wrap text to new responses from a form in a Google Spreadsheet?

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 ...
2
votes
2answers
225 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 ...
2
votes
2answers
39 views

How can I set a Google Forms survey to read-only?

I finished the collection of responses through a Google Form. Now I want to set the survey to read-only, i.e. allowing people to view the form but not submit any more responses.
1
vote
1answer
25 views

Trouble renaming a pdf file created in Apps script

I used Google Forms to make a 20-question quiz and added a page to the response spreadsheet that automatically grades the quiz immediately after it's submitted. I have this script in place to ...
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
108 views

How can one auto create pre-filled URLs with registered addresses from a roster

We use google forms to send out tests to our students. We have a spreadsheet with rosters where we keep the info of the students (email, birthday, gender, guardian etc) for every class in our school. ...
2
votes
1answer
58 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 ...
3
votes
1answer
57 views

Is there a way randomly distribute Google Form lead submissions

Is there a way to randomly distribute leads using Google Forms? A lead enters their information and it's logged in a Google Sheet. The goal is to randomly distribute the leads to other sheets, ...
1
vote
2answers
410 views

Auto sort of Forms responses so that the most recent one is on top

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
1
vote
2answers
58 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
39 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
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 ...
3
votes
1answer
171 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 ...
1
vote
1answer
341 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
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?
5
votes
2answers
42k 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
6k 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 ...
19
votes
1answer
1k 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
46 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
89 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
183 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
69 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
115 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 ...
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 ...