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
0
votes
1answer
31 views

Add fields and update array and scripts

I want to add some questions to my Google form but my response sheet has a script and an array, which do not like that. Here is what it should look like: The URL is the link for the form. Here is ...
0
votes
2answers
232 views

How can i add search bar above dropdown menu on Google Forms?

There are around 550+ items on the dropdown list, is it possible to filter them out?
2
votes
2answers
4k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
-1
votes
0answers
10 views

I need a platform that lets users add data anonymously

To specify, I'm looking for a platform that publicly allows anyone to anonymously enter their data without the data being revealed or tampered by another anonymous user. Imagine Google sheets. It let'...
1
vote
0answers
15 views

Array formula to extract N non blank cell in Row 1-16

I have a google form where team coaches input which players played on a given day. They also input if they were Man of the Match, Yellow/Red Cards Received, and how many Goals they scored. When the ...
0
votes
0answers
7 views

Can i draw location data from images requested through google forms and input that into the forms csv?

I am hoping to produce a form that can create lines of data including geospatial data in order to plot this information on a map. My form requests an image followed by questions to supply data with ...
0
votes
1answer
14 views

Unique ID for Google Form that a survey respondent can see

I work for a small NGO that identifies and tracks invasive species. I am trying to solve a issue we have with tracking submitted samples. We have our volunteers and collaborators fill-out and submit a ...
0
votes
1answer
58 views

How do I make a chart read data in a cell that's separated by comma in Google Sheets?

Whenever I create a chart, it reads all the data in a cell all-together, instead of respecting each individual value in a cell. I made a Google Form were people can choose multiple options. The ...
1
vote
1answer
1k views

Lost responses from Google Forms

I have updated my form with some responses recorded. After deleting one question section, the responses for that question disappeared. Can I still get to them?
0
votes
0answers
345 views

Return a Google Form for students to correct errors

With online learning being the norm, I have tried to make my students life easier by having them put their answers on a Google Form. On a 4 problem assignment, a student got three correct. I used ...
0
votes
1answer
479 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
1
vote
1answer
13 views

Google Form Specific Automatic Response

I am aware that I can add a little code to a Google Form's spreadsheet to have it auto respond to a submission. I am curious if there's a way to have a person submit the form and then have it auto ...
0
votes
1answer
16 views

Add a question per checked multiple choice answer

Say I have the following question: What are your favorite things (multiple choice)? [ ] Thing A [x] Thing B [ ] Thing C [x] Thing D I'd like to dynamically generate the following sections with ...
0
votes
1answer
29 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
0
votes
0answers
14 views

How to associate Google Form response id to user_id of an app

I'm trying to embed a Google Form on my website on which I have users logged in. What I'm trying to do is match the responses of the form with the id of the users on my app. What I've tried so far is: ...
2
votes
3answers
7k views

Is it possible to recover deleted responses from Google Forms?

