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
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 ...
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
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
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
Force Google login page to appear when accessing a Google Form?
Take your form's url and prepend it with:
https://accounts.google.com/AccountChooser?continue=
For example, if your form's url were:
https://docs.google.com/forms/d/e/...
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.
4
votes
Accepted
Google form anonymity in organization
When creating a form in an organisation, the creator has the option to select "Collect email address" which will automatically collect usernames. According to the help article for this ...
4
votes
Accepted
Google Sheets - existing row formulas are being erased after Google Form submission
To start, you should never add anything, manually or via formula, to form intake sheets. It nearly always leads to problems. Leave the raw form data alone. That said, my first suggestion is that you ...
3
votes
How do I record the value of GET parameters passed to a Google form in hidden inputs?
What @Ruben mentions is correct.
Still. I believe that you can achieve what you want because you do NOT actually want to hide the field.
Frankly, I do NOT see a need to hide the fields from your ...
3
votes
Importing data into a Google Forms response sheet
2021 VERSION - This is a solution to copy a Google Form responses (answers) to another Google Form.
By default, when you copy a Google Form, only the questions will be included. The responses tab will ...
3
votes
Google Forms submits times that are not numerically consistent with those in a spreadsheet
There is a fractional time difference (milliseconds) between the time entered when you enter into the form vs directly into the sheet. Possibly this is a bug.
I think you can fix it by rounding the ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-forms × 576google-sheets × 260
google-apps-script × 122
formulas × 30
google-drive × 20
google-workspace × 17
google-sheets-query × 15
google-sheets-arrayformula × 15
google-apps-script-triggers × 10
google-docs × 7
gmail × 6
google-account × 5
regex × 5
data-validation × 5
google-sheets-form-submissions × 5
email × 4
google × 4
links × 4
vlookup × 4
automation × 4
google-sheets-timestamp × 4
conditional-formatting × 3
import × 3
javascript × 3
notifications × 2