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.
0
votes
0answers
16 views
How to I calculate ranking poll in Google Forms
So, I'm a part of a Facebook group that is interested in sports and we would like to create our own NCAA Football Top 25 poll. Thus, I used Google Forms to create a poll where the questions are the ...
0
votes
0answers
14 views
Clock In & Out System on Google Form [migrated]
I created a Google App Script that creates a form to allow users to choose their name from the dropdown list and it will direct them to the next page. On the next page, with their name and a little ...
0
votes
0answers
19 views
Create a custom PDF for All Google Form Responses
I need to create a pdf so that all the responses got in google form should be present in that pdf.
What I did
I clicked on response tab of google-form then clicked on print all responses which ...
-1
votes
1answer
43 views
Link Google Form responses To Already Existing Google Spreadsheet Tab
I have a Google Form. I had all of my Google Form responses linked to a specific tab in my Google Spreadsheet. Somehow my form responses were unlinked from my tab. When I go to re-link my form ...
0
votes
2answers
21 views
Scanning a column and partitioning information to other sheets in Google Sheets
I am a membership manager in an international organization and I was hoping to get some help optimizing our members' contact list.
There are three kinds of members, NCs, LCs, and IMs. I have a ...
0
votes
0answers
22 views
How a Google Apps Script project can handle many triggers like OnFormSubmit for many forms?
I work on a project that uses Google Apps Script to handle some workflow so instead of typing a script for every form created in the future, I want to write one script that can handle many triggers ...
0
votes
0answers
15 views
Google Form where answers are filtered then moved to a new sheet for editing while staying dynamic
I have made a Form for a school district for several schools to fill out for student information. That form is then filtered out for each school. I can't give access to the whole workbook because of ...
1
vote
1answer
46 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
0answers
21 views
One Google Form Response into multiple rows
I'm having a problem, which I've seen resolved via a script. I have a Google Form that accepts multiple checkbox responses in one submission. On my end, the responses come up on one row separated by ...
4
votes
1answer
30 views
Google Forms: Number Ranges Appear as Dates
I have a Google form intended to be filled out by teachers. One of the questions is about student ages. The choices are checkboxes with age ranges, so [ ] 0 - 5, [ ] 6 - 11 and so on.
The two ...
0
votes
1answer
21 views
How to print a report for each row?
How do I print a report of a spreadsheet such that row n is all printed on a single page. That is, row 1 is on page 1, row 2 is on page 2, etc.
The issue is that some columns have large amounts of ...
0
votes
1answer
94 views
How to undo/ go back to a previous version in a Google Form
I deleted a certain section on my Google Form which has resulted in the deletion of the entire form.
Does any one know if there is a way to fix this?
Undo button is not working nor is the back button.
...
0
votes
0answers
41 views
Searching dropdown list in Google Forms
Is there a way to search for items in a dropdown list in Google Forms? If you have a lot of items to choose from, can you start typing to either eliminate other choices or search for choices with the ...
0
votes
1answer
21 views
Please recommend a form like Google form to add calculations and if else logic when a user submits data [closed]
Say I want two values from the end user X and Y. I want to calculate values like XY and logic like if XY < something then one value otherwise another value.
0
votes
0answers
104 views
Fill out google form using an api
I have a private google form I need to fill out every day, so I would like to write a script to authenticate me using my google credentials, and then fill out some of the form programatically, is ...
0
votes
1answer
42 views
Google forms to google sheets
Can someone help with this.
in a google form i have a question in the form of a checkboxes choose where multiple answers can be selected.
In sheets it putting them all into 1 cell, is there a way ...
0
votes
0answers
35 views
Array Formula Auto-Calculation in Google Forms
I have a google form which is returning data into Column A and Column B and I need to perform calculations on that in Column C, D & E. I have been using Array Formula so that C & D auto-...
1
vote
0answers
44 views
How do I edit file responses on Google Forms after submission
On a Google form that allowed me to edit my responses after submission, there was a question that asked me to add a file. I did just that and turned it in. Now I want to replace that file. I can edit ...
0
votes
1answer
161 views
Google Forms - hybrid ranking/checklist question
I would like to create a ranking question, which only allows one selection per column. On the same row of each object being ranked, I would like the ability to add additional options that don't affect ...
0
votes
1answer
265 views
Dynamic calculation in Google Form
I am creating a "Trader Stall Application" form and want the cost of the Trade Space to be calculated when the user enters the "Frontage Metre" value (eg 10mtrs) multiplied against a static figure (eg ...
1
vote
1answer
27 views
How to send Google Form results to a particular SHEET (“tab”) of a spreadsheet
Is there a way to create a Form that submits to a particular TAB of a Google Sheet?
Use Case
WE are using this for meeting pre-checkin. There's standard form. I'd like the results for each ...
0
votes
0answers
31 views
Google Form onSubmit script runs before row insertion?
A Google Form is running a script to manipulate data in the responses sheet,however it looks like the script is running before the row insertion occurs. Basically what I am attempting to do on (Form) ...
1
vote
1answer
46 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
24 views
getEditResponseUrls - hyperlinks from second linked form not inserting
I am new to scripts, but I was able to find a one that uses getEditResponseUrls to insert the edit link from a form into a Google Sheet. I've now been asked to add a second sheet to my spreadsheet ...
1
vote
0answers
168 views
Adding multiple choice questions to sections of a Google Form via Script
I am working on a survey using Google Forms that I generated via a script. There are over 2000 questions that are all the same format but are broken up into different sections.
So, for example, ...
0
votes
0answers
85 views
How do I resolve an invalid argument in this script to collect Google Form edit response urls?
I am trying to add script as per previous questions here and here. However I am not getting any links populated and I have an invalid argument. Please see error message and script below. What am I ...
0
votes
1answer
53 views
Remove duplicate items from array?
What would be the best way to remove duplicate items from cells in rows? For instance...
Category 1 | Item 1 | Item 2 | Item 2 | Item 3
Category 2 | Item 3 | Item 1 | Item 2 | Item 3
...
0
votes
0answers
11 views
How would I create a work bank of sorts for multiple questions?
So I have 4 questions with 45 answers each. This is used to collect data on encounters people have in a game.
The encounters will have anywhere from 0 to 4 perks, with 45 perks to find. Any given ...
0
votes
0answers
47 views
How to link a Form to a specific existing Spreadsheet Sheet which has formulas in it
I have a budget spreadsheet in Google Spreadsheets. One sheet is used to record transactions. In addition to the actual transaction data I have several calculated fields to update budget account ...
0
votes
0answers
20 views
Auto-update specific cell in a spreadsheet depending on answer from a Google Form Response
My spreadsheet has two tabs
Google Form responses
Schedule of regular tasks
The Google Form gathers data about a specific task and records the date of completion for that task. When a user has made ...
0
votes
0answers
19 views
Filter Google Chart responses
Is there a way to filter Google Form responses? I have successfully create a dynamic filter in the generated sheet, however some questions are too complex to manage with charts (multiple choices), ...
0
votes
0answers
181 views
Why I Cannot pre-fill email address?
When I try to get a pre-filled link from a Google Form, the email field has a note: "Cannot pre-fill email address". Why is it not allowed to pre-fill an email address?
If I use a regular text ...
0
votes
1answer
111 views
Google Forms - App script won't iterate through all form fields
I have made a Google Form and onSubmit an app script will run iterating through all form questions and answers however some questions, when the corresponding answer is left empty, are not listed/...
0
votes
0answers
26 views
Google form: How to get response URL into google sheet on Summit [duplicate]
Anyone know how to get URL of response into google sheet automatically after Submit.
For example, we only get all field in google form, can not have its URL. Unless manually copy after summit
...
3
votes
0answers
17 views
Persistent column formatting in Google Sheets [duplicate]
I have a Google Sheet with an input form. I click the top of a column to highlight the entire column and set format to Currency with two decimal places. This puts the dollar sign in front of all the ...
0
votes
0answers
10 views
How can I create a web Form which allows me to display each question on a single line? [duplicate]
I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
0
votes
0answers
240 views
How can I change Google Forms style to put multiple textboxes on the same line?
I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
0
votes
1answer
14 views
Can you upload a big email database to use as the sample for your Google Form survey?
I am trying to put together a survey in Google Forms. This is will be emailed to a sample of 3000 people. Is there an easy way to import this email data set as a CSV file and send the emails out to ...
1
vote
1answer
954 views
How to validate a date in Google Forms?
Google Forms include the possibility to perform some sort of validation on user input for checkboxes and text; the functionality is available very easily both via the UI and the API. Unfortunately, it ...
0
votes
0answers
129 views
Google Forms conditional auto reply
I made a questionnaire with Google Form. I want them to get an auto-reply when the form is submitted which I figured out with the response receipt.
My actual question is: one of the questions on the ...
1
vote
2answers
48 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 ...
1
vote
2answers
315 views
Date format differs on iPhone
I have created a (google) registration form online. I set the date format to dd/mm/yyyy but when others access the form on their mobile, the format changes to mm/dd/yyyy
I would like the format to ...
0
votes
0answers
27 views
Is it possible to generate conditional output (to PDF, Docs, Sheets, Slides, etc.) based on specific answers given in a Google Forms response?
As a part of a promotion process for members of an online organization that I run, I'm having the applicants fill out their applications via Google Forms. Instead of creating a separate form for each ...
0
votes
1answer
354 views
Method to get Google Form data into multiple rows
I have a google form to collect - Family Group Name and Family member details.
I get the whole data in one row.
Is there a way to get the data saved in the format in the image through some add in ...
0
votes
1answer
162 views
Filling Google Form through Google Sheet
I have a database of name, phone number, address.
And I have 3 questions in the form:
name
phone number
address
If someone filled his name, I want the form to auto-answer his phone number and ...
0
votes
0answers
20 views
Recurring Google Form [duplicate]
I want to create a Google Form that can be automatically sent out to a list of individuals every week. I want it to be the same form every time and don't want any one person to have to be responsible ...
1
vote
0answers
35 views
How to get new Google Form responses to take on non-form functions in Google Sheets
I developed a Google Form that copies responses to a linked output spreadsheet in Google Sheets.
In addition to the columns created by the form question/responses themselves, I've added additional ...
0
votes
1answer
34 views
Apply formulas to row when the new one is added
I have a form that is submitted to the spreadsheet.
In that spreadsheet I've added a second sheet Results where I want to organize processed view of results. But when the form is submitted, the new ...
0
votes
1answer
36 views
Forms Data Manipulation Revise in Google Sheets
So I came across this post that is doing exactly what I want. We use a google form to collect new learners to add to a store. What I'm trying to do is have the first 9 columns repeat for each learner, ...
0
votes
0answers
266 views
Google Sheets split multi-cell into new rows
My question is about merging multi-line cells into separate rows from a Google Forms responses doc.
It looks like this question has been asked & answered, however, I have spent several hours over ...