Here is the context of this question. We used Google Forms for an election of 6 people. I want to know if it is possible to delete individual responses and then recover all responses (deleted and not ...
2
votes
4answers
5k views

How to delete email addresses from Google Forms reminder list?

Google Forms sorts respondents into those who replied and those who need reminding. I sent a form to 100+ people and now find the list has diminished to 85. I no longer need a response from certain ...
1
vote
1answer
3k views

Show quiz result on the same page in Google Forms

Google Forms allows to create questionnaire and make it like a quiz in order to get score to correct answers. I created a quiz in Google Forms but after submitting answers to all questions it shows a ...
2
votes
1answer
484 views

Google Form from Facebook Group

I have a a google form that I would like to only make available to members of a closed facebook group. The form is anonymous and members are free to use it as often as they would like. The problem is ...
0
votes
1answer
42 views

How to save question before going back to the same question in Google Forms?

I need to make a questionnaire. The idea of the questionnaire is that it asks the user first two different questions (name and country) and after the two questions it asks that if the user wants to ...
0
votes
1answer
68 views

Need to trigger form submit when data is already populated in Google Sheet from another source

We have tried many thing to do a job basically we have a Google Sheet to collect information from Google Form once the form is submitted the data get inserted into the sheet and document studio start ...
1
vote
1answer
559 views

Google Forms to spreadsheet edit responses and new responses on the top

I've created a Google form and I want to be able to drag the rows into categories below it, but I want the new responses to always show up at the top. Instead, it follows the previous row. For ...
1
vote
1answer
534 views

Linking multiple script created forms to 1 sheet in pre-existing spreadsheet

I work in manufacturing. I have created a Google form for our leadership safety audits which requires unique information (name(s), area being audited, and date) and also includes 25 multiple choice ...
0
votes
1answer
392 views

How to disable new row when Google Form collects responses for Google Sheet?

When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I ...
0
votes
1answer
1k views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...
0
votes
2answers
7k views

How can I create a timer in a survey in Google Forms?

I need to make a survey form where each page of the survey is timed. Once the timer runs out, the form should automatically advance to the next page. Is this possible using Google Forms?
0
votes
1answer
17 views

How to add multiple conditions onto a query

so this is completely experimental and not for a class. If anything, I'm doing this because I don't really have class right now. I am self-taught and very inexperienced when it comes to anything code ...
0
votes
1answer
75 views

How to calculate hours per date

I am trying to use A Google Sheet generated by Google Forms to track total attendance time in lab for a robotics team. I have created a form with the following questions: Checking in or Checking out ...
0
votes
1answer
12 views

Google Forms - Removing email collection renders invisible required field

I just spent some time creating a form, and while brushing over the final details, I tried activating the email field "Collect email addresses in settings -> general" Then I deactivated it and now ...
0
votes
1answer
52 views

How do I automatically match text responses to numbers and sum those numbers in Google Sheets/Forms?

I am using a google form to collect responses from students. For each student I would like to match those text responses to specific numbers. Never = 0, Almost Never = 1, etc. Then sum the results for ...
1
vote
1answer
3k views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
1
vote
2answers
65 views

Google Form - Need questions related to initial questions?

I'm trying to make a google form that my friends and I can use to enter our board game scores into an excel sheet, which then calculates our overall and per game scores... Does anyone know how/if I ...
0
votes
1answer
40 views

Google Form reply to form respondents from a @domain email

I'm using Google Forms to create a survey but the auto response email has my personal email account in it. How can I change it so the from: is, for instance company@company.com instead of company@...
0
votes
1answer
28 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
2
votes
2answers
1k views

I lost my response in Google Form after accidentally deleted the questions

I created a google form this afternoon and there were lots of response that I received. And then I accidentally deleted all of the questions and I thought I can simply edited it back. when I edited it ...
0
votes
1answer
185 views

Google Forms Quiz Response Sheet

I have added a couple of columns to the Google Sheet Responses for a quiz created using Google Forms. When creating the response sheet (created in the "Responses" tab of the quiz, it automatically ...
1
vote
1answer
12k views

How do I find out who created a Google Form

I opened a Google Form and can't find it on any of my Google accounts - perhaps a colleague created it. Students have responded, but I can't find the original to see the responses. Is there any ...
0
votes
1answer
255 views

Fetch Random String From Array For Each New Form Entry

!Sheet1 is populated with entries coming from a Google form !Sheet2 has an array of 12 employee names in array A2:A13 How can I automatically populate the cell on the right column of every new line ...
0
votes
1answer
535 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
0
votes
1answer
35 views

Script Execution succeeds but reports failure

I'm running this script on a Google Form responses sheet: function autoSort(sheet) { var SORT_COLUMN_INDEX = 10; var ASCENDING = true; var NUMBER_OF_HEADER_ROWS = 1; var range = sheet....
0
votes
1answer
31 views

not working form submit Event Object

I have a Google form which I use to populate a Google docs from a certain template whenever a new response is submitted. In order to achieve this, I have written this script, but it is not working and ...
0
votes
1answer
36 views

Google Sheets formula

I'm using Google Sheets make a spreadsheet with the name in column a, the company in column b and in column f, I need their email. I have 3 companies, and they have slightly different email formats. ...
1
vote
1answer
47 views

send more than 100 emails using thrid party apps in gsuite

I am using G Suite app "Form Confirmation Emails" to send a customized mail in response when a user fills the form and submits their details. Everything is going on well but after 100 emails ...
1
vote
1answer
11k views

Conditional branching in Google Forms (checkbox)

I'm creating a google form and I've stumbled across this issue: I have a checkbox with options, say: A, B and C; so that it's possible for a respondent to choose more than 1 answer. And I have the ...
0
votes
0answers
8 views

How do i make google form responses become public ? (all people can see , even without sign in)

Yeah the title is clear , how do i make the result of google form become public ? so anyone , including people that didn't sign in to google , can see the result of the form . I've tried to search in ...
1
vote
1answer
31 views

Adding aliased hyperlinks to Google Forms multiple choice

I've a Google Form which includes a multiple choice list with radio buttons and would like each item to be a hyperlink to an item description. Is it possible? How? If not, is there a workaround?
1
vote
2answers
174 views

Embed just the google forms analytics page

I made a test google form and I have embedded it successfully... How do I embed just the stats/ analytics page? The page that allows people to see a pie chart of the collective survey results... link:...
2
votes
2answers
1k views

How to edit fixed link text in Google Forms

Does anybody know if its possible to edit the link text in the confirmation form of a Google Form? Having enabled the summary of responses, I have the following link text which is set by the form: '...
0
votes
1answer
13 views

Inserting responses

I am using Google Form to capture a survey. I have about 7 questions regarding a conference lecture. I want to use Google Forms and was wondering if I can manually insert the responses?
1
vote
1answer
28 views

Can I set a limit of 2 entries on Google Forms?

I use Google Forms in my classroom to administer certain quizzes, however, I allow my students two attempts on these. I have noticed that I am unable to see how may actual attempts have been made and ...

1
2 3 4 5
11