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
1 vote
0 answers
59 views

Can I add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form?

I need to add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form. I was able to add the function trigger in scripts but I need to add the ...
user avatar
0 votes
1 answer
67 views

Add fields and update array and scripts

I want to add some questions to my Google form but my response sheet has a script and an array, which do not like that. Here is what it should look like: The URL is the link for the form. Here is ...
user avatar
0 votes
1 answer
44 views

How can I make Google Forms answer sheet aware of data from other sources?

My case is that I have a Google Form that populates a sheet. But I also have a other sources such as a Bot, that is able to add a new row. The bot always adds the new row at the very end of the sheet (...
user avatar
  • 103
0 votes
0 answers
27 views

It it possible for a google forms-quiz to display results immediately? [duplicate]

I have some quizzes for students. I want them to the the results immediately. I can configure it so that students can see there results immediately after submitting. However it would be good if it ...
user avatar
1 vote
1 answer
2k views

How to allow users to enter only text in short questions in Google Form

I want users to enter only text in short questions in a Google Form. Like, if I ask user his name then he is allowed to enter only text. No digits or special characters.
user avatar
0 votes
0 answers
54 views

Populating Google docs from multiple templates depending on Google forms responses

I have the script below to create Google docs from a template when a form response is submitted. But this scripts uses only one template. What I want is to create different docs depending on the ...
user avatar
-1 votes
1 answer
637 views

not working form submit Event Object

I have a Google form which I use to populate a Google docs from a certain template whenever a new response is submitted. In order to achieve this, I have written this script, but it is not working and ...
user avatar
0 votes
0 answers
2k views

Google form blocked?

I get this weird error trying to access a form URL: Our systems have detected unusual traffic from your computer network. Please try your request again later. Why did this happen? IP address:...
user avatar
  • 478
0 votes
1 answer
115 views

GOOGLE Forms and Mapping Location

Can you use Google Form to collect information about the activities of users and drawing a map showing a radius where these activities occurred? Like show me a map that shows all the stores under ...
user avatar
0 votes
1 answer
71 views

How to add multiple conditions onto a query

so this is completely experimental and not for a class. If anything, I'm doing this because I don't really have class right now. I am self-taught and very inexperienced when it comes to anything code ...
user avatar
1 vote
1 answer
4k views

TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

This is what I have written in Script editor so as to auto-apply a formula to a new added row when a new response is submitted on the Google Forms linked to my spreadsheet. First I was using ...
user avatar
0 votes
1 answer
170 views

Google Forms - Removing email collection renders invisible required field

I just spent some time creating a form, and while brushing over the final details, I tried activating the email field "Collect email addresses in settings -> general" Then I deactivated it and now ...
user avatar
0 votes
1 answer
102 views

Google form adding more than one row every time

I know that when a new response is submitted on Google form, a new row is auto-added to the linked spreadsheet. I use several onformsubmit triggers for my form and linked spreadsheet. But I do not ...
user avatar
-1 votes
1 answer
67 views

How to get the text from the Other field in a google forms question to be used in the visualization?

On a check all that apply (checkbox type) question, some respondents used the options I created and othere people used the other box. The issue is that for the people who used the other box, the data ...
user avatar
  • 1
0 votes
1 answer
3k views

Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file "Code")

when I am running the script below I am getting the message - Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file "Code") it has been working ...
user avatar
0 votes
0 answers
208 views

how to apply changes to all dropdown questions in forms

I am using a script to update dropdowns in a Google form from a spreadsheet. There is a Questions#1 worksheet on which there are all questions that should be updated automatically in the form when any ...
user avatar
1 vote
1 answer
3k views

TypeError: Cannot read property 'getId' of undefined

I have written this script to my spreadsheet which is connected to a google form too, and connected dropdown function to a button on spreadsheet so as be easier to run the script. first it worked well ...
user avatar
0 votes
1 answer
85 views

How to use Lookup formula for new rows in Google Sheets submitted via Google Form?

I am using the following Lookup formula in a Google Sheet: =LOOKUP(F2, AreaCodes) I need that formula to be triggered when new rows are added via a Google Form. I'm guessing the solution has ...
user avatar
0 votes
0 answers
130 views

How can I SUMIF a row, but have the formula automatically applied to all new rows below it in Google Sheets?

I've made an inventory tracking spreadsheet that gets raw data from Google Forms. Forms inputs data into Sheets in a less than ideal way, but there's nothing I can do about that, so I'm stuck post-...
user avatar
0 votes
1 answer
975 views

Form that only allow for one person to choose each option [closed]

