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
10 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 ...
1
vote
1answer
22 views

TypeError: Cannot read property 'range' of undefined at onformsubmit again after creating an event object

This is what I have written in Script editor so as to auto-apply a formula to a new added row when a new response is submitted on the Google Forms linked to my spreadsheet. First I was using ...
0
votes
1answer
8 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 ...
-2
votes
0answers
15 views

Google Forms email notification based off responses

I'm trying to make a Google Sheets script in Google App Script to respond to changes to a spreadsheet from a form. it will eventually be used to send an email to the user with a list of URLs to access ...
0
votes
1answer
8 views

Google Sheets combine all selected rows into single cell separated by commas

I'm trying to combine all selected rows into a single cell. A B C D E ...Z or alternatively, all selected. Into a single cell as A, B, C, D, E where I can copy its values. I have tried to concat, ...
0
votes
1answer
21 views

Google form adding more than one row every time

I know that when a new response is submitted on Google form, a new row is auto-added to the linked spreadsheet. I use several onformsubmit triggers for my form and linked spreadsheet. But I do not ...
1
vote
0answers
14 views

Automate Google Groups and Google Forms

I have a Google Groups that only accept invited members. I really want a Google Form where member input their email address and automatically an invitation to the group is sent to their email. As soon ...
-1
votes
0answers
14 views

How to get the text from the Other field in a google forms question to be used in the visualization?

On a check all that apply (checkbox type) question, some respondents used the options I created and othere people used the other box. The issue is that for the people who used the other box, the data ...
0
votes
1answer
25 views

Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file “Code”)

when I am running the script below I am getting the message - Exception: The parameters (null) don't match the method signature for FormApp.Form.getItemById. (line 38, file "Code") it has been working ...
0
votes
0answers
27 views

how to apply changes to all dropdown questions in forms

I am using a script to update dropdowns in a Google form from a spreadsheet. There is a Questions#1 worksheet on which there are all questions that should be updated automatically in the form when any ...
0
votes
1answer
27 views

TypeError: Cannot read property 'getId' of undefined

I have written this script to my spreadsheet which is connected to a google form too, and connected dropdown function to a button on spreadsheet so as be easier to run the script. first it worked well ...
0
votes
1answer
21 views

How to use Lookup formula for new rows in Google Sheets submitted via Google Form?

I am using the following Lookup formula in a Google Sheet: =LOOKUP(F2, AreaCodes) I need that formula to be triggered when new rows are added via a Google Form. I'm guessing the solution has ...
0
votes
0answers
12 views

Can I attach a word document to a Google Form so that respondents can DOWNLOAD it (not upload to a google form)

I am creating a Google Form for respondents to use as a method of signing up for a course. I have a document, in word, that I would like to attach to the Google Form with the intention that ...
0
votes
0answers
20 views

How can I SUMIF a row, but have the formula automatically applied to all new rows below it in Google Sheets?

I've made an inventory tracking spreadsheet that gets raw data from Google Forms. Forms inputs data into Sheets in a less than ideal way, but there's nothing I can do about that, so I'm stuck post-...
0
votes
1answer
46 views

What are the Google Forms limits?

The Google Forms / Google Drive help docs doesn't mention any limit for Google Forms but there are questions that report that the forms stop working as expected. Some times they still are able to ...
-1
votes
0answers
37 views

Linking google sheets

Our employees recently started using Google Forms to submit work orders. The data automatically gets put into a spreadsheet for me. I understand I can see each customer separately by using the ...
0
votes
0answers
18 views

Google Form Closing Survey for Multiple Questions

On my google form survey, I have 3 yes/no questions to determine the scope of the survey, that if the person answers no to any of them they will be closed out of the survey. Each question is set up ...
0
votes
1answer
23 views

Form that only allow for one person to choose each option [closed]

