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 ...
19
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/ ...
12
Here's how.
Add the host (eg. www) and domain name (eg. google.com) without the protocol or an html anchor. In other words:
Works
www.google.com
gmail.google.com
Will not work
google.com
http://google.com
<a href="http://www.google.com/">google<a/>
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 ...
12
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 ...
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
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
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
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
The spreadsheet is not the actual repository of responses. There is a 'bucket' of responses that is connected to the form itself.
The data presentation features use the responses connected to the form.
You need to use a script to add the extra responses to the Form object. You won't be able to save the original dates with the old responses, as the ...
5
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 = "...
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
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"...
4
Further to the above answers - This solution doesn't require an extra spreadsheet cell.
You can use the inbuilt event handlers for submission of the form to get a unique id. Because the spreadsheet is just the destination for the form, deleting a row doesn't actually delete the response. With that in mind...
EDIT: removed need for ID and dealt with date ...
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
Finally...they now support printing it out.
https://plus.google.com/u/0/+GoogleDrive/posts/ZSWMyZKC22t
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
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/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
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.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
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).
Only top voted, non community-wiki answers of a minimum length are eligible