I need to create a form where people can select one of the options made available, and, once they do, that option becomes unavailable to anyone signing in afterwards. (Or where I can define the amount ...
user avatar
  • 109
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 ...
user avatar
2 votes
2 answers
19k views

I lost my response in Google Form after accidentally deleted the questions

I created a google form this afternoon and there were lots of response that I received. And then I accidentally deleted all of the questions and I thought I can simply edited it back. when I edited it ...
user avatar
-1 votes
1 answer
3k views

Get email address in from Google Forms in script

I'm creating a Google Form where guests can log in and an email will be automatically be sent to the person that submits their form. They are not required to log into Google as this will be running on ...
user avatar
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 ...
user avatar
  • 13
1 vote
2 answers
3k views

Embed just the google forms analytics page

I made a test google form and I have embedded it successfully... How do I embed just the stats/ analytics page? The page that allows people to see a pie chart of the collective survey results... link:...
user avatar
  • 23
1 vote
1 answer
80 views

How can I populate and submit a Google form using info from Google Sheets? [duplicate]

I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
user avatar
  • 11
0 votes
1 answer
113 views

applying a formula to the data from google forms

I have a google spreadsheet which is connected to a google forms I wanted one formula to be automatically copied to the new lines(Column R) when google form response is submitted the spread sheet: ...
user avatar
-1 votes
1 answer
769 views

Google form where all answer options calculate to 100%?

Put the % of how much you spend of your salary in the following categories: [Airtravel, Rail transport, Taxi, Personal car, Uber ...., Other] I want to format the question in Google Forms such that: ...
user avatar
3 votes
3 answers
5k views

Google Forms quiz submit ONLY when ALL correct

I would like to use Google Forms to create a simple 5 question multiple choice quiz. When the user has selected their answers and clicked Submit I would like to display immediate feedback on the same ...
user avatar
  • 131
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?
user avatar
0 votes
3 answers
3k views

How can i add search bar above dropdown menu on Google Forms?

There are around 550+ items on the dropdown list, is it possible to filter them out?
user avatar
4 votes
4 answers
1k views

How to prevent Google Sheets from reformating input from Google Forms?

I need to create Google Form where users can submit different data. Problem is that some of them use comma and others use dots as decimal separator and my Form should handle them both. Problem is, it ...
user avatar
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 ...
user avatar
  • 9
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 ...
user avatar
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 ...
user avatar
  • 1
0 votes
1 answer
3k views

How to Redirect to another Website upon Google Form Submission?

I have a Google Form which is backed by a Google Apps Script with an onFormSubmit function, which fires when the Form is submitted. The next thing I want to do is, after the Form data processing is ...
user avatar
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. ...
user avatar
1 vote
1 answer
84 views

How to display of results in Google Forms after deleting some response?

I have collected some data using Google Form that are visualized by Google Form in histogram and pie chart. Now I want to circulate URL of same Google Form. But I want it should show the visualization ...
user avatar
  • 11
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 ...
user avatar
3 votes
1 answer
2k views

How to check if the values of two cells exist in two columns of another sheet

I am trying to make a class attendance system where the student checks in by submitting her name into google forms. The final result will be displayed in Google sheets by marking a check box after ...
user avatar
  • 33
2 votes
1 answer
70 views

I was sent a google form (link) and can see the senders answers

I was just sent a link by a colleague to a google form. I can see that they ran a test of the form with "dummy' answers. Can the sender change this so that others don't see their responses in the form?...
user avatar
  • 21
1 vote
1 answer
28 views

What happens when multiple people edit a multi-page form?

Imagine I have a multi page Google form and the "edit after submit" option is enabled. Imagine we have a 3 page form with the following text questions: Q1 Q2 Q3 The form is submitted with blank ...
user avatar
  • 30k
0 votes
1 answer
6k views

in a Google Form, can I change or remove a question safely after receiving responses/Submissions?

After I create my Google Form and start to receive submissions, can I change or remove a question or will it break the data? I know it's very picky with having to re-link the spreadsheet if I link ...
user avatar
  • 111
-1 votes
1 answer
733 views

Don't allow same answer in Google Form

So I have a problem where I want to use google form for data collection for few different teams. At google form the first question is to type in the item number (6 symbols) and there is no duplicates ...
user avatar
0 votes
2 answers
82 views

Will working with an active Google Form responses sheet mess anything up?

I'd like to sort rows and remove duplicates while the form is live and the responses sheet is receiving incoming responses. Will my working on the sheet while a response is coming in cause any ...
user avatar
  • 141
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 ...
user avatar
  • 121
0 votes
1 answer
79 views

Import Form data into a sheet

I am trying to accomplish something that may not be possible. My work rents equipment to multiple companies and my boss wants me to setup a "database" of rental equipment and where its located and any ...
user avatar
0 votes
1 answer
92 views

auto-fill for new values in google spreadsheets

I have a google spreadsheet that connected to the google form, this form has the name, family name, email address and... questions. I want my spreadsheet takes name and family name and combine them ...
user avatar
1 vote
0 answers
177 views

How to change font style for Description, Response and other fields?

My research shows that old version of Google forms allowed to set different font styles for EACH type of field (question Title, Description, Response etc.). It used to be possible to switch to the ...
user avatar
  • 11
2 votes
1 answer
49 views

Using IF statements to apply an email address depending on teacher name

I am attempting to create a sign in sheet for students when they are sent to a "calming" room. The idea is that when they reach the room, they enter their name and select their teacher's name from a ...
user avatar

1 2
3
4 5
12