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
2 votes
1 answer
166 views

How to convert text to a number in Google sheets

I've built a form that dumps data to a Google spreadsheet and that data, studio reads it... and turns that into a dashboard.. only problem is the text doesn't convert very well for building a dash ...
user avatar
0 votes
1 answer
457 views

Google Apps Script MailApp Not Sending Email To Script Owner

I've set up a script to take information from a Google Form and email that information to multiple people using Google Apps Script. What it does not do, however, is email the owner of the script. I'...
user avatar
0 votes
1 answer
32 views

Google Sheets Google Forms updates

I have created a Google Form for which collects data from a user. Once the use submits the form I have scripts that copy the data to several other Google sheets and then send an email to the ...
user avatar
-1 votes
1 answer
71 views

Autofill Google Form for Sent Emails

Problem: I need to keep a comms log for emails sent by my teams to other teams. We are running a multiyear project that has over 150 customers. We often escalate and get responses from directors ...
user avatar
0 votes
2 answers
503 views

Arrange Google Form Checkbox Responses into a List

I am collecting scholarship recipients in a Google form. The recipients names are in a checkbox format, as some donors give to multiple students. I need to separate out the names into additional rows, ...
user avatar
  • 1
1 vote
0 answers
64 views

How to find out the Google accounts that have answered a Google Form?

I have created a Google Form, but I have forgotten to add a 'fill in your email address' question. As a result I can not contact the applicants that have already completed the form. Unfortunately I ...
user avatar
0 votes
0 answers
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 ...
user avatar
  • 101
0 votes
1 answer
113 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"...
user avatar
  • 15
0 votes
1 answer
38 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?
user avatar
1 vote
0 answers
28 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 ...
user avatar
  • 11
2 votes
1 answer
712 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 ...
user avatar
4 votes
1 answer
512 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 ...
user avatar
1 vote
0 answers
359 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 ...
user avatar
0 votes
1 answer
127 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 ...
user avatar
  • 101
2 votes
2 answers
41 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)?
user avatar
  • 23
-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?
user avatar
1 vote
0 answers
13 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 ...
user avatar
0 votes
1 answer
53 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), ...
user avatar
  • 103
2 votes
1 answer
1k 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 ...
user avatar
  • 121
1 vote
0 answers
57 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." ...
user avatar
1 vote
0 answers
37 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 ...
user avatar
0 votes
0 answers
226 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 ...
user avatar
0 votes
1 answer
49 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 ...
user avatar
-1 votes
1 answer
24 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. ...
user avatar
  • 1,507
0 votes
1 answer
364 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 ...
user avatar
  • 1
0 votes
0 answers
24 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, ...
user avatar
  • 101
0 votes
1 answer
1k 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 ...
user avatar
  • 1
2 votes
2 answers
3k 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 ...
user avatar
  • 1,507
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 ...
user avatar
0 votes
0 answers
648 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 ...
user avatar
  • 101
1 vote
1 answer
30 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 ...
user avatar
  • 13
-3 votes
1 answer
28 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
user avatar
  • 1
0 votes
1 answer
305 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 ...
user avatar
  • 103
1 vote
0 answers
42 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 ...
user avatar
-1 votes
1 answer
806 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 ...
user avatar
0 votes
1 answer
265 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 ...
user avatar
0 votes
1 answer
30 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 ...
user avatar
  • 101
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 ...
user avatar
0 votes
1 answer
93 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 ...
user avatar
  • 3
0 votes
1 answer
109 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....
user avatar
  • 135
1 vote
1 answer
461 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 ...
user avatar
1 vote
1 answer
876 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?
user avatar
  • 135
2 votes
1 answer
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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
1 vote
1 answer
51 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 ...
user avatar
0 votes
1 answer
324 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'...
user avatar
1 vote
0 answers
37 views

Combine imported JSON with Google Forms data

I've been watching the protests unfold and I see a lot of police brutality from videos and descriptions people have shared online. I found a GitHub where all of this is collected and I want to use ...
user avatar
1 vote
0 answers
33 views

How can I update the list of answers to an upcoming question in Google Forms based off of previous answers in the same form?

The title makes this sound more difficult or complex than it actually is. What I'm trying to accomplish is to build an entire elimination bracket prediction picker through Google Forms. I would have ...
user avatar
  • 33
0 votes
2 answers
244 views

How to see the answers in Google Forms before submitting

How is it possible to see the answers of a questionnaire in Google Forms, before sending it? Could you use the Google Chrome item inspector?
user avatar
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. ...
user avatar
  • 277

1
2
3 4 5
12