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.
568
questions
0
votes
0
answers
20
views
Collecting crowd-sourced data in tabular or spreadsheet format
I'm involved in a citizen-science project, polling recreational anglers about their fishing locations on the ocean (lat-lon), various characteristics at each location (depth, what species they catch, ...
0
votes
1
answer
13
views
Where can we see Google Forms we submit?
Is it possible to view the information or confirm we sent in Google Forms? Assuming the form itself did not have the checkbox that said send me my answers.
- 101
0
votes
1
answer
36
views
RegEx on Google Forms: How to make Case Insensitive work?
I have been wondering, how to use case insensitive regular expression for a response validation in a form where there are different possible answers?
I have tried:
(name1|name2|name3)
and it really ...
- 45
0
votes
0
answers
26
views
Why can I not upload any document to Google Form?
When I try to upload pdf or MS word etc. to Google Form by clicking the upload file button, it shows only a white page as in picture but it does not show further options to select the document. Please ...
- 1
0
votes
1
answer
19
views
Formula for Daily Cash Balance Sheet
I have created a Google Form for cashiers to balance out their cash drawers at the end of each day. Currently I have the form set so that they only have to count the amount of each coin/bill and not ...
0
votes
0
answers
18
views
Is it possible to generate response url of google forms without editing permissions?
I know, that there is a getEditResponseUrl() function, but it generates URL with editing permission.
Is there any way to have this URL without editing permission, just response?
0
votes
1
answer
22
views
Google Forms corresponding to a pre-set date on Sheets instead of being added consecutively
Is it possible to have Google Form data inputs being added not one after the other but corresponding with the Date that is pre-filled on the response form?
Here you can see how the data is currently ...
- 1
0
votes
1
answer
28
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
0
answers
42
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 ...
- 101
0
votes
0
answers
17
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
1
answer
206
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 ...
- 11
0
votes
1
answer
92
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
0
answers
18
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
0
answers
22
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
1
answer
150
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 ...
- 1
0
votes
1
answer
15
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 ...
- 9
1
vote
0
answers
11
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, ...
- 11
0
votes
1
answer
13
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
1
vote
2
answers
413
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 ...
- 1,918
0
votes
1
answer
71
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 ...
- 103
0
votes
1
answer
29
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. ...
- 3
0
votes
0
answers
23
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
0
answers
245
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
1
answer
16
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
1
vote
1
answer
11
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/...
- 113
0
votes
0
answers
18
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 ...
- 740
0
votes
1
answer
28
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 ...
- 1
0
votes
1
answer
246
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
1
answer
73
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
0
answers
41
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?
- 479
0
votes
0
answers
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 ...
- 1
0
votes
1
answer
2k
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 ...
- 541
0
votes
1
answer
1k
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
3
answers
474
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
0
answers
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
2
answers
42
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
1
answer
168
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
1
answer
647
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
1
answer
158
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 ...
- 101
0
votes
2
answers
50
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
1
answer
40
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
1
answer
21
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 ...
- 15
1
vote
1
answer
1k
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?
- 11
-1
votes
1
answer
2k
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
1
answer
283
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
2
votes
1
answer
138
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
1
answer
394
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
1
answer
32
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 ...
- 1
-1
votes
1
answer
63
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
2
answers
421
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, ...
- 1