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
0answers
32 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 ...
0
votes
2answers
197 views

How to see the answer in Google Forms

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?
0
votes
1answer
118 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. ...
1
vote
0answers
53 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 ...
0
votes
1answer
48 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 ...
0
votes
1answer
40 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 (...
0
votes
0answers
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 ...
1
vote
1answer
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.
0
votes
0answers
49 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 ...
-1
votes
1answer
436 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 ...
0
votes
0answers
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:...
0
votes
1answer
97 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 ...
0
votes
1answer
55 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 ...
1
vote
1answer
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 ...
0
votes
1answer
55 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 ...
0
votes
1answer
92 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 ...
-1
votes
1answer
56 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 ...
0
votes
1answer
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 ...
0
votes
0answers
178 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 ...
0
votes
1answer
2k 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 ...
0
votes
1answer
76 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 ...
0
votes
0answers
117 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-...
0
votes
1answer
746 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 ...
1
vote
1answer
156 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 ...
2
votes
2answers
17k 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 ...
-1
votes
1answer
2k 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 ...
0
votes
1answer
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 ...
1
vote
2answers
2k 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:...
1
vote
1answer
75 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 ...
0
votes
1answer
110 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: ...
-1
votes
1answer
668 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: ...
3
votes
3answers
4k 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 ...
0
votes
1answer
8k 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
3answers
2k 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?
4
votes
4answers
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 ...
0
votes
1answer
277 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 ...
0
votes
1answer
53 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
1answer
35 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
1answer
2k 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 ...
0
votes
1answer
44 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. ...
1
vote
1answer
49 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 ...
2
votes
1answer
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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
62 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?...
1
vote
1answer
25 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 ...
0
votes
1answer
5k 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 ...
-1
votes
1answer
569 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 ...
0
votes
2answers
76 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 ...
2
votes
1answer
619 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 ...
0
votes
1answer
74 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 ...

1 2
3
4 5
12