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
1
vote
1
answer
17
views
Trigger script to share calender with new user whenever form updates sheet with a new email address
I have a Google form that allows people to submit their name and email address in order to sign up for a private shared calendar.
The form populates a Google sheet.
I want to automatically add new ...
1
vote
1
answer
109
views
Hide Google Form responses from view in Sheets until a certain condition is met
I'm interested in limiting access to Form responses in Sheets until after I've had a chance to review/approve each submission. I want the response to be viewable to those I've granted view permission ...
1
vote
0
answers
35
views
Combine responses in google forms
I made changes to a google form after I received several responses. They were minor edits like changing "yes" to "Yes" with a capital.
Can I combine the two sets of data so that ...
3
votes
1
answer
637
views
Does Google forms reveal identity of the person filling the form to the person who created the form? [duplicate]
If I fill a Google Form hosted by someone, will my email id/account name be visible to whoever created the form?
If yes, is there a way to hide it?
1
vote
0
answers
34
views
How to simulate Google Form's 'Send' button in Google Apps Script?
When sending a Google Form manually via the "Send" button within a form, you would see that the email addresses are recorded in the "Responses" tab, even if they have not responded ...
0
votes
1
answer
61
views
Can I use responses of a previous google form in a new google form?
I have a Google form that is collecting the Event date, event name, employee name, and his/her assistance in that event(Yes/No). After collecting those answers, we want to use the data to create ...
2
votes
0
answers
327
views
Moving data generated by a Google form from the response tab to another tab
I'm trying to copy data from a Google Sheets tab linked to a Google form into a new tab. I used the function ='Form Responses 1'!B2, then copied the formula in the other cells of the column. But when ...
0
votes
0
answers
20
views
How to edit responses when I'm the only user of the form?
I use a simple google form with just 2 dropdowns each day, to track certain work activities and what the result of each one was. I'm the sole user/owner of this form.
Over time, I have refined the ...
0
votes
0
answers
9
views
How can I configure a Google Form such that it captures responder's google email without having an additional field for email? [duplicate]
I enabled "Collect email addresses" and "Limit to 1 response" in the Settings of a Google Form (see example). This adds an email field for responders to type any email address they ...
0
votes
1
answer
42
views
Add hourly rate to line items based on line item date
Hello, I'm trying to set up a system using google forms and google sheets to keep track and analyse my business's employee's hrs and wage.
My idea is:
Use a simple Google Form to for employees to ...
1
vote
1
answer
15
views
How to create more than one link (or a second different link) out of a filled out google survey?
I am trying to copy the link to an existing questionnaire that is already filled with answers, but want a different link (not the existing link) to that questionnaire with the same answers (without ...
1
vote
1
answer
1k
views
How to recover a question I accidently deleted on a google form yesterday?
I don't know how I accidentally erased on of the questions of my Google Form yesterday and today when I click undo, it doesn't change anything on the form.
My Google form is linked to a Google Sheet.
...
0
votes
1
answer
229
views
How to copy an existing google form filled survey (with answers) to a new google form survey (to create a different link than the original survey)?
I am using google forms to survey the same patient each month.
Is there a way for me to create a different link to the patient's previous survey (and maintaining his/her answers) or to quickly copy ...
0
votes
0
answers
54
views
Hide email in google forms results analytics
I"d like to share my survey result with respondents (im getting the analytics URL from the PRINT option in the ooo dropdown) but the email addresses display. Not private.
Can I hide / obfuscate ...
2
votes
1
answer
102
views
How do I receive the data from Google Form onto Google sheets and allow my students to edit it without other students seeing their work
I am trying to feed data from a Google Form to a Google Sheet. I want to have it separate each student into their sheet. Then, I want to send that information back to the student in a Google Sheet ...
0
votes
1
answer
145
views
How to use Google AccountChooser with prefilled Google Forms?
I'm trying to generate prefilled Goole Forms links, which are sent out to users. They should be able to easily log in with their Google Workspace account and fill the rest of the fields.
Step-by-step ...
0
votes
0
answers
66
views
Google Form data not using my preset conditional formatting [duplicate]
I have just made a Google Form and linked it to a Google Sheets, I already went through and set conditional formatting on the sheet but, when someone fills out the Form the data goes to my Sheet but ...
0
votes
1
answer
40
views
How do I find the unique values of a dataset that has multiple lists in each cell and remove the values I already know are there?
Using Google Forms we have a list of info on what events people are interested in by allowing respondents to check off the boxes to the events they like or add their own events. This column of data ...
1
vote
1
answer
87
views
How do I find the link to share a Raw Google Form (where you can edit questions)?
In the add-collaborator dialog in Google Forms there's a setting "General access - Anyone on the internet with the link". Below that setting, I find a button that gives me a link to the ...
1
vote
1
answer
544
views
How can I delete a blank column from a form responses sheet?
Even though the column has no data, I cannot delete it and instead get the below message:
There was a problem
Cannot delete column with form data. Consider hiding the column instead.
I want to delete ...
1
vote
1
answer
19
views
How do I sort indexed data from a form and maintain list from a range input added afterwards?
I want to sort the responses by names alphabetically Column A (Simple)
I want to apply payment types from a drop down linked to the person's name Column G (Simple)
I want to do both of these things ...
1
vote
0
answers
29
views
How to put images as part of email response after Google form submission?
Is it possible to add a script that allows me to insert an image along with the email body?
So, I saw this code online and implemented it:
// @ts-nocheck
function addAutoNumber() {
var sheet = ...
2
votes
0
answers
82
views
Extracting individual responses from Google Forms using an API [closed]
So I have an old account where I can see all the individual responses since I am the owner of the forms. However, a few weeks ago, my account got disabled and I am unable to recover it. Luckily, as a ...
1
vote
1
answer
21
views
How do I force csv format in a short answer on a Google form?
so I'm trying to make a google form where a person will need to input either one single number or a series of numbers in a short answer, while necessarily using the comma separators between the ...
0
votes
1
answer
32
views
Copying Values immediately based on other cell Values
I am collecting data from Google Form into a Google Sheet, in a Form Responses Sheet it has a column R that cell value changes (as the form responses can be editable), and the values can be Pending, ...
0
votes
1
answer
650
views
Cannot read property '0' of undefined at onFormSubmit
I have created a Google Apps script from a Google Sheet. Data is submitted to the sheet via a form.
I had onFormSubmit(e) working fine and sending a custom email to the form respondent. But now it's ...
0
votes
0
answers
104
views
Show number of responses in Google Form to people filling the form
I would like to know if there is a way to add to the form something like "X people filled the form" for people other than me. The option to show the summary of responses gives too much ...
0
votes
1
answer
660
views
Need a Unique ID to be populated in Google sheets on Google Form submission
Looking for a dynamic unique ID for Google Forms, to populate into Google Sheets Response form. I don't want to use external addons.
Below is a code I found online but can't get it to work - I'm a ...
0
votes
0
answers
11
views
Dynamically add answers [duplicate]
I want to ask questions as the following with Google Forms:
What lessons have you already completed?
(here I give a list of lesson options. Only one option can be selected)
Lesson A
Lesson B
Lesson C
...
2
votes
2
answers
1k
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 ...
0
votes
1
answer
58
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
1
answer
30
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
votes
1
answer
42
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) ...
1
vote
0
answers
196
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 ...
1
vote
1
answer
4k
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 ...
1
vote
1
answer
622
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 ...
1
vote
1
answer
4k
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
1
answer
26
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
0
answers
21
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
1
answer
65
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 ...
2
votes
2
answers
4k
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
1
answer
431
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 the first column is called ...
0
votes
1
answer
57
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. ...
1
vote
0
answers
1k
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
46
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
1
answer
120
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
1
answer
79
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
1
answer
945
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
90
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
1
answer
4k
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 ...