Skip to main content

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.

Filter by
Sorted by
Tagged with
1 vote
1 answer
41 views

Is there a way to undo all the sorting and editing done on a google form response spreadsheet?

My colleague and I did a survey on google form. Once the data started coming in, she started sorting and editing the data directly on the response spreadsheet. This led to the data getting mixed up. I ...
ing the inked's user avatar
1 vote
0 answers
14 views

Google Forms Issue - Responses [closed]

I have a Google Form for my techs on the road, in which they select their client's site and fill in their report. My Form's question #1 is a Drop Down list of all my clients. When I look at the ...
Simon's user avatar
  • 11
0 votes
1 answer
18 views

How can I manually edit empty cells that are within an array returned by an ArrayFormula function?

We have a Google Form whose responses are stored in Google Sheets, and that data is used by formulas in other sheets. For example, one sheet uses the following formula to return form response data ...
Dave's user avatar
  • 1
0 votes
0 answers
29 views

Can the owner of a Google form see my email if I submit it?

Can the owner of a Google form see my email if I submit it? I want to know if the creator/owner of a Google form that I submitted can see my email address or not.
Ryan K Reynolds's user avatar
1 vote
1 answer
18 views

How do I share my Google Form document with other collaborators with only the link?

Is there a way to share my Google Forms document with other editors that do not have a Google account by sending them a collaboration link? That is, without inviting them to the document via a pre-...
Tim Götz's user avatar
-1 votes
1 answer
66 views

How can you open a Google Form that is closed without the owner account?

I was too late for a statistics quiz. How can you open a Google Form that is closed without the owner account?
Gum Cum's user avatar
0 votes
1 answer
53 views

How to get values from sheet of Google Form responses to main sheet?

In Google Sheets I have spreadsheet containing two sheets. The first, 'main sheet', contains formulas that reference data stored in the second sheet, 'Form Responses 2', that stores Google Form ...
Fysyx's user avatar
  • 3
0 votes
1 answer
89 views

Google Forms/Sheets - How to recover ownership access for a form and sheet that has no Owners, only Editors?

I have inherited a Google Form with its corresponding Sheet, for which the original owner is unknown. In the list of collaborators, there is no owner. Everyone at the company who has access is only an ...
BadHorsie's user avatar
  • 1,461
1 vote
0 answers
63 views

Google forms not loading in every browser that I`ve used

I've tried every solution by google regarding this problem (clearing web data, disable extensions and so on). Still I cannot access google forms and I get the following message below: I've also tried ...
John Doe's user avatar
  • 111
-1 votes
1 answer
39 views

Google Form validation from a Google Sheet for Inventory

I'm trying to make an inventory system and am struggling with using a Google form to check out inventory. I would like the form to validate that the products being removed from inventory are actually ...
Lucasheythere's user avatar
0 votes
0 answers
69 views

How do I create a google form that, upon submission, creates a unique ID and then emails it back to that same person who submitted the form?

To be more specific, I need to: Have someone fill out a basic Google Form that will include an email field Have the info they put into the form entered into a Google Sheet with a unique ID for each ...
Danny's user avatar
  • 1
1 vote
1 answer
81 views

How can I format phone numbers from a Google Form in Google Sheets?

I have a Google Form which sends responses to a Google spreadsheet. One of the form inputs is a phone number. In Google Sheets, I have formatted the column containing the phone numbers as "###-###...
Matthew's user avatar
  • 11
3 votes
2 answers
650 views

Can multiple forms store their results in the same spreadsheet? [duplicate]

I have multiple Google forms with matching questions. Is it possible to keep the forms separate but see their results in the same Google spreadsheet?
Jon Ferson's user avatar
1 vote
1 answer
28 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 ...
knawhatimean's user avatar
1 vote
1 answer
503 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 ...
Dawn Campbell's user avatar
1 vote
0 answers
44 views

Combine responses in google forms [duplicate]

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 ...
user316821's user avatar
3 votes
1 answer
2k 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?
user93353's user avatar
  • 173
1 vote
0 answers
78 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 ...
pnoytechie's user avatar
-1 votes
1 answer
562 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 ...
Javi's user avatar
  • 1
2 votes
0 answers
352 views

Moving data generated by a Google form from the response tab to another tab [duplicate]

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 ...
Jeff's user avatar
  • 21
0 votes
0 answers
26 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 ...
JVC's user avatar
  • 1,246
1 vote
1 answer
54 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 ...
Eftihis's user avatar
  • 11
1 vote
1 answer
17 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 ...
mellamoleon's user avatar
1 vote
1 answer
3k 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. ...
mellamoleon's user avatar
0 votes
1 answer
473 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 ...
mellamoleon's user avatar
2 votes
1 answer
114 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 ...
Cynthia Bell's user avatar
0 votes
1 answer
220 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 ...
Olli's user avatar
  • 11
0 votes
0 answers
158 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 ...
kieran's user avatar
  • 1
0 votes
2 answers
66 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 ...
Novo33's user avatar
  • 1
1 vote
1 answer
553 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 ...
Christian's user avatar
  • 1,505
1 vote
1 answer
729 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 ...
Miltos's user avatar
  • 11
1 vote
1 answer
21 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 ...
Sheetsrookie's user avatar
1 vote
0 answers
52 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 = ...
Hael's user avatar
  • 11
2 votes
0 answers
101 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 ...
sam's user avatar
  • 21
1 vote
1 answer
23 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 ...
Xuca's user avatar
  • 11
0 votes
1 answer
34 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, ...
Farhan Ahmed's user avatar
0 votes
1 answer
915 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 ...
Daniel Westergren's user avatar
0 votes
0 answers
246 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 ...
yael's user avatar
  • 1
0 votes
1 answer
951 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 ...
Jeffery Price's user avatar
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 ...
uzer123's user avatar
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 ...
JDD's user avatar
  • 65
0 votes
1 answer
99 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 ...
crystal turner's user avatar
0 votes
1 answer
49 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 ...
George's user avatar
  • 1
-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) ...
sulthandk's user avatar
1 vote
0 answers
208 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 ...
Ant's user avatar
  • 121
1 vote
1 answer
7k 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 ...
MTwem's user avatar
  • 11
1 vote
1 answer
762 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 ...
Peter Bob's user avatar
2 votes
1 answer
7k 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 ...
Brandon's user avatar
  • 21
0 votes
1 answer
32 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 ...
Chris 's user avatar
1 vote
0 answers
43 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, ...
dcorks's user avatar
  • 11

1
2 3 4 5
12