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.
576
questions
0
votes
1answer
23 views
#REF!, How to Grab the first response of form and ignore the duplicate in google sheets
I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
0
votes
0answers
20 views
Import Data to Google Form
I have a Google Form that is going to ask users a number of questions about a certain service they can choose from a drop down question. Is it possible to import data from a linked Google Sheet into ...
0
votes
0answers
13 views
Google Form which uses a pre built sign in
Been reading a lot about Google Forms which need a Gmail account to fill in.
I'm having another Gmail account only for sharing pictures with club members.
Is there a way to create a form to upload ...
1
vote
1answer
30 views
How do I find where the Google Form is saved?
I've started a contract at a small company to update all their google forms. The forms were set up 5 years ago by the last contractor. Unfortunately this means none knows where the forms are saved on ...
0
votes
1answer
29 views
Merge multiple columns in Google Sheets from questions in Google Forms if all questions are the same
I have a Google Form where I ask for the specific college someone is studying in (i.e. college of engineering, college of business, etc.) and then send them to a specific question where they select an ...
0
votes
0answers
13 views
Creating questions based on answers without multiple sections in Google Forms
I'm trying to ask specific questions based on previous answers using Google Forms. I'm aware that this is possible by creating multiple sections and directing users to specific sections according to ...
0
votes
0answers
17 views
Auto populate comment
Is there a way to have google sheets auto populate a comment based on specific entries in a cell? I am trying to have google sheets auto populate a google form response if certain content is entered ...
0
votes
1answer
37 views
How to format a google sheet that's capturing google form data?
I have a google form which I linked to a google sheet via the "create spreadsheet" button on the form.
Is there a way to format the resulting google sheet for current and future form ...
0
votes
1answer
14 views
Google forms to google sheets to google doc - How to set date to display dd-mmm-yy in sheets and doc?
I'm fairly new to coding, and am trying to get my head around a problem for some work admin. I´m hoping there's a quick and simple fix to this.
So as the title says, we enter info on a google form and ...
1
vote
0answers
8 views
How to build an online quiz that shows a running total of points and allows for partial scores? [closed]
I'm trying to build a simple website that will help people determine if they are eligible for a particular government program. Eligibility is determined by points in various categories (age, ...
0
votes
1answer
12 views
Can I edit choices without affecting the already submitted responses?
So I have made a form for a project. I got some responses, but now I want to translate the whole form into English. The problem is that if I try to edit the choices, the responses stay the same, in ...
1
vote
1answer
65 views
Hide Respondent's Email Address in Google Form
When someone responds to my Google Form, it displays their email address at the top of the form.
I've disabled the option Disable autosave for all respondents in the form settings but the message ...
0
votes
1answer
37 views
Google form save responses in multiple files based on condition on submit
I have this problem:
A Google Form that saves data into one file (spreadsheet)
Multiple users (admins) that access this file (all of them can see all rows)
Let's say first column is called Department ...
0
votes
1answer
22 views
Google Sheets - Multiple if statements with and function
I am trying to build a check in/ check out tracker for my team using google forms and google sheets. The idea is that once Someone submits their response through google form, it comes to google sheet. ...
0
votes
0answers
19 views
i want a free online tool to collect signatures
i want a free online tool to collect data with signatures from my colleagues ( about 200 - 300 ) in a pdf or word
My Needs:
Online tool to collect signatures simultaneously not in queue or stack ...
1
vote
0answers
47 views
How to retrieve Google Form and its 240 responses that have disappeared
Please help me retrieve my Google Form and its 240 responses have disappeared.
Those 240 responses have been collected over 2 years as part of my thesis survey. I could access the form and responses ...
0
votes
1answer
14 views
Importing multiple user responses on a Form to a single row on a Sheet
I have a Google Form containing three linear scale questions. The form collects emails and then a value between 1 and 3 for each question. I need the people who respond to the form to do so biweekly....
1
vote
1answer
10 views
Unpopulate Google Form by default
I made a survey in Google Forms. It consists of several multiple-choice questions. When I preview the form or use the link I would send to participants, some of the answers are already populated/...
0
votes
0answers
13 views
I duplicate a form in Google Form. Why does modifying the new copy overwrite the old one?
I know that there are a button in Google Form to copy questions from other form. I just want to know that when I copy a form and paste it to another place within the Drive, modifying the new one will ...
0
votes
1answer
26 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
98 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
68 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
19 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
11 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
1k 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
776 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
180 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
13 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
2answers
41 views
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
53 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 ...
-1
votes
1answer
340 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
30 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
31 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
26 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
20 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
25 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 ...
1
vote
1answer
825 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
687 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
11 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
104 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
102 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
226 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
26 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
14 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
42 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
2answers
209 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
7 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
63 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
15 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 ...
