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 ...
Rubén's user avatar
  • 44.6k
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 ...
prdeepkumawat's user avatar
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 ...
marikamitsos's user avatar
  • 12.6k
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 ...
marikamitsos's user avatar
  • 12.6k
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 ...
LWC's user avatar
  • 1,206
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:
marikamitsos's user avatar
  • 12.6k
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. ...
Rubén's user avatar
  • 44.6k
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,...
Roman Y. K's user avatar
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).
bcope's user avatar
  • 51
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 ...
marikamitsos's user avatar
  • 12.6k
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 ...
marikamitsos's user avatar
  • 12.6k
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 ...
peppeprof's user avatar
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....
Peter's user avatar
  • 41
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 ...
MaryC.fromNZ's user avatar
  • 7,293
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 ...
Rubén's user avatar
  • 44.6k
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 ...
Rubén's user avatar
  • 44.6k
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/...
Robin A. Meade's user avatar
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 ...
marikamitsos's user avatar
  • 12.6k
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.
MaryC.fromNZ's user avatar
  • 7,293
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 ...
John C's user avatar
  • 9,330
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 ...
Erik Tyler's user avatar
  • 4,980
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 ...
marikamitsos's user avatar
  • 12.6k
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 ...
Alexis's user avatar
  • 131
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 ...
MaryC.fromNZ's user avatar
  • 7,293

Only top scored, non community-wiki answers of a minimum length are eligible