Hot answers tagged google-forms
7
The summary is stored independent of the current data inside the spreadsheet. So right now, you can't change or update it without destroying the data and form.
One suggested workaround is to create your own summary, making your own charts/graphs from the data, and send the link to that out.
6
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 ...
5
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 > ...
5
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.
4
The problem has been solved - the only way to remove responses from a form (after testing it, for example) is by deleting the entire row of responses.
This can be done either of two ways:
Before either method, select the response rows you wish to delete.
Right click on the highlighted rows and select, "Delete rows [whichever rows you selected]."
Under ...
4
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.
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 ...
3
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
3
I only seem to have some bad news for you.
It is not possible to customize Google Docs Forms in another way than using the provided themes. (See Google employee AnaLikesLattes' answer)
It is not possible to enforce one-submission-per-person but you could maybe use required fields asking for first/last name or email. (Google Docs Help discussion)
I'm not ...
3
Currently, the only place you can put hyperlinks in a Google form is in the second box from the top (aka the description box). Anywhere else and the URL wont be clickable.
To add a URL to the discription box simply type the URL with or without the http://. You dont need to add any HTML markup. eg Typing google.com will result in google.com
Its a feature ...
3
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 ...
3
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:
...
2
There is in fact a solution to this problem; however, you must disconnect the form from being hosted on Google's servers in order to accomplish this.
The idea is that you copy the form HTML to your server. The form itself will continue to submit data to Google Spreadsheets, but you will have full control over the look and feel of the form.
Be forewarned! ...
2
Saw this answer on a blog:
First the document in question must be publicly accessible. Private documents
cannot have an RSS feed.
Click the SHARE button in the top right and share it with others as
"Collaborators" and not just "Viewers". Next, click the link on the same page,
toward the right that says "View RSS".
2
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.
2
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 = ...
2
If you were given the link but do not own the form, then no - responses are private unless the response spreadsheet is shared with you.
If the response spreadsheet was shared with you however, then you can just search for that document title in your Drive list, and it will appear as a normal shared document.
No idea how Drive generates document keys, but ...
2
With the following guidance, you should be able to retrieve the info:
First you need to open a new spreadsheet.
Select the "old" spreadsheet again.
Open the revision history:
If you select the desired version, then you can restore that version:
Copy the content of the sheet into the newly created spreadsheet.
After you've copied the info, restore back ...
2
You should be able to get a 'fresh' form by deleting the entry rows. That is, select the entire row by clicking the row number(s), right-click, and choose Delete row.
(source)
I just did the following test case:
Create a simple form
Submit a response
In the spreadsheet, select the response row, right-click, delete row
Submit a new response
Result: The ...
2
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 ...
1
Still don't have a solution for how to directly get values of unchecked checkboxes, but I was at least able to write a function that compares the correct answer to the submission.
This splits the correct answer into an array then compares each item to the submission:
function checkAnswer(answer, key) {
var kArray = key.split(', ');
var nArray = [];
for ...
1
If you add the following formula in cell D2:
=ARRAYFORMULA(FILTER(C2:C;C2:C<>"")*1.2)
then it will take on the complete column, via the array. The FILTER function, is to make sure no empty cells are taken into account.
I've added the result into the file you shared with us.
1
Many online form builders let you do this through branching where branching is just simple logic. If a user answers one way show this question, if they answer another way show this other question.
Wufoo and Formstack are two form building software that support this.
Links point to the feature page on branching/conditional logic.
1
No, that is not possible in the standard Google Spreadsheet forms.
If you're capable of a little programming, you could implement your very own form with the Google Apps Script GUI builder. The GUI builder has a file upload element.
1
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 ...
1
One way of doing this and saving white space is to use a "Grid" option.
When making/editing your question, choose the "grid" type of question. This will allow you to create a multi-row question in which all rows must be filled out if the question is required.
In the screenshot you can see that each row would be a single condition of the terms, and there ...
1
Theres a workaround using a spreadsheet to access the form.
A few useful examples are available in this thread;
http://www.google.com/support/forum/p/Google%20Docs/thread?tid=039da52385b9d224&hl=en
Hope this helps.
1
Google Spreadsheet Forms comes under Google Docs.
The form must be shared either with the setting, Public on the Web - it will show up in Google Search results or Anyone who has the link, anyway you cannot find the e-mail address of the owner of the document. As that would be a great security loop-hole on the side of google, anyone will know what company is ...
Only top voted, non community-wiki answers of a minimum length are eligible
