30
votes
How to create a countries drop-down list question, without entering all countries manually?
Just copy paste the following in your Google forms. The form dialog automatically creates new items when the pasted text contains linebreaks.
The following list is posted so that the future readers ...
20
votes
Accepted
Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script
Short answer
The link points to a Q&A that has two answers but non-of them looks to me to be appropiate. I.E. the code of one of answers is incomplete and both of them send emails, so the adoption ...
14
votes
How can someone answer my survey form or Google form without creating their own Google account?
In my case even after disabling 'Limit to 1 Response' I was not able to access the form publically and it was asking users to login. Later I found that I had chosen 'File Upload' from few questions in ...
12
votes
Accepted
How to delete a single answer in Google poll/survey
The answer that this wasn't possible by @ruben was true until very recently.
This is now possible on the New Google Forms. (Google announcement on the 10th of February 2016).
The New Google Forms ...
11
votes
How to save users' responses in Google Form survey as they continue from page to page?
Google doesn't currently support this feature - there is no way to save a form and have a user return to it later without submitting it.
That does raise an interesting point, though. You can have the ...
11
votes
Accepted
Can Google Forms send emails automatically?
Please note: Under Settings --> Presentation one can set the Confirmation message that will only be shown on the browser screen upon submission.
What you ask for is that:
... the Google Form ...
9
votes
How can I create an e-mail field on a Google Form?
Choose the question type as Text
Click on Advanced settings
Check Data Validation
Choose Text
Choose Email Address
(optional) Type in a custom error message
7
votes
Email Google Form daily?
This can be done without the need of 3rd party apps by using Google App Scripts.
Just to give you an idea the procedure would be:
Create a Form in Google Forms and email it to yourself
Get the ...
7
votes
See Google Form results when not the owner
If the owner enabled the "Show a summary of responses" option, you can see the results' summary in https://docs.google.com/forms/d/e/[form's ID]/viewanalytics.
You can take the form's ID from the ...
6
votes
Accepted
How to create a question in Google Forms that allows two distinct answers?
It is possible.
You should use the Multiple choice grid and turn "Require one response per row" on.
Please have a look at the attached images.
Editing the form:
Viewing the form:
6
votes
How to undo/ go back to a previous version in a Google Form
Short answer
Google Forms doesn't include a feature to do this.
Explanation
In contrary as occurs with Google Documents, Sheets and Slides, Google Forms doesn't have the revision history feature.
...
5
votes
What is the maximum of fields a Google form can contain?
Correct - Google Forms utilizes Google Spreadsheets to store their data, so you are restricted to the limits imposed on Spreadsheets.
EDIT:
As Jacob pointed out, these limits only apply to old ...
5
votes
How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?
I have found a workaround that creates the same result, though it may take a little bit more time to set up.
What I do is create a pivot table of the data that comes in from the Google Forms results,...
5
votes
How can someone answer my survey form or Google form without creating their own Google account?
If your form includes File upload widget, this will trigger the sign in requirement as well, likely because it utilizes Google Drive (and thus requires a Google account).
5
votes
Accepted
How do Google Forms handle the "Other" field in Multiple choice/Checkboxes/Drop-down questions?
As far as "...I cannot see any way to make Forms insist that text is entered in the other text-box.". There is a way to make Forms insist that text is entered in the other text-box.
Mark the question ...
5
votes
Validate age (>18) Google Forms?
Yes it is possible.
What you would need to do is this:
Create a section right at the beginning having just one multiple choice question and make it required.
Create a second section (right under ...
4
votes
Importing data into a Google Forms response sheet
I used @Jean-Francois answer together with Mogsdad to achieve my task: to merge data coming from many identical forms into just one. I added a skip for empty answers, as my form had many non required ...
4
votes
Is it possible to automatically add question numbers to Google Forms?
No it is not possible to automatically add question numbers to Google Forms.
4
votes
How to add attachment option in Google Form?
Google Forms does not allow respondents to upload files. There are some ways around this though:
Have them upload the file directly to your Drive account. See instructions here.
Use JotForm, which ...
4
votes
Accepted
How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?
Google Apps Script is used to extend Google Sheets, but as was noted by @Normal Human, at this time it doesn't include methods to update/refresh Google Sheets filters.
https://code.google.com/p/...
4
votes
How to automatically refresh a filter view in Google Sheets when new data comes in via Google Forms?
Try a Script that fires onFormSubmit. Get and then re-set the same criteria.
var sheet = SpreadsheetApp.getActiveSheet();
var filter = sheet.getFilter();
if (filter) {
var criteria = filter....
4
votes
How to limit one response per email for Google Forms
I do not believe that any of those things are possible using Google Forms - at least not automatically.
Google Forms has a feature that you can turn on to prevent more than one response per Google ...
4
votes
Accepted
Create question in Google Form where all answer options calculate to 100%
Short answer
At this time, this is not possible with Google Forms.
Explanation
Google Forms doesn't have a question that allows multiple numeric answers and the answer validation only could be set for ...
4
votes
How can we NOT record, but on the fly disregard responses not matching an already existing roster
Short answer
Once the response is submitted it's stored and there isn't a way to avoid this. By the other side, it's not possible to delete individual responses on the responses container bounded to ...
4
votes
Accepted
How to increase Google Forms content width?
I am afraid (as mentioned by @sandwich as well) there is no way to manipulate the width of the form.
Fortunately there is a work-around.
What you could do would be something similar to the example in ...
4
votes
See Google Form results when not the owner
The owner, and any collaborators they have nominated, can choose to share the results with you.
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-forms × 571google-sheets × 254
google-apps-script × 118
formulas × 31
google-drive × 20
google-sheets-query × 15
google-sheets-arrayformula × 15
google-apps × 12
google-apps-script-triggers × 10
google-docs × 7
gmail × 6
google-sheets-form-submissions × 6
data-validation × 5
google-account × 4
email × 4
google-workspace × 4
google × 4
links × 4
vlookup × 4
regex × 4
automation × 4
google-sheets-timestamp × 4
javascript × 4
formatting × 3
import × 3