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.
446
questions
-1
votes
0answers
7 views
Chrome does not autofill saved passwords [migrated]
Chrome browser does not autofill saved passwords, however the option is turned on in chrome://settings/passwords:
Although there are no items in Saved Passwords, but all they can be accessed by ...
1
vote
1answer
17 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
19 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
41 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
10 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
19 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
18 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
11 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
11 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
18 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
41 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
33 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
28 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
26 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
30 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
621 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
105 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
17 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
50 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
28 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.
1
vote
1answer
14 views
Google Forms addressed only certain people
I would like to create a survey on Google Forms, addressed only and for certain and specific people.
the user must enter the name, surname and other data. if this information does not match those in ...
1
vote
2answers
84 views
Send a google form result to an email
I need help with the google form.
The problem is this: I want to receive an email with its results for every user who completes the form.
For example, if you had a form that required email, name and ...
0
votes
1answer
25 views
Repeatable questions
I'm trying to create a daily personnel report. Each manager needs to report who their personnel are, whether they are Present, Sick, On Leave, etc, and where they are. I then plan on having a set of ...
0
votes
0answers
27 views
Google Forms Duplicating answers to Google Sheets
I have a google form to capture order information,
When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much.
...
0
votes
1answer
273 views
Why does google forms ask me to sign in even though I am signed in?
I have gmail account signed in and when I open google forms that I received in my inbox, it asks me to sign in to continue. When I click sign in, it again reloads the same page and again asks me sign ...
0
votes
0answers
12 views
Edited Google Form questions not same when open in spreadsheet
I used google form to create few surveys. I do some edit on the questions, questions sequence, etc. However, the questions sequence in spreadsheet is not the same as in google form. If there are new ...
0
votes
1answer
13 views
Update giveaway quantities in Google forms
I am in charge of giving away a number of T-shirts which come in different sizes and colors, but they are limited in quantity. I wanted to create a Google Form for giving the T-shirts away, but I do ...
0
votes
0answers
17 views
Google forms - How to capture a list of items from user?
I wish to use a google form to capture user input in the form of a list?
The default question templates do not allow it, is there an add-on I can use? Following is the desired template.
1
vote
1answer
24 views
Insert a weekday in Google Forms' date selector
We have created a Google form that works perfectly, there is only one issue, and that's the DATE selector, it sends the DATE, but we would like to receive the DATE and the WEEKDAY in the form we ...
0
votes
1answer
36 views
Re-using a google form sent data, avoiding entering all data
I am building a Google form to manage summer camp subscriptions. Each request must enclose parents and child data.
The problem is, if a family wants to subscribe more than one child, the process must ...
0
votes
1answer
19 views
Data cleaning in Google forms
I've recently conducted a survey using Google Forms. The graphs and charts in the summary section are enough for me. However, I want to clean 10% of data (change ambiguous answers). Is there an easy ...
1
vote
1answer
13 views
How to find a spreadsheet to which a form submits?
In my organization, we have recently found a form that is supposed to collect some kind of submissions from people. The problem is that we don't know who exactly created it and where are the answers ...
0
votes
1answer
29 views
Look up a list embedded in a Google Sheets from a Google Forms, and add attributes to the corresponding row?
I'm running an event for a large number of children and need a way to let them register quickly as they come in, to the event.
We're expecting about 400 kids who have pre-enrolled and we will have a ...
0
votes
2answers
21 views
Prevent shifting of rows in auto-updating sheet
I am struggling with an automatically updating spreadsheet that is connected to a Google Form.
Whenever there is a new accomplished answer in the Form it is adding a row in the spreadsheet, resulting ...
1
vote
1answer
79 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
1answer
50 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 ...
0
votes
1answer
516 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 ...
0
votes
1answer
15 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
1answer
27 views
How to assign internal names (“programmatic”/cryptic and non-visible for the form participant) for each question in a google form
Is there any way to set question cryptic-name/variable in addition to the question visible to one answering the form.
What I need is that when I export forms questions to google sheet I can ...
0
votes
1answer
47 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
0answers
84 views
How to print Google Form section
How to print each section of Google Form?
I want to print section A and then section B but there should be no title for section B.
0
votes
0answers
23 views
Is it possible to stop Google Forms adding a sequence number to each question when printed
I have set up a form in which each section has its own number and each question within the section a sequence number based on the section number. All is fine when the form is being send by email, ...
0
votes
1answer
28 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 ...
0
votes
1answer
93 views
Reconnecting form responses to current sheet after file move to Team Drive
I have searched for an answer for the "current" Google Forms problem I am having. It seems the answers here for this issue are outdated as Google keeps changing their technology about as fast as I ...
0
votes
1answer
196 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 ...
1
vote
1answer
38 views
Create a Google Classroom assignment in which students cannot attach files
How can I create an assignment that only allows students to submit their answers via an attached form?
I tend to assign questions to be answered via Forms, but sometimes students answer by attaching ...
0
votes
0answers
177 views
Google Form File Upload - Change File Name to Match Form Value
I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
2
votes
1answer
69 views
Google form anonymity in organization
I have a Google account that's part of an organisation. There's this form that only people in the same organisation can respond to. Is there a way for the owner of the organisation to find out that it ...
0
votes
0answers
137 views
URL code for Google Form section
I have Google form with 10 section(lets call it page), and I use app inventor to create the mobile interface. The problem is when I get the pre-fill link with a link to be execute:
https://docs....
