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.
565
questions
0
votes
1answer
17 views
Auto deleting columns when the field is blank
I have created a form that have multiple sections, skipping sections based upon an answer. I have then linked a Google Sheet to this Google Form to collect responses. These responses are auto filtered ...
0
votes
1answer
27 views
App script sheets to update google form dropdown
I'm trying to create a registration form that can be imbedded into our club website for users to sign up to our sessions with.
I need the form to be updated via the back end database which i'll add ...
1
vote
1answer
53 views
Separating multiple section inputs into multiple lines of data (I can't get it to work even with the other threat help that is there already)
Hello Google Masterminds,
I come to you since I have followed almost every single youtube video and every single thread here and I been working with this freaking form for the past 3 weeks and have ...
0
votes
0answers
14 views
How to show Google Forms linear scale labels in results page?
Apparently, linear scale labels in Google Forms results are hidden, vanishing readability. Is there any trick to show labels in results, which would be useless without a label?
0
votes
0answers
9 views
How to create option to add another registration on Google Forms
I'm trying to make a basketball competition registration form.
So you can register as a team or individual (multiple choice)
If you register as an individual, your brought to another section for your ...
0
votes
1answer
60 views
Use comma as decimal separator in form based on Google Sheets?
I have seen this question but my question is different. My sheet uses comma as decimal separator but when I publish it as a form, dot is used as the decimal separator.
How do I change decimal ...
0
votes
1answer
67 views
Google Forms: Disable the “back” option on a multi-section quiz?
I would like to create a quiz whereby respondents watch video and answer questions about it. It is important that the respondents only watch the video once.
In order to do this, I have split the form ...
0
votes
3answers
39 views
Add a new row each time a new response is added to the Google Form
I have a Google Sheet linked to a Google Form. In the second page I added a formula to clean up the data, since one of the questions allows to chose multiple options and it results in a column with ...
0
votes
0answers
11 views
Google Forms multiple choice quiz ( mathematical equation in feedback section)
Is there a way for me to put mathematical equation in the feedback(Answer key) of a multiple choice Google Form.
Side not, can I change the score from appearing on the top left corner.
0
votes
1answer
29 views
Google Forms: Get two different type of answers to an answer
How can I get Google Forms to allow me to have two different type of answers to one question? Answers are to be related between them so when working results, I can get the grades of each group member.
...
0
votes
1answer
25 views
Requiring an exact number of checkboxes ticked based on previous multiple choice response in Google Forms
I have a multiple checkbox question that needs to have exactly the same number of ticked checkboxes as given in a multiple choice question. So if a user chooses the option 2 in the multiple choice ...
0
votes
1answer
31 views
How to add 1 question in Google Forms which takes multiple inputs from the user and stores in a single column in Google sheets
I am struggling to create a custom question in Google forms which can ask the user for Multiple inputs or Short texts.
For example If I ask a question to a shopkeeper: "Name all the vegetables ...
0
votes
1answer
18 views
Shuffling questions in only one section of a Google Form
I am creating this Google Form with two sections. One takes the student information; Reg. No., Name, Class etc., and the other section contains the subject-related questions which I need to have ...
0
votes
2answers
25 views
Multiple choice response in rows without repeating other entries
We have a multiple choice question in our Google Form.
We use some other spreadsheets to re-organize questions from the Google Form response sheets.
What we need is having multiple choice responses ...
0
votes
1answer
21 views
How to give access of Response sheet linked with Google Form to only those who filled form?
Let's say I'm collecting Name and Email (using Collect Emails setting), I wish to allow view-access to the Google Sheets Response Sheet linked to that form with only those who put their email id. ...
-1
votes
1answer
19 views
Updating a cell when a new form is submitted
I am trying to pull scores from one google sheet to another, and I want this information to update when a new form is submitted by the same person.
Score page
Summary Page
Link to sheets
Link to ...
0
votes
0answers
21 views
How can I show random IDs to a Google form respondents? [duplicate]
I want to collect contact details for invitees using a Google form created for this purpose. I want the respondents who give me their contact details to also input an appointment entry in a public ...
0
votes
1answer
55 views
How can I merge responses of two Google Form identical to each other but in two different languages
I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
-1
votes
1answer
18 views
How to create a sort function that would automatically sort new incoming data [duplicate]
I linked a form to google spreadsheets, so now all the responses on that form are linked, and they automatically are added as plain data in the spreadsheet. One of the columns is date-data, on column ...
0
votes
0answers
8 views
Google Forms is hiding responses under “Other” in the Summary tab
I am running a poll on Google Forms with many options, and over 93 responses are hidden in this "Other" category on the summary page. There is no "Other" option on the multi-select ...
0
votes
1answer
44 views
When uploading a file on Google Forms, I would like the file uploads to go into a custom folder based on the form response (their name)
Ex. someone submitting the form with a file upload and on form submit it creates a custom folder based on their form response (their name) on Google Drive with their submission in it.
Using this ...
1
vote
1answer
74 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 ...
0
votes
1answer
60 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'...
0
votes
1answer
18 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 ...
0
votes
0answers
13 views
While using INDEX and REGEXEXTRACT, how can I return a blank cell instead of 0 [duplicate]
While using INDEX and REGEXEXTRACT, how can I change this formula to return a blank cell (instead of 0) when all of the cells in that section are blank?
-1
votes
1answer
24 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 ...
0
votes
1answer
27 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, ...
0
votes
0answers
5 views
Brand new spreadsheet from a Google Form when one already exists?
Once I've created a spreadsheet from a Google Form, can I dump that spreadsheet (without losing the responses to the form) and create a NEW spreadsheet using the existing responses?
1
vote
0answers
57 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 ...
0
votes
0answers
13 views
Glitch with Google Survey ( forms )
I have received 29 of 50 great responses to my Survey on Google. Asked for names, so that was great until today. When I went in just now, all surveys have the same ( and only one ) name, of one of my ...
0
votes
0answers
36 views
Not being able to see my students’ answers for a question that I edited while the exam
I edited a word which was part of a question while my students taking the exam in Google Forms. After my students submitted their answers, I realized that Google considers that question wrong for all ...
0
votes
0answers
25 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 ...
0
votes
1answer
58 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"...
0
votes
1answer
31 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?
0
votes
0answers
19 views
How do I update a single Google Sheet tab with information from two tabs on the same sheet when a form is submitted?
I have two forms that contain similar information. One asks for more in-depth information that is needed sometimes from external customers while the internal one doesn't need as much information.
I ...
1
vote
0answers
26 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 ...
2
votes
1answer
370 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 ...
0
votes
0answers
21 views
Overwrite Google Form responses with Data input tab
Due to Covid we have to do registration differently. We have a form that collects all the requests. The counselor meets and pulls up their ID on a search tab. If there is a mistake the counselors ...
0
votes
0answers
21 views
Google Forms Overlay Responses
I'm trying to capture a few information about our business partners. Four of the questions will be used to print a contact card. Is it possible for Google Forms to display the 4 responses that ...
4
votes
1answer
218 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 ...
1
vote
0answers
76 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 ...
0
votes
1answer
15 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 ...
0
votes
0answers
221 views
Refresh after submitting Google Form, back to the editing page again, can I prove I didn't change anything after the deadline?
I submitted a response, and the professor has allowed us to edit after submitting. Several minutes after the deadline, when I try to close the web page, I accidentally refreshed it, and I got back to ...
0
votes
0answers
12 views
Google Sheets email notification
I have a spreadsheet that is being populated by a Google Form, I need to set up so that an email notification is sent if the word “other” is imputed into the sheet, any help?
0
votes
0answers
49 views
Split choice grid or multiple choices in several rows on sheet
I have a form that I want to work as follows:
The person will answer a question (text box) with an ID and another question (which can be a choice of multiple answers or a multiple choice grid).
What I ...
2
votes
2answers
38 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)?
0
votes
1answer
29 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?
0
votes
0answers
8 views
Edit URL not writing back to sheet
I have created a Google Form which populates a sheet, and an Edit URL script to allow changes to be made by the user via the sheet preview. This is all working for most of the form. Except when an ...
0
votes
0answers
16 views
Google Forms - using as feedback form for multiple schools
I am sending a link for a Google Form in an email, asking for course feedback.
I send the same link to multiple schools.
When I get responses from the schools, I like to share the student responses ...
1
vote
0answers
8 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 ...
