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.
516
questions
0
votes
0answers
18 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
43 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 ...
0
votes
0answers
5 views
How do i make google form responses become public ? (all people can see , even without sign in)
Yeah the title is clear , how do i make the result of google form become public ? so anyone , including people that didn't sign in to google , can see the result of the form . I've tried to search in ...
1
vote
1answer
27 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
42 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
57 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 ...
0
votes
0answers
22 views
Regular expression in Google Forms Quiz Answer Key
Google Forms has the ability to create quizzes with an answer key containing possible correct answers. For instance, if you wanted to forgive misspellings, then your answer key could include "...
2
votes
0answers
44 views
How to split cells in multiple columns in Google Sheets, but keep surrounding data?
I am including a sample spreadsheet of what I am trying to achieve.
In the tab “Data” is the data being pulled from a Google form, column G & H both have attendees listed, separated by commas. In ...
1
vote
1answer
16 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
39 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
vote
0answers
21 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 ...
0
votes
0answers
8 views
I want to know how to answer questions with many parts in google form and questions with two answers
I would like to use Google Forms for maths questions with many parts. For example
Add
(a) 23 + 34
(b) 45 + 58
(c) 34 + 68
I have tried it, it does not allow me to go to the next line or write 57, ...
-1
votes
0answers
21 views
Sheets - Aggregate checklist responses from Google forms with “Other” as an option
Edit: Can you please explain why I was downvoted?
(Note the "Other" choice, so my question is not a duplicate unless I overlooked the question where it was asked when searching).
On a Google ...
1
vote
0answers
22 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
57 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
24 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
27 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
0answers
33 views
How to verify Google Forms computer generated certificates?
I just received a certificate via email which is computer generated using Google Forms and has a Certificate ID.
How shall I verify it online?
0
votes
1answer
28 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
23 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
19 views
Is there a way to publicly share the Google Forms result summary (diagrams) via direct link? [duplicate]
I'd like to share the Google Forms response summary that is shown on the Google Forms responses page publicly.
Is there a way to get a url that points to a page where only the summary is shown?
0
votes
0answers
24 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 ...
0
votes
0answers
15 views
How do I convince google form-quiz to apply feedback to future responders?
I have some quizzes for students. They are given there results as soon as they submit. I have added feed back to various wrong answers. This feed back, correctly, gets sent to all students with this ...
1
vote
1answer
46 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
82 views
Return a Google Form for students to correct errors
With online learning being the norm, I have tried to make my students life easier by having them put their answers on a Google Form. On a 4 problem assignment, a student got three correct. I used ...
0
votes
0answers
12 views
Is there any restriction on number of certificates in google forms?
I have published google form,got more than 200 participants.But only 100 got certificate.Is there any restriction on number of certificates?
0
votes
0answers
13 views
I am required to sign-in when I fill out a survey, even when “limit to 1 response” is disabled
I created a survey, but I would like any person to be able to fill that form, even if he/she doesn't have an email address. In my settings, the "Collect email addresses" is ticked (I also tried to ...
0
votes
0answers
16 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 ...
0
votes
1answer
28 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
296 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
0answers
8 views
End form after a section instead of moving to the next section
I've added sections in my Google form. But as one responds to a section, form goes to next section instead of submission. How to change that?
Note - I've already selected Submit Form after every ...
0
votes
0answers
25 views
Using Google Forms and Security Settings
We are thinking to use Google Forms and we need to find out if it can be used for collecting and processing personal information such as Name, Address, Phone, etc. Could someone could make a ...
0
votes
1answer
21 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
17 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
769 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
12 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
28 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
vote
0answers
18 views
Automate Google Groups and Google Forms
I have a Google Groups that only accept invited members. I really want a Google Form where member input their email address and automatically an invitation to the group is sent to their email. As soon ...
-1
votes
1answer
20 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
529 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
69 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
178 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
25 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
17 views
Can I attach a word document to a Google Form so that respondents can DOWNLOAD it (not upload to a google form)
I am creating a Google Form for respondents to use as a method of signing up for a course. I have a document, in word, that I would like to attach to the Google Form with the intention that ...
0
votes
0answers
41 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
0answers
18 views
Google Form Closing Survey for Multiple Questions
On my google form survey, I have 3 yes/no questions to determine the scope of the survey, that if the person answers no to any of them they will be closed out of the survey. Each question is set up ...
0
votes
1answer
59 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
17 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 ...
0
votes
0answers
101 views
Splitting checkbox response into multiple rows on another sheet
I am trying to take a Google Form response page, and change the way the data is displayed. Currently, I have the raw data on the first sheet, and I'm trying to format a second sheet that will split ...
2
votes
2answers
729 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 ...