I need to create a form where people can select one of the options made available, and, once they do, that option becomes unavailable to anyone signing in afterwards. (Or where I can define the amount ...
1
vote
1answer
11 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 ...
0
votes
0answers
38 views

Splitting checkbox response into multiple rows on another sheet

I am trying to take a Google Form response page, and change the way the data is displayed. Currently, I have the raw data on the first sheet, and I'm trying to format a second sheet that will split ...
0
votes
1answer
48 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 ...
-1
votes
1answer
48 views

Get email address in from Google Forms in script

I'm creating a Google Form where guests can log in and an email will be automatically be sent to the person that submits their form. They are not required to log into Google as this will be running on ...
0
votes
1answer
65 views

Add dynamic questions in Google forms

I am using google forms to punch orders in my Google Sheets. Although I am facing a challenge as the number of products is variable. For example Question 1: Item Name Question 2: Quantity I ...
0
votes
0answers
16 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:...
0
votes
0answers
114 views

Need some help inserting break to prevent “Exceeded maximum execution time” Google Sheets script

I'm using a Google Sheet to populate drop downs in a Google Form. There's not a lot of info to be transferred as such, but it's repeated 76 times... I'll paint the picture first, so you have an idea ...
0
votes
0answers
17 views

How can I populate and submit a Google form using info from Google Sheets?

I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
0
votes
1answer
71 views

applying a formula to the data from google forms

I have a google spreadsheet which is connected to a google forms I wanted one formula to be automatically copied to the new lines(Column R) when google form response is submitted the spread sheet: ...
0
votes
1answer
19 views

Google form where all answer options calculate to 100%?

Put the % of how much you spend of your salary in the following categories: [Airtravel, Rail transport, Taxi, Personal car, Uber ...., Other] I want to format the question in Google Forms such that: ...
2
votes
1answer
55 views

Google Forms quiz submit ONLY when ALL correct

I would like to use Google Forms to create a simple 5 question multiple choice quiz. When the user has selected their answers and clicked Submit I would like to display immediate feedback on the same ...
0
votes
0answers
91 views

Google app script on how to create a pdf from the data received from an html form of its spreadsheet and send the pdf file via email

Google app script on how to create a pdf from the data received from an html form of your spreadsheet and send the pdf file via email - I would like to create a pdf file from the data recorded on the ...
0
votes
1answer
206 views

How can i get data from Google Sheets to Google Forms dropdown list?

I have some data over Google Sheets file, i want to get Google Forms dropdown list to be updated automatically from that list. Is it possible? Thanks
0
votes
1answer
23 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?
0
votes
0answers
14 views

How many questions can a Google Form hold?

I want to create a google form with 2737 questions (short text answer type). How many questions can a single google form handle?
2
votes
3answers
110 views

How to prevent Google Sheets from reformating input from Google Forms?

I need to create Google Form where users can submit different data. Problem is that some of them use comma and others use dots as decimal separator and my Form should handle them both. Problem is, it ...
0
votes
0answers
18 views

Google Apps Script send attachment on cell value

First of all I am a complete beginner in coding. So I am trying to build a form, that once it is submitted, will send a different gdrive file as excel sheet based on a key word in the form. So far I ...
0
votes
1answer
33 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
27 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 ...
0
votes
0answers
11 views

Google Form Questions changed by users answering

I have created a Google Form, which I have done many times. However, this time when users are answering, their answers actually replace the question. For example, in one question I ask for Player's ...
0
votes
1answer
428 views

How to Redirect to another Website upon Google Form Submission?

I have a Google Form which is backed by a Google Apps Script with an onFormSubmit function, which fires when the Form is submitted. The next thing I want to do is, after the Form data processing is ...
0
votes
1answer
28 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. ...
0
votes
0answers
25 views

How to display of results in Google Forms after deleting some response?

I have collected some data using Google Form that are visualized by Google Form in histogram and pie chart. Now I want to circulate URL of same Google Form. But I want it should show the visualization ...
1
vote
0answers
331 views

Importing data into Google Form response sheet with date, list, grid

I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
0
votes
0answers
27 views

Google Forms Hyperlink

With the update to Google Forms a few weeks ago, hyperlinks are not automatically recognized. How can I create a clickable link in the new google forms?
2
votes
1answer
59 views

How to check if the values of two cells exist in two columns of another sheet

I am trying to make a class attendance system where the student checks in by submitting her name into google forms. The final result will be displayed in Google sheets by marking a check box after ...
2
votes
1answer
36 views

I was sent a google form (link) and can see the senders answers

I was just sent a link by a colleague to a google form. I can see that they ran a test of the form with "dummy' answers. Can the sender change this so that others don't see their responses in the form?...
1
vote
1answer
17 views

What happens when multiple people edit a multi-page form?

Imagine I have a multi page Google form and the "edit after submit" option is enabled. Imagine we have a 3 page form with the following text questions: Q1 Q2 Q3 The form is submitted with blank ...
0
votes
1answer
61 views

in a Google Form, can I change or remove a question safely after receiving responses/Submissions?

After I create my Google Form and start to receive submissions, can I change or remove a question or will it break the data? I know it's very picky with having to re-link the spreadsheet if I link ...
0
votes
1answer
54 views

Don't allow same answer in Google Form

So I have a problem where I want to use google form for data collection for few different teams. At google form the first question is to type in the item number (6 symbols) and there is no duplicates ...
0
votes
2answers
24 views

Will working with an active Google Form responses sheet mess anything up?

I'd like to sort rows and remove duplicates while the form is live and the responses sheet is receiving incoming responses. Will my working on the sheet while a response is coming in cause any ...
1
vote
0answers
67 views

Google Sheets - Query Multiple Columns for same Data

We have Employee training data in a Google 'Form Response' spreadsheet which ranges from A1 to JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult ...

1
2 3 4 5
11