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


10

Change that source URL to read http://spreadsheets.google.com/embeddedform?key=...KEYcode...&hl=fr. Adding &hl=fr is all it takes to change the language to French. BTW: this trick is overruled by the Settings of Google Docs of the client using your form. So problably it seems not to work on your own computer if you are logged in on Google Docs.


10

You can do this by adding a script trigger. Supposing your current Form has two columns Timestamp and the answer to one question. So you currently have columns A and B populating with data. Lets assume you want column C to have you auto increment number. You need to first go to Tools > Script Editor In the Script Editor window enter the following script: ...


9

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


7

There are different ways you can view a document made in Google Apps docs.google.com/spreadsheet/pub docs.google.com/a/domain.com/spreadsheet/viewform?formkey=FORMID docs.google.com/spreadsheet/viewform?formkey=FORMID Embed on domain of application Where 2 redirects to 3. Option 1 is most likely what you want users to see. Option 1 is found via File > ...


7

You need to provide the survey takers with the direct URL to the form - don't share it via Google Docs. To get the URL you need to: Open the form in question From the Form menu select Edit form This displays your form in edit mode and the bottom of the form the link is displayed: By sharing out the form as you did previously, you are allowing them ...


7

You'll need to create pages in your Google Form as well as relevant multiple choice questions to take you between these pages. For each page you set up, they will correspond with a multiple choice selection. Add a question type of multiple choice You will see "Go to page based on answer" appear as a checkbox next to it. Click that. The following ...


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

To get Radio Buttons on a Google Docs Form, you need set the Question Type to Multiple Choice


6

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

You have to format the column in spreadsheet mode before any data is entered. Here we have a form about waffles. The cells have been formatted before sending it to the recipients. And here is the result after a user fills out the result.


6

Further to the excellent answer by Barry, if you want to be able to remove rows, and still keep a unique ID you can have a static cell that maintains a count. You can then use this number and increment it on every new entry to the table. So the modification would be to keep a number somewhere on your spreadsheet ('M1' in the code below) and modify the code ...


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

Building on both previous answers (from Barry and Danny): Assuming the ID column is column A. Pick a "Next ID" cell and set it to the following formula (assuming it is in "P1"): =MAX(A:A)+1 Create script using the script editor under the "Tools" menu, and paste in the following: function onFormSubmit(e) { // Get the active sheet var sheet = ...


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

If you have Google Docs account then you also have access to Google sites. Create a Google Sites page and embed your form on it, then set the page permissions to private and enter those email addresses for the people you want to give access to. If they have a Google account, they can log in under their username. If not, they'll have to create an account ...


4

There isn't a way to password a protect a form within Google Docs at the moment.


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

You can do easily from your Internet Browser Go to File menu then choose Print try it using the following example : https://docs.google.com/spreadsheet/viewform?formkey=dFBSU1ZiYzZ6MUpGeE90X0lGTl8xQXc6MA Check the below images Chrome IE


4

I agree 100% with the OP that, while design specs are slightly different for print versus paper forms, they certainly are translatable. I was frustrated with the same problem, so I created a small web app called Google Paper Forms that will do exactly what you are looking to do: translate your Google Form to a printable, paper-ready PDF file. It ...


4

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


4

Yes, you can, by using the Go to page based on answer feature. This implies that you have to divide your form into pages, which is easy to do. Given you have already created your form with three questions: Do you like cats? Which kind of cat do you like most? Why do you dislike cats? Create a page for each section of your form: Click the Add item ...


4

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


4

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


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

You can also put 3 - 5 instead of 3-5. It worked for me.


3

I've been able to find a solution for my problem. Using =ARRAYFORMULA(Sheet1!A1:A) in the top of a column Google Docs will update the whole column, without the need for functions in each cell. Thus, deleted or inserted rows will not cause trouble anymore. I found this answer (by brettathds) at the Google Support forums.


3

In, for example, a Google Spreadsheet, you can use the File/Publish command. It lets you create a RSS feed for the spreadsheet.



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