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
0 votes
2 answers
11k views

How can I get data from Google Sheets to a Google Forms dropdown list?

I have some data in a Google Sheets file. I want to get a Google Forms dropdown list to be updated automatically from that list. Is it possible?
0 votes
1 answer
129 views

Google Forms - two required questions - accept with at least one of them

I collect links to historical records describing persons falling into certain categories (e.g. secret Protestant or vampire/witch case). User specifies the Category with a checkbox answer (multiple ...
0 votes
1 answer
130 views

Google Form reply to form respondents from a @domain email

I'm using Google Forms to create a survey but the auto response email has my personal email account in it. How can I change it so the from: is, for instance company@company.com instead of company@...
0 votes
4 answers
56k views

How to see names for survey responses?

How can I show the name or email address for responses to form survey in the results spreadsheet? We want to see each other's responses but results sheets seem to be anonymous and only show time ...
0 votes
0 answers
16 views

How do i know who submitted the google form? [duplicate]

In google spreadsheets, if I give access to the edit role, I can understand who edits the cell but how do I know who is the person that submitted the form? I will thankful if anyone gives a solution.
0 votes
1 answer
40 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
0 votes
1 answer
288 views

Google Forms Quiz Response Sheet

I have added a couple of columns to the Google Sheet Responses for a quiz created using Google Forms. When creating the response sheet (created in the "Responses" tab of the quiz, it automatically ...
0 votes
1 answer
648 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
0 votes
1 answer
428 views

Fetch Random String From Array For Each New Form Entry

!Sheet1 is populated with entries coming from a Google form !Sheet2 has an array of 12 employee names in array A2:A13 How can I automatically populate the cell on the right column of every new line ...
0 votes
1 answer
14 views

Create a dropdown list that only shows items marked as unused!

I created a table with the list of clients and the licenses they use in different apps, themes, scripts. And these registered licenses appear in a dropdown list so that I can select, but I would like ...
0 votes
1 answer
46 views

Google Sheets formula

I'm using Google Sheets make a spreadsheet with the name in column a, the company in column b and in column f, I need their email. I have 3 companies, and they have slightly different email formats. ...
0 votes
1 answer
20 views

Cannot read property '0' of undefined at onFormSubmit

I have created a Google Apps script from a Google Sheet. Data is submitted to the sheet via a form. I had onFormSubmit(e) working fine and sending a custom email to the form respondent. But now it's ...
5 votes
2 answers
3k views

Google Forms Answer Validation Based On Another Previous Given Answer

I am working on a form in Google Forms. At some point during my form, I need to validate an answer based in a previous answer. To make it more clear, I give you an example: How many hours do you ...
0 votes
2 answers
47 views

Get two different type of answers to an answer

How can I get Google Forms to allow me to have two different type of answers to one question? Answers are to be related between them so when working results, I can get the grades of each group member. ...
1 vote
1 answer
2k views

How can I merge responses of two Google Form identical to each other but in two different languages

I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
0 votes
1 answer
386 views

Show student's result when they enter roll number in Google Form

I have a Google Sheet with all students subject marks, roll numbers, names. I'm thinking of following: Students are given URL of a Google Form. Only field there is for roll number. Once they entry ...
0 votes
1 answer
19 views

Copying Values immediately based on other cell Values

I am collecting data from Google Form into a Google Sheet, in a Form Responses Sheet it has a column R that cell value changes (as the form responses can be editable), and the values can be Pending, ...
1 vote
2 answers
673 views

Hide Respondent's Email Address in Google Form

When someone responds to my Google Form, it displays their email address at the top of the form. I've disabled the option Disable autosave for all respondents in the form settings but the message ...
0 votes
1 answer
13 views

Can I edit choices without affecting the already submitted responses?

So I have made a form for a project. I got some responses, but now I want to translate the whole form into English. The problem is that if I try to edit the choices, the responses stay the same, in ...
2 votes
1 answer
673 views

Google Sheets - Query Multiple Columns for same Data

We have Employee training data in a Google 'Form Response' spreadsheet which ranges from A1 to JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult ...
1 vote
3 answers
3k views

Google Forms Duplicating answers to Google Sheets

I have a google form to capture order information, When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much. ...
1 vote
1 answer
205 views

Can I set a limit of 2 entries on Google Forms?

I use Google Forms in my classroom to administer certain quizzes, however, I allow my students two attempts on these. I have noticed that I am unable to see how may actual attempts have been made and ...
1 vote
1 answer
368 views

Google Forms sending me duplicate email on automatical email

So, I've used this code, just reworked for my needs: Can Google Forms send emails automatically? The problem I have is that the account that sends those emails also receives them. Is there a way to ...
2 votes
2 answers
5k views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
-1 votes
1 answer
38 views

Google Forms permissions

I joined for a FitBit Zoom Webinar and then takes you for a Google Forms survey and when I leave Zoom to go Google Forms. I need Permissions. Any Suggestions on how to work this?
1 vote
1 answer
1k views

Easy way to create a Google Form with a lot of images?

I'm trying to create an online survey with multiple images, where each participant would write what they call the thing depicted. Each question would be composed of an image and a textbox for the ...
0 votes
2 answers
60 views

How to save question before going back to the same question in Google Forms?

I need to make a questionnaire. The idea of the questionnaire is that it asks the user first two different questions (name and country) and after the two questions it asks that if the user wants to ...
0 votes
1 answer
23 views

Google Forms corresponding to a pre-set date on Sheets instead of being added consecutively

Is it possible to have Google Form data inputs being added not one after the other but corresponding with the Date that is pre-filled on the response form? Here you can see how the data is currently ...
0 votes
1 answer
1k views

Add dynamic questions in Google forms

I am using google forms to punch orders in my Google Sheets. Although I am facing a challenge as the number of products is variable. For example Question 1: Item Name Question 2: Quantity I ...
0 votes
1 answer
253 views

Shuffling questions in only one section of a Google Form

I am creating this Google Form with two sections. One takes the student information; Reg. No., Name, Class etc., and the other section contains the subject-related questions which I need to have ...
0 votes
0 answers
18 views

Show number of responses in Google Form to people filling the form

I would like to know if there is a way to add to the form something like "X people filled the form" for people other than me. The option to show the summary of responses gives too much ...
1 vote
2 answers
442 views

Insert a weekday in Google Forms' date selector

We have created a Google form that works perfectly, there is only one issue, and that's the DATE selector, it sends the DATE, but we would like to receive the DATE and the WEEKDAY in the form we ...
1 vote
1 answer
257 views

Populating alternatives in question 2 based on answers in question 1

I have ten people who sell something to companies, and I want to track what they do IN GOOGLE FORMS. Every agent has his own 10 companies that he contacts. So, in Question 1, I will have a drop-down ...
0 votes
1 answer
52 views

How to give access of Response sheet linked with Google Form to only those who filled form?

Let's say I'm collecting Name and Email (using Collect Emails setting), I wish to allow view-access to the Google Sheets Response Sheet linked to that form with only those who put their email id. ...
0 votes
2 answers
61 views

Multiple choice response in rows without repeating other entries

We have a multiple choice question in our Google Form. We use some other spreadsheets to re-organize questions from the Google Form response sheets. What we need is having multiple choice responses ...
1 vote
1 answer
897 views

Hide skipped sections in responses

So, I've got an example form here with some conditionals. The flow is intended that it skips ahead to a specific section depending on the initial response—the usual. My issue, however, is when ...
1 vote
1 answer
345 views

Google Form response is modifying a cell on another row of linked sheet

I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...
0 votes
1 answer
30 views

#REF!, How to Grab the first response of form and ignore the duplicate in google sheets

I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
2 votes
1 answer
1k views

Importing data into Google Form response sheet with date, list, grid

I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
0 votes
1 answer
304 views

Google Apps Script send attachment on cell value

First of all I am a complete beginner in coding. So I am trying to build a form, that once it is submitted, will send a different gdrive file as excel sheet based on a key word in the form. So far I ...
2 votes
1 answer
978 views

How to send Google Form results to a particular sheet ("tab") of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
1 vote
1 answer
2k views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0 votes
1 answer
44 views

Need a Unique ID to be populated in Google sheets on Google Form submission

Looking for a dynamic unique ID for Google Forms, to populate into Google Sheets Response form. I don't want to use external addons. Below is a code I found online but can't get it to work - I'm a ...
0 votes
1 answer
29 views

Where can we see Google Forms we submit?

Is it possible to view the information or confirm we sent in Google Forms? Assuming the form itself did not have the checkbox that said send me my answers.
0 votes
1 answer
151 views

Have a new Google form be started linked to an existing spreadsheet

My problem: I want to create a new form and have it automatically linked to an existing spreadsheet. It can create a new sheet on the existing spreadsheet, but the linking step should be automatic. ...
0 votes
1 answer
1k views

How to use the "Make a Copy" trick when sharing a Google Form?

I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
0 votes
1 answer
28 views

Add a question per checked multiple choice answer

Say I have the following question: What are your favorite things (multiple choice)? [ ] Thing A [x] Thing B [ ] Thing C [x] Thing D I'd like to dynamically generate the following sections with ...
1 vote
1 answer
659 views

Conditional checkbox in Google Forms

I'm creating a peer evaluation on Google Forms. The first question is for students to select their name. If the student has selected his/her name, the choice for his/her name will not appear in ...
0 votes
1 answer
19 views

Importing multiple user responses on a Form to a single row on a Sheet

I have a Google Form containing three linear scale questions. The form collects emails and then a value between 1 and 3 for each question. I need the people who respond to the form to do so biweekly....
0 votes
0 answers
10 views

Dynamically add answers [duplicate]

I want to ask questions as the following with Google Forms: What lessons have you already completed? (here I give a list of lesson options. Only one option can be selected) Lesson A Lesson B Lesson C ...

1
2 3 4 5
12