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.
471
questions
0
votes
0answers
9 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
17 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
10 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
12 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
27 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
14 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
53 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
18 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?...
0
votes
1answer
9 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
13 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
24 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
18 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
37 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 ...
0
votes
1answer
39 views
Import Form data into a sheet
I am trying to accomplish something that may not be possible. My work rents equipment to multiple companies and my boss wants me to setup a "database" of rental equipment and where its located and any ...
0
votes
0answers
16 views
How can I get multiple choice question id form Google Form
I want to pass Google Form value to my HTML form. In my HTML form I created multiple choices questions as well as I created the same question in the Google Form now I want to pass those input values ...
0
votes
1answer
43 views
auto-fill for new values in google spreadsheets
I have a google spreadsheet that connected to the google form,
this form has the name, family name, email address and... questions.
I want my spreadsheet takes name and family name and combine them ...
1
vote
0answers
25 views
How to change font style for Description, Response and other fields?
My research shows that old version of Google forms allowed to set different font styles for EACH type of field (question Title, Description, Response etc.).
It used to be possible to switch to the ...
2
votes
1answer
22 views
Using IF statements to apply an email address depending on teacher name
I am attempting to create a sign in sheet for students when they are sent to a "calming" room. The idea is that when they reach the room, they enter their name and select their teacher's name from a ...
1
vote
1answer
18 views
Conditional required questions
I am building a google form with several multiple-choice questions, I want to add a comment field below every question and make this comment required if the answer of the multiple-choice question is 3,...
1
vote
1answer
30 views
Conditional checkbox in Google Forms
I'm creating a peer evaluation on Google Forms. The first question is for students to select their name. If the student has selected his/her name, the choice for his/her name will not appear in ...
0
votes
0answers
31 views
Google Form field ID
I want to link a Google Sheets sheet with a form and pre-populate some of the data from the sheet into the form using this formula:
=HYPERLINK("form URL entry.ID="&A1&"&entry.ID,"Link")
...
0
votes
0answers
44 views
Using Google Forms to create an automatically updating inventory
I have created a Google Form that is used for people in the office to request items (swag given to donors). After an item or items are requested, the request must be fulfilled by a team member.
I ...
0
votes
0answers
11 views
Google Forms - can I save uploaded files by respondent to different folders?
I have a Google Form that we created to send out to a long list of collaborators. Each collaborator will upload image files for their particular project.
0
votes
2answers
42 views
Chronological ordering of checkbox in Google Forms
I have a checkbox in my Google Form, which sends the user selections in the form in an ascending order list:
But I want to grab the list in the order of selection, for example if the user clicks in ...
1
vote
2answers
85 views
Issues with Google Script on collecting Form responses and moving to another sheet
I have been trying to piece together some code for a task at work using Google Sheets and I am having some issues with what I can find versus my current knowledge level. I am trying to create a script ...
1
vote
1answer
1k views
Send a Google Forms response to specific email address based on form response
I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
0
votes
1answer
36 views
Google Side bar & editing form responses [closed]
I have some code which captures the URL of the edit response, so you can click it, and amend the record if needed. It pops out and opens in a new window. I wondered if it was possible to open it ...
0
votes
0answers
58 views
Google Sheets Form Response Split Multiple Responses [duplicate]
I've created a form for my staff to enter metrics about their job so I can track how new operations affect their output. For the ease of my staff, I'm hoping that they can submit multiple responses ...
0
votes
0answers
13 views
How to retain the current style of google sheet to a newly added row from a Google Form
I have setup a google form for a daily task list. And we keep adding new information every data. I have setup a theme and styled the Google Sheet the way I want but when someone adds a new entry from ...
0
votes
0answers
6 views
There is no submit option even if I leave the limit to one response unchecked
there is no submit another response option and there is no 'more:' option in the bottom right of the Google form.
1
vote
1answer
36 views
Skip arrayformula if the result of that formula is blank
I have an array formula that looks like this:
=ArrayFormula(IF(COUNTIF(B2:B, QUERY('Form Responses'!B2:G, "select G where B != ''"))=0, IFERROR(QUERY('Form Responses'!B2:G, "select B, G where B != ''"...
0
votes
1answer
25 views
Submit response but not submit?
I have a form for timesheet, that each row is a different job description, job number, hours booked to job etc.
I have it so when you submit, it fills in the response sheet in order from top to ...
1
vote
1answer
360 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 ...
0
votes
0answers
27 views
Google Forms limitations: Unique response req Google a/c, download data format
Are there known workarounds yet?
These are two Google Forms limitations I have found.
Unique response requires Google account: If we put a form on our web site and ask any user to respond to it, and ...
0
votes
1answer
29 views
Google Form Abandonment
If someone abandons a Google Form survey before submitting, can I still see their responses up until the point where they dropped off?
1
vote
1answer
21 views
Split data of a row in multiple rows
I've got some problem with data coming from a Google form.
The result are:
A|A|A|A|B|B|B|B|C|C|C|C|
What I want to get is:
A|A|A|A|
B|B|B|B|
C|C|C|C|
Is there a way to get a similar result?
-1
votes
1answer
18 views
How to display a text after a choice is selected in google form?
So I have my drop down connected to spreadsheet. There are two column which is ID and Name. In my google form, I want the user to select the ID but not the name. The name should be shown according to ...
2
votes
1answer
19 views
Is it possible to edit the column a Google Form response saves to?
I have a client who uses a Google Form to save data to a Google Sheet. They deleted and recreated one question, and the responses to that question are now being stored in a new column. This messes up ...
0
votes
0answers
19 views
Google Form response is modifying a cell on another row of linked sheet
I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...
1
vote
1answer
280 views
Change default values when Google Forms autofills a Google Sheets
There's a Google form that's linked with a Google sheet: whenever a response is posted to the forme, a new line is added to the sheet (here's a quick tutorial just in case).
Is it possible to have ...
1
vote
1answer
149 views
Hide skipped sections in responses
So, I've got an example form here with some conditionals. The flow is intended that it skips ahead to a specific section depending on the initial response—the usual.
My issue, however, is when ...
0
votes
1answer
58 views
How to recall the previous info submitted and change some fields only for the next submit
In my google form to register for an event, users may need to register a few times for the different members of their group (e.g. family members) but some of the information is the same e.g. address, ...
0
votes
0answers
12 views
Follow-up mail to survey
I have initiated a Google form survey some weeks ago & need to find a way to chase some of the recipients who have not yet replied. However, I'm unable to find the names of all the initial ...
0
votes
1answer
120 views
None of the above checkbox in Google Forms
I would like to create a multiple choice checkbox question in Google Forms with a 'None of the above' option and validate that if that option is selected, none of the other options are selected.
For ...
1
vote
0answers
138 views
Anonymous voting on google forms
I have this situation:
A group of people must vote using Google Forms. Their voting choices must be anonymous. But, they don't have gmail accounts and we would like to collect who has voted and who ...
0
votes
2answers
4k views
How to allow file upload without login in Google Forms?
I would like to create a Google form for submission of abstracts. Participants should have the option to add images, Excel files, or PDF. However, as soon as I add the File upload field in Forms, one ...
0
votes
1answer
173 views
Can I have a Google form that allows users to upload documents but does not require a Google account?
I have a Google form that is requiring users (survey takers) to have a Google account to access the form. This form includes sections that require the user to upload files before they can submit.
We ...
0
votes
0answers
22 views
How do I get responses in Google Forms to automatically be updated when updating the spreadsheet?
I'm in a situation, where I have been given a source of information, with all sorts of people. And with that, I wish to insert all this inside of Google Forms, in the response section. And so I was ...
-1
votes
1answer
215 views
Why doesn't google forms recognize responses manually added to the responses sheet
I'm trying to see if I can add responses to a sheet manually through a proprietary application but whatever response I add to the sheets document is pushed down and isn't recorded on the responses ...
1
vote
1answer
102 views
How can I track the time it takes for someone to fill out a Google form?
I am running a study for my thesis, and would very much like to track the time it takes to complete a Google form to compare against how long it takes to fill.
