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
0answers
36 views

Not being able to see my students’ answers for a question that I edited while the exam

I edited a word which was part of a question while my students taking the exam in Google Forms. After my students submitted their answers, I realized that Google considers that question wrong for all ...
0
votes
0answers
26 views

How can I keep the link between a Google Form and a Google Sheet when I make copies of both?

I have a Google Form that is linked to a Google Sheet. I'm trying to share copies of both the Form and the Sheet with people, but when people make their copies, the link between the Form and the Sheet ...
0
votes
1answer
79 views

Count if contains yes using array formula for Google Form entries

I want to count every yes per submission of each Google Form, so the row. Some of the responses have comments after the yes and it won't count those. This is the formula I am using: ={"Score"...
0
votes
1answer
32 views

How do I save a Google Form?

I created a registration form on a Google Form and emailed it to be filled out. Now I want to save the form and the answers to the questions. How do I do that?
0
votes
0answers
19 views

How do I update a single Google Sheet tab with information from two tabs on the same sheet when a form is submitted?

I have two forms that contain similar information. One asks for more in-depth information that is needed sometimes from external customers while the internal one doesn't need as much information. I ...
1
vote
0answers
27 views

Pull data from separate Google Sheet into a Google Forms response sheet and update dynamically

I have a Google Sheets leave sheet for employees where we track the leave days due and days already used. I also have a Google Form which submits responses to linked sheet and runs with Form Publisher ...
2
votes
1answer
621 views

Can one edit the sections in a Google Form after sending it?

I sent out a Google Form with several conditional sections inside. After having some responses I realized that I made a mistake in setting the routing to one of the sections. The form skips the wrong ...
0
votes
0answers
24 views

Overwrite Google Form responses with Data input tab

Due to Covid we have to do registration differently. We have a form that collects all the requests. The counselor meets and pulls up their ID on a search tab. If there is a mistake the counselors ...
0
votes
0answers
28 views

Google Forms Overlay Responses

I'm trying to capture a few information about our business partners. Four of the questions will be used to print a contact card. Is it possible for Google Forms to display the 4 responses that ...
4
votes
1answer
314 views

Google Sheets - existing row formulas are being erased after Google Form submission

I am having problems with Sheets and Forms connection. I have pre-entered formulas on Google Sheets, like vlookups and TO_DATE value, but as soon as I submit entries from Google Forms, the formulas ...
1
vote
0answers
236 views

How to retrieve sections of a form I accidently deleted (including the surveyors responses)?

First time using Google Forms and I was so impressed! It was doing everything I needed for research on a book I am writing. However, Thursday night... on my phone looking at some responses I ...
0
votes
1answer
36 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
0answers
505 views

Refresh after submitting Google Form, back to the editing page again, can I prove I didn't change anything after the deadline?

I submitted a response, and the professor has allowed us to edit after submitting. Several minutes after the deadline, when I try to close the web page, I accidentally refreshed it, and I got back to ...
0
votes
0answers
12 views

Google Sheets email notification

I have a spreadsheet that is being populated by a Google Form, I need to set up so that an email notification is sent if the word “other” is imputed into the sheet, any help?
0
votes
0answers
112 views

Split choice grid or multiple choices in several rows on sheet

I have a form that I want to work as follows: The person will answer a question (text box) with an ID and another question (which can be a choice of multiple answers or a multiple choice grid). What I ...
2
votes
2answers
40 views

Is Google Forms quiz result adjustable

Does everyone see everyone's result when sent after a Google Forms quiz or just their own points (is this adjustable)?
0
votes
1answer
29 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?
0
votes
0answers
9 views

Edit URL not writing back to sheet

I have created a Google Form which populates a sheet, and an Edit URL script to allow changes to be made by the user via the sheet preview. This is all working for most of the form. Except when an ...
0
votes
0answers
21 views

Google Forms - using as feedback form for multiple schools

I am sending a link for a Google Form in an email, asking for course feedback. I send the same link to multiple schools. When I get responses from the schools, I like to share the student responses ...
1
vote
0answers
9 views

I want to send Google Form response to an Email address entered on the form

When a user completes the form to attend a conference. I ask for another email address so their supervisor knows they have signed up and for what date. How can I use the field on the form as the ...
0
votes
0answers
7 views

Changing question format, but keeping content in Google Forms

Q: I started drafting a survey in Google Forms, but then decided that the content might be best represented in a different format (drop down, multiple choice, etc.). However, when I try to select a ...
0
votes
1answer
30 views

On Google Forms, can someone edit their response but can't add a new one?

