Hot answers tagged

26

Normally, everyone can fill out a Google form; they do not need an account. However, if you selected the option "Can submit only 1 response" in your Google form, that will require the users to login. So, if it's necessary to allow anonymous users, you should uncheck that option. Also, it's a good idea to test the form yourself, by using a browser ...


7

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 ...


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:


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 ...


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 ...


3

There's a defect listed on the Google Apps Script issue tracker. We'll have to wait it out to see when a project member responds to it, I'm assuming.


3

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 ...


3

Step 1: Open the form. Step 2: Click on "Responses" from toolbar. Step 3: Click on "Change response destination". Step 4: If you want to save responses in existing spreadsheet with a new sheet, choose "New sheet in an existing spreadsheet" or if you want to save responses to a new spreadsheet choose "New Spreadsheet" and "Type the name" for new ...


3

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 values: check for equality with a formula like round(time1, 6) = round (time2,6)


3

see cell E2 on your second tab where I entered: =sort(ArrayFormula( {transpose(split(regexreplace(join(";", 'Form Responses'!C2:C), "(\w+),\s(\w+),\s", "$1, $2;"),";")),transpose(split(join("/", rept('Form Responses'!A2:A&"/", if(len('Form Responses'!C2:C), (len('Form Responses'!C2:C)-len(substitute('Form Responses'!C2:C, ",",""))+1)/2,)) ),"/"))}),1,1) ...


3

Google forms do not appear to offer such customizability. But it's possible to directly modify the HTML file provided by the form, and use the modified file instead of the form. Such restyling process is described in this tutorial, and the Sneaky Sheep tool might make it easier. Here is a brief description. Create the form Go to Live Form Right click ...


3

Essentially, you'll need a page for each client type that requires specific questions. In this example, I have three types (ninja, potato, elk). You'll make a page for each unique question(s)/client type paring. I made two pages. One for ninjas and one for potatoes. (elks can't type). You can see in the screenshot below that I checked the box that says Go ...


3

You can design a Google form with this functionality directly in the form. Use a multiple choice grid with options "require 1 response per row" and "limit to one response per column". Example. This would work better for a poll with fewer options; the fixed width of Google Forms is an issue here. Unfortunately, this issue will only get worse with new ...


3

Short answer Add a new sheet. Add the following formulas to the new sheet Cell A2 -> Headers =OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,0) This could be repeated several times, one for each header column, just change the last parameter accordingly. Cell B2 -> data =OFFSET('Form responses 1'!$A$2,ceiling((row()-1)/5,1)-1,mod(row()-2,...


3

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 set it to send responses to ...


3

You can't. With anonymous people filling in the survey there is no way to tell if they have done it more than once. You could have the users enter an email address into the form and then use Google Apps Script to check. However, if they enter a different email address you are back to square one.


3

You need to use the google.script.run.myServerFunctionName() client side API. You will need to use that anyway, in order to send the form data, unless you are using a HTTPS GET or POST request to send the data somewhere. Apps Script documentation - google.script.run


2

Filter view One tool that can be used for this purpose is a filter view. Create a view in which the responses are sorted by column A in reverse order (Z to A). Copy the URL of this view and share it with the users who are supposed to view the response sheet. A drawback of filter view is that if a new response arrives while a user is looking at the ...


2

Short answer Google Forms doesn't include a feature to hide questions. Explanation Google Forms could use page navigation to control wich questions will be available for the respondents but it's controlled by multiple choice questions, not by users ID. Alternative Create an specific form for each set of users then send to each of them the corresponding ...


2

Short answer Google Forms doesn't include a limit on the number of responses as built-in feature but you could extend the of Google Docs editors features though add-ons or Google Apps Script. Alternatives formLimiter From: https://sites.google.com/a/newvisions.org/scripts_resources/add-ons/formlimiter formLimiter automatically sets Google Forms to ...


2

I have just hit this problem, but unfortunately I don't know the number of digits I'm expecting so I don't know how many zeros may be missing. Luckily I thought of this before I sent the form out, if you already have responses then this won't help (unless you send it out again). To solve this problem I have: Set the question type to "Text" Under "Advanced ...


2

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 users. You mention: ...but I'd like to then make that field hidden to help not confuse people who are filling out the form Assuming I read your question ...


2

Google Forms doesn't supports hidden form fields but Google Apps Script HTML Service does.


2

At this time isn't not possible to delete a single response from the responses repository attached to the Google form. One alternative is to save the responses to another repository delete all the responses from the form and submit again the desired responses. Another alternative is to edit the duplicate response. References FormResponse - Google Apps ...


2

One approach is to add a status column next to the data input: for example, in L10 it would be =if(iserror(match(H10, H11:H, 0)), "current", "obsolete") which returns "current" if no entry below the present row has the same email. Then your query can filter out the obsolete results. The above does not work with arrayformula. I don't think there is an ...


2

Google Forms by itself has not a way to limit access by groups of the same domain. You should keep the link for respondents "secret". One alternative is to create a group including all the seniors. The group could be created by one of the Google Apps domain administrators, by any allowed to create groups through Google Group for Business (it's include in ...


2

Is the form configured to be limited to a single response? Instructions to unset this (modified from google's online help) are: New Google Forms (No "File" menu at top) Open the form. At the top, click the Settings icon . Un-check the box next to Can only submit 1 response. Old Google Forms ("File" menu visible at top) Open ...


2

The OP added that he used Sneaky Sheep which apparently takes the HTML from a respondent Google form and delivers HTML files. Every time that the original HTML from a respondent Google Forms, due to a change made by the Google form editors or due the HTML output generated by Google, the HTML files should be generated again. It's worth to say that: ...


2

Use copy & paste 1. Reference 1: Quick tip: Copy and paste a list into Google Forms, Google Drive G+ page.


2

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 ...



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