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.
0
votes
1answer
15 views
How to use the “Make a Copy” trick when sharing a Google Form?
I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
0
votes
1answer
7 views
Active Survey Modification
I have a live survey via Google Forms. I want to edit one of the multiple choice questions. What will happen to the existing data? Will I lose the previous answers? Is it safe to modify one of the ...
1
vote
1answer
11 views
Share Google Form's result publicly with a link
I would like that the user who completed the form can share the answers to his questions with a link, and anyone with that link can see the answers. Is it possible?
1
vote
0answers
8 views
When importing a Google form submission to a spreadsheet, how do I automatically change the time format from “d-m-yyy” to “dd-mmm-yyy”
I am importing information from a Google form into a spreadsheet. It imports live. It creates a time stamp. There are also several other dates in the form (when you type it into the form there is only ...
1
vote
1answer
44 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 ...
0
votes
1answer
36 views
Submit another response missing from Google Form
If I create a new Google Form, and leave the "Limit to 1 response" option unchecked:
At the end of the form, the user will see a "Submit another response" link:
However, I have an existing Google ...
0
votes
0answers
20 views
How to create a chart with list of values as aggregated separate values?
I'm trying to do something similar to how Google Forms populated my data (which was with checkboxes, where multiple options could be checked):
This data in Google Sheets is represented as a column, ...
0
votes
0answers
14 views
Flow and Google Sheets automation inserting data stating at a certain cell?
I have set up a form for a user to request a WiFi account through Google Forms and Flow. I already have two columns set up as username and password for all the default accounts I need to add the data ...
0
votes
0answers
13 views
Copy previous submit form
We need to make a copy of submitted form, we need to entry almost 90% same data as previous entry. Any one have same issue, please share if you have solution on this Google Form ? ( same function as ...
0
votes
0answers
14 views
How do I make a Google Form public on the web, but for viewing only? [duplicate]
I'm trying to share a Google Form document in Google Drive and make it public to view, but I don't want anyone to be able to edit it.
If I set the link sharing mode to anything other than "Off", the ...
0
votes
0answers
14 views
Automatically jump to top of next section in Google Form?
I've setup a form with several separate sections which each section starting on a new "page". This form is then embedded in an iframe on another site.
The problem is that when users hit "Next" at the ...
0
votes
0answers
49 views
Google sheets auto add calculations to rows from Google Forms
I have a sheet 'Form responses 1' that is autofilled from a form. I was told to carry out all calculations on a seperate sheet to avoid any issues.
So in a seperate sheet I am pulling in the date, ...
1
vote
1answer
31 views
Use Google Forms to allow updating of old data and linking to correct record
I organise a small holiday programme which requires quite a bit of information about the children who attend (to ensure they are safe). This information splits into two types:
Information that never ...
1
vote
1answer
129 views
Google Forms - Responses Chronological Order
Can my form's responses populate in chronological order upon submission somehow automatically? I just did a test response with my co-worker and her 'order' was placed at the bottom, which I now have ...
1
vote
0answers
11 views
Automatically generate diagram based on respondent's answers in Google Forms [closed]
I have a questionnaire in Google Forms, where respondent answers some questions about his physical shape. All answers are taken in numbers.
My goal is to interactively generate a visualization ...
1
vote
1answer
60 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 ...
0
votes
1answer
18 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 ...
0
votes
1answer
40 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
9 views
Can a Google form be locked temporarily for maintenance?
Can people be presented with a "form is down for maintenance" message just temporarily until the form is ready again?
0
votes
0answers
182 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 ...
-1
votes
1answer
557 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
31 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
1answer
47 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 ...
1
vote
1answer
1k 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 ...
4
votes
1answer
153 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
146 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
2k 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
1answer
377 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
22 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
713 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
54 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 to ...
0
votes
0answers
95 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
54 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
1k 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
2k 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 ...
2
votes
1answer
54 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
192 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
112 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
48 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
336 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
280 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
151 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
123 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
34 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
67 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
315 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
237 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
31 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 ...