For example "someone 1" edits their response via the link that I have added in the Google Spreadsheet (https://drive.google.com/file/d/1gtULaR5VEfuLOP4f73Z3KofsnksmpSid/view?usp=sharing), ...
1
vote
1answer
702 views

Can we use signed in email address of the user to auto fill the email text box in Google Forms?

I am creating a Google Form in which people will enter their names and email address and other details. I have done this previously but have noticed that most of the people uses their wrong email ...
1
vote
0answers
48 views

Google Form - Updates made after release

I created a quiz in Google Forms and released the scores to the students with my feedback. I am a big proponent of students revising their work, so I allow them to "edit after submit." ...
1
vote
0answers
33 views

Google Form to sheet to Doc, with calculations after pushing to sheet

NOTE! I am not a programmer I'm just fumbling through this! I've gotten as far as I can with searches, getting lost on multiple steps as most responses don't integrate on thing to the next. Background ...
0
votes
0answers
167 views

I have a Google Form that feeds into a Google Sheet. I need to pipe that information into another tab/cell in a dynamic way based on a data validation

Lets see if I can explain this well enough... I have a spreadsheet "Main_page" that is dynamically pulling information from a secondary sheet, "All_shots". I also have 2 google ...
0
votes
1answer
44 views

RCV Polling Data from Google Forms goes the wrong direction in Google Sheets

I am making an RCV voting system in Google Forms, however, when the results go into Google Sheets, they come out like this: Timestamp 1 2 3 4 239029339 Candidate A Candidate B Candidate D Candidate ...
-1
votes
1answer
23 views

Cancel an answer when filling a Google Form

Suppose that I, as an user, have to fill a Google Form. On a certain multiple-choice question, I choose the answer yes. Then, I recognize that I'm not sure it is the right one, so I want to cancel it. ...
0
votes
1answer
188 views

Is there a way to add a new sheet tab to a Google Sheet based on the timestamp date?

Students take a weekly survey on Google Forms, and it is transferred to a Google Sheet. I want the Google Sheet to automatically generate a new tab based on the date (timestamp) so that each week has ...
0
votes
0answers
22 views

Create unique URL for Google Form when redirected from a survey platform

I am trying to host a survey. In thank you page I require interested participants to click on a link that redirects them to a Google Form where they have to provide their contact information. However, ...
0
votes
1answer
813 views

Google form script "form.getItemById(710215182).getResponse" returns undefined

I have created a Google form and I am trying to retrieve a response after the user submits the form. As some of my questions are grids and may be left blank by the user, the indexes of the responses ...
2
votes
2answers
2k views

copy a google form retaining responses and summary charts

I have wrongly submitted a google form to two different groups of people. So I have created a copy of the form after generating the spreadsheet. However, in the responses tab of the copied form, I get ...
0
votes
1answer
326 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
0answers
530 views

Using Google Forms is it possible to collect a list of respondents that is separate from their anonymous answers?

new to this particular Stackexchange with a Google Forms question? I need to a submit a survey to members in our organisation. I have built this survey in Google Forms. I need to record a list of ...
1
vote
1answer
26 views

Google Forms/ Sheets

I want have students submit the same Google Form every time they use their pedometer or Fitbit. Then I want the sheet to sum the students steps each time a form is submitted. I don’t want to manually ...
-3
votes
1answer
21 views

How do you get the administrator effect off your computer so nothing is bloced on your computer

Is there anyway to remove the administrator or like overpower it I have look everywhere but it seems like there is no possible way
0
votes
1answer
302 views

How often can a Google form receive responses?

I am designing a test using Google Form. It has a time limit, after which the form will not accept responses. I am concerning that at the very last second, there will be 20 responses submit and Google ...
1
vote
0answers
37 views

Array formula to extract N non blank cell in Row 1-16

I have a google form where team coaches input which players played on a given day. They also input if they were Man of the Match, Yellow/Red Cards Received, and how many Goals they scored. When the ...
-1
votes
1answer
564 views

Unique ID for Google Form that a survey respondent can see

I work for a small NGO that identifies and tracks invasive species. I am trying to solve a issue we have with tracking submitted samples. We have our volunteers and collaborators fill-out and submit a ...
0
votes
1answer
197 views

How do I make a chart read data in a cell that's separated by comma in Google Sheets?

Whenever I create a chart, it reads all the data in a cell all-together, instead of respecting each individual value in a cell. I made a Google Form were people can choose multiple options. The ...
0
votes
1answer
28 views

Google Form Specific Automatic Response

I am aware that I can add a little code to a Google Form's spreadsheet to have it auto respond to a submission. I am curious if there's a way to have a person submit the form and then have it auto ...
0
votes
1answer
25 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 ...
0
votes
1answer
73 views

How do I automatically match text responses to numbers and sum those numbers in Google Sheets/Forms?

I am using a google form to collect responses from students. For each student I would like to match those text responses to specific numbers. Never = 0, Almost Never = 1, etc. Then sum the results for ...
0
votes
1answer
80 views

Script Execution succeeds but reports failure

I'm running this script on a Google Form responses sheet: function autoSort(sheet) { var SORT_COLUMN_INDEX = 10; var ASCENDING = true; var NUMBER_OF_HEADER_ROWS = 1; var range = sheet....
1
vote
1answer
366 views

send more than 100 emails using thrid party apps in gsuite

I am using G Suite app "Form Confirmation Emails" to send a customized mail in response when a user fills the form and submits their details. Everything is going on well but after 100 emails ...
1
vote
1answer
678 views

Adding aliased hyperlinks to Google Forms multiple choice

I've a Google Form which includes a multiple choice list with radio buttons and would like each item to be a hyperlink to an item description. Is it possible? How? If not, is there a workaround?
2
votes
1answer
1k views

How to have a question with type number input in Google Forms?

Is there an easier way to specify a field that only accept numbers? The question I want to ask on my survey is How old are you? The way I did it is to provide a drop-down menu by specifying all the ...
0
votes
1answer
1k views

Why is Google Form stuck on "Updates made after release"?

I was trying to find a way to ask help for Google Forms so I hope this is an acceptable place (official forums > no answer). I am using Google Forms to create quizzes for my students but when I ...
1
vote
1answer
41 views

The script(onSubmmit Trigger) only works in the script editor and doesn't work when the form is actually submitted

This is a follow up of How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission? I want to notify mentors if they're selected by a user on a ...
0
votes
1answer
216 views

How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission?

I want to notify mentors if they're selected by a user on a Google Form. The names of the mentors are in a drop-down menu in the Google Form. This is the form: https://forms.gle/iNuA5nB2J9koKhXt6. I'...

1
2
3 4 5
12