28

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 do not need to remove the numbers from the list provided by listofcountriesoftheworld.com. Editor's note: the list below may go out of date as countries are ...


20

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 is too complex to be used as a starting point. Below is a script that is easier to adopt. Instructions Create a test form and note the form ID (between ../d/ ...


13

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 that form, which were forcing my users to login to access the form. I deleted those 'File Upload' question from the form and then my users were able to access ...


12

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 allows you to delete responses from within a Google Form. Delete ALL of the responses: Delete individual responses: To delete individual responses you click on ...


11

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 user submit the survey and edit their responses later. Instead of forcing the user to page through the rest of the survey to get to the submit button, just add ...


10

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 will automatically send an e-mail ... You will find that there is a number of ways to make this possible. Edit Begin (By now Google has integrated an ...


8

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

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 HTML from that email and copy it to your clipboard Create a new Google App script with the following code: function sendFormEmail() { var emailAddress = "...


6

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:


5

Here is the solution that I was able to use to resolve a similar need to import historical data as actual form responses. the code first opens the form I created, and the spreadsheet with the historical data in the array named "values". The for loop cycles through each line of the spreadsheet, populating each item of the form, and then submitting each ...


5

I've just adapted some trick which is very simple by using Validation option in Text field to check the password which you set it before give it away. For example. Set a field with user name let them choose from the list you add their name in advance let connect those name the pagebreak which is on their name on the page let set a text field and add the ...


5

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 Google Spreadsheets. All limits have been removed in the new version. All spreadsheet limits mentioned above have been removed in the new version of Google ...


5

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

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 as "Required". As far as "...usually don't show all the "other" responses as they are...". Google forms always handle Multiple choice/Checkboxes/Drop-down ...


5

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 original form, which looks like https://docs.google.com/forms/d/e/[form's ID]/viewform.


5

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 it) with NO questions. Just a Title (Sorry) and a description (You must be over 18 to participate.) and name/fill them with whatever you like e.g: Title "Sorry"...


5

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. Unfortunately Google Drive doesn't keep revisions of Google Forms either. Suggested action Send feedback to Google to request to add a feature to prevent the ...


4

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 questions and jumping sections. To "upload" about 1000 responses with 30 items, I had to run twice the script because of timeout, just by changing ...


4

No it is not possible to automatically add question numbers to Google Forms.


4

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 has integration with Drive.


4

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/google-apps-script-issues/ is the place for feature requests and enhancements to existing Google Apps Script services. People can "upvote" a feature request by ...


4

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, manipulate the table to represent the data the way I want it, and then link the pivot table to a new sheet ( using ={'Sheet Name'!A1:G100} ) and format that ...


4

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.getColumnFilterCriteria(4); if (criteria) { filter.setColumnFilterCriteria(4, criteria) }


4

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 Account (they say "person" in their help, but really it means per account). To use this feature: Edit the form. Click the Settings bar Turn on the "Allow only ...


4

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 the related question, not for multiple questions at once. New Google Forms question types: Multiple choice Checkbox Short answer Paragraph Dropdown : ...


4

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 the Google Form. Explanation At this time Google Forms responses are stored in the Google form file and optionally could be set to automatically send them to a ...


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