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

1
vote
0answers
15 views

Google Forms - 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 ...
0
votes
0answers
17 views

One form submit produces two updates to spreadsheet

I have an application in which a user submits a form, the data are logged in a spreadsheet, the form submit triggers a script that records the new data and deletes any previous form responses from ...
2
votes
1answer
16 views

How to change position of column form responding sheet after add form item

I can add an item to a Google form and to change its position in the form by Google apps script. The corresponding column in the responding sheet is always the last column. I can manually move that ...
1
vote
1answer
15 views

Completing survey on Google Forms without a Google account

I have created a survey using Google Forms and need to send to University staff. How can I restrict to only one response per person without survey group having a Google account?
3
votes
1answer
37 views

Import only those cells from a spreedsheet that have certain conditional formatting

I have created a Google form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created a conditional formatting which highlights the ...
0
votes
0answers
12 views

Separate Google Forms checkbox responses into individual rows

I would like to use Google Forms to record events that students participate in. How do you separate Google Form responses so that that data goes into individual rows to then use vlookup to find the ...
1
vote
1answer
31 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 ...
0
votes
0answers
16 views

Scroll up to the success message once the embedded Google form is submitted

How to scroll up to the success message once the embedded Google form is submitted, so that the user sees the message? I have a height of about 2000px and when it's done the submitted message is out ...
6
votes
1answer
131 views

How to create a question in Google Forms that allows two distinct answers?

I have a question like this (it's a DISC test, if this matters): 1. From the following list, which option is 100% you and which option is 0% you? a. tall b. fat c. happy d. unemployed How can I ...
1
vote
1answer
33 views

How to increase Google Forms content width?

I have a google form for which I have some grid questions, using long labels. This implies that some of the questions are shown with scroll bars I do not want. is there a way to configure my form to ...
-1
votes
1answer
55 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 ...
1
vote
1answer
25 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 ...
1
vote
1answer
214 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
27 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
2answers
58 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
57 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 ...
0
votes
2answers
34 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 ...
0
votes
1answer
55 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
0answers
66 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 ...
0
votes
0answers
42 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. ...
2
votes
1answer
60 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 ...
2
votes
1answer
79 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
votes
1answer
62 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
2answers
60 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
28 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
1answer
154 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
60 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, ...
0
votes
1answer
45 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 ...
4
votes
1answer
388 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
50 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, ...
0
votes
1answer
87 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 ...
1
vote
1answer
234 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 < ...
2
votes
1answer
146 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
168 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 ...
3
votes
1answer
115 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.
1
vote
1answer
398 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
2answers
94 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 ...
2
votes
2answers
64 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 ...
20
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
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?
1
vote
1answer
23 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
0answers
71 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
115 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 ...
2
votes
2answers
287 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
47 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? ...
2
votes
1answer
42 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
54 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 ...
0
votes
1answer
58 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
40 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 ...