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.
527
questions
0
votes
0answers
7 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), ...
0
votes
0answers
9 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 ...
0
votes
0answers
7 views
Google Sheet script will not run on a tab linked to a Google Form
I wrote a script to move a row of data from one sheet (Sheet1) to another (Sheet2) when I type the word Yes in column one. I can get the script to work perfectly when the sheet is not collecting Form ...
1
vote
0answers
15 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
22 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
33 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
14 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
15 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
19 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
81 views
Why I have to sign in to continue to fill out Google Form even though I already signed in from my phone?
When I open the link to the Google Form, it asks me to sign in to continue.
I already signed in on my phone, but why it is asking me to sign in again. when I touch the sign-in button, it just directs ...
0
votes
0answers
22 views
How to convert multiple form responses into easily readible table to use
I have a Google Form that is going to be used by different employees to add stock received. Since there is usually more than 1 item being received, I needed to provide space for them to add multiple ...
0
votes
0answers
16 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
42 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 ...
0
votes
2answers
42 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
56 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
35 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
21 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
18 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
295 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
27 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 ...
0
votes
0answers
7 views
Can i draw location data from images requested through google forms and input that into the forms csv?
I am hoping to produce a form that can create lines of data including geospatial data in order to plot this information on a map. My form requests an image followed by questions to supply data with ...
0
votes
1answer
58 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
83 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 ...
1
vote
1answer
19 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
0answers
26 views
How to associate Google Form response id to user_id of an app
I'm trying to embed a Google Form on my website on which I have users logged in.
What I'm trying to do is match the responses of the form with the id of the users on my app.
What I've tried so far is:
...
0
votes
1answer
20 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
56 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
40 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
78 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
14 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
90 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
145 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
548 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
75 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 "...
1
vote
1answer
23 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
65 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
26 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
11 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
vote
0answers
26 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
66 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
33 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
38 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
37 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
39 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
24 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
25 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
25 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
378 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
903 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 ...
