|How do I print the entire form summary||waldene||1/29/09 7:16 AM|
When I try to print my form summary I only get the first page
|Re: How do I print the entire form summary||ahab||1/29/09 7:19 AM|
Printing the summary is not really supported... :(
|Re: How do I print the entire form summary||waldene||2/6/09 8:06 AM|
That seems like it would be a really useful feature. Has there been any talk of adding it in?
the summary is great but it is not really very useful if you can't print it out to share.
|Re: How do I print the entire form summary||0613Geo||2/17/09 7:32 PM|
I really need this feature to work also. Google, please consider letting users print this valuable information. Visual representation of data is what most people do to view results.
|Re: How do I print the entire form summary||parabol||2/18/09 12:29 AM|
This feature is really a must !! Crazy not to have implemented that one.
|Re: How do I print the entire form summary||canimbill||2/19/09 1:20 PM|
The form summary and the use of forms to do community surveys is a GREAT idea, thank you Google! However, someone seems to have dropped the ball when it comes to USING your survey. The form summary looks great, I could use it, but i've tried copying and pasting into several different applications (google document, google presentation, MSWord, html editors, etc.) but it never comes out very well. So what good is creating a survey if you can't work with the results?
I would really like someone to take it one step further and add a button somewhere to drop the form summary into a google presentation, one slide per summarized question. For me that would make the whole thing a killer app!
|Re: How do I print the entire form summary||yvonnedtu||2/24/09 5:00 AM|
I do hope Google guys look at this! - It is a major flaw! - We have made a nice survey. I never anticipated having problems with something THAT basic! - It makes it VERY difficult to prensent the results to anybody.
|Re: How do I print the entire form summary||preciseplastics||2/24/09 5:55 AM|
How can you give someone a tool with visual representation that they cannot print out the results to show someone??????????? Printing the summary is a must!
|Re: How do I print the entire form summary||cbjameson||2/25/09 6:47 PM|
Work around time. Open the summary page (in Firefox in my case). Ctrl+a to Select All, Ctrl+c to Copy. Open a new document in (my case) MS Word 2007 (the one with the ribbon), Ctrl + v to paste. It drops more than you want (the form at the top, the editing options at the bottom) but is quite manageable. In our case the form had three paragraph text fields that were truncated in the summary. To get those, highlighted the range, used the Docs copy command, opened a new sheet, and used the Docs paste command. Then exported that sheet as a PDF. Hope this helps.
|Re: How do I print the entire form summary||lroseboro||2/26/09 9:34 AM|
If using a mac computer, to be able to select items on screen to copy, hold down the following buttons-shift, control, command and 4. Then use cursor to highlight what you want. Paste in word. Can make a pdf from there.
|Re: How do I print the entire form summary||dmd1||2/27/09 6:49 PM|
Puzzling that Google invested in something that cannot be SHARED:
- you cannot print and send a PDF around
- there is no way (at least I haven't found any) to send a direct link to the survey summary, without having to share the whole spreadsheet
I would really like to see this. I ended up converting all the data to Excel, just to generate a couple of graphs and share them around - a shame.
|Re: How do I print the entire form summary||diggerB||3/10/09 9:36 AM|
For those of you on a Mac (I know, not many), here's a workaround that I found:
1. Select the entire summary and copy
2. Open TextEdit and paste into a blank document
3. Save as web archive and reopen file (fixes some formatting issues)
4. Print as PDF
Once the file was saved, you could edit the text, but not the graphs. Hope this helps people.
|Re: How do I print the entire form summary||bumparocky||3/12/09 9:50 AM|
The MS Word workaround worked for me too.
I thought MS Frontpage would also work in a copy/paste scenario but it did not.
I thought putting the address into a full broswer page might work but it did not.
What you need is a subset of the standard google docs menu that exports to PDF reader and print from there.
IHMO a PDF export would be fine....
similar to the way printing works for the whole Google Apps suite.....
|Re: How do I print the entire form summary||Godot123||4/3/09 3:55 AM|
Is it possible to print the whole summary? At this time if there are too many answers for a question, I see 3 points (...) at the end, thus I don't see all the answers in the summary.
Another nice option would be to export the whole summary to a pdf file from which one could off course print it too.
It is very important to see all the answers in the summary, for example to share it with others. Would there be a reason not to show all the answers?
|Re: How do I print the entire form summary||ahab||4/3/09 7:00 AM|
Because all the answers are in the associated spreadsheet. It's a summary, it's not intended to print all data.
|Re: How do I print the entire form summary||mswanson||4/23/09 7:37 AM|
If you copy the summary (command-a, command-c) and then paste (command-v) into Pages (iWork for Mac) it shows up nicely. Then I just convert it to pdf.
I have had to do this for FOIA requests and it works well.
|Re: How do I print the entire form summary||Godot123||5/7/09 7:00 AM|
So why would Google docs offer this summary in the first place, ahab? In my opinion, it's a nicer way to present the data and print the data instead of printing the spreadsheet.
I'm asking to take my proposal into consideration and show all the answers in the summary (or offer both a summary and a total overview).
Besides that, it can't be that hard to offer a function to export an overview to pdf. The export to pdf already exists in many features of Google docs.
|Re: How do I print the entire form summary||ahab||5/7/09 7:19 AM|
The form summary can now be printed (albeit only using the browser's print functions). See: "http://docs.google.com/support/bin/answer.py?answer=139706&hl=en"
What you propose seems to be a pre-formatted total overview of the submitted data. This is not that much different from printing the spreadsheet itself, which gives you more control over the printed result (e.g. you can hide certain columns or add computed results). And this will offer you already the option to create a PDF. IMHO an additional 'total overview' page is superfluous because of this.
|Re: How do I print the entire form summary||InfiniumEtAl||6/2/09 8:53 AM|
I am interested in seeing the summary as an embed feature into igoogle, Google/site, another spreadsheet, presentations, etc.
The email summary of who responded is not enough. The visual presentation is easier to digest at a glance, especially when viewing it daily.
|Re: How do I print the entire form summary||a314sces||6/4/09 2:45 PM|
Using Microsoft Word, you can get great results with select+all, copy, and paste+special. Select RTF (rich formatting) and it comes out great.
|Re: How do I print the entire form summary||digied||6/8/09 1:53 AM|
How can i send a viewable link to form summary (without sharing the spreadsheet) or embed it?
i still didn't see any answers to this :(
btw. congrats to google for a great job on the forms. it's great
|Re: How do I print the entire form summary||toys||6/10/09 2:05 AM|
I also like to share the summary without them having to login.
|Re: How do I print the entire form summary||ahab||6/10/09 3:58 AM|
To be able to let everyone see the response summary without the need to log in do the following:
Go to the Form Editor (in the spreadsheet associated with the form: Form->Edit form
In the Form Editor click on More actions and select Edit confirmation message.
In the window that pops up, tick Let everyone see response summary.
Don't forget to Save the change to the confirmation message.
Now you can open the Summary (in the spreadsheet Form->Show summary) copy the link to the summary and distribute it.
|Re: How do I print the entire form summary||jrabbott||6/27/09 7:42 PM|
I tried the "Let everyone see response summary" and it still tells people who do not have access to the spreadsheet that they do not have permission.
Do you mean the address of the summary popup window when you say "copy the link"?
Do I need to send out invites with the permission to view?
|Re: How do I print the entire form summary||ahab||6/28/09 6:45 AM|
"I tried the "Let everyone see response summary" and it still tells people who do not have access to the spreadsheet that they do not have permission."
Are you using an Google Account that is part of a Google Apps for your domain account? The admin may have restricted sharing and publishing outside the domain.
Yes that is the link I was referring to. Note apparently there have been minor changes with the latest update of Google Docs spreadsheet that restrict access to the thus copied summary link.
Hence the following:
The link should look something like https://spreadsheets.google.com/gform?key=r0jfahieVJwYzB_l7zALvtw&hl=en&gridId=1#chart
Change in your link gform to viewanalytics, like this https://spreadsheets.google.com/viewanalytics?key=r0jfahieVJwYzB_l7zALvtw&hl=en&gridId=1#chart
This new link should be publicly viewable, i.e. without any sign in window popping up.
(Note the above summary is of a test spreadsheet of mine and not containing any meaning.)
Also note there apparently is a bug/feature that makes Form Section headers show up in the summary!
No, the 'viewanalytics' url should be accessible to anyone without the need to sign in, so invites are not needed.
|Re: How do I print the entire form summary||raidergyrl||7/1/09 7:45 PM|
How to save the Google Docs form summary with a PC:
With the summary open,
1. right click on it
2. select save file as (by default, it's called gform.htm)
3. open your saved file
4. it will open in your browser and you will have the file/print pull-down menu to work with
**Note: I'm not sure if this summary excludes data that's been deleted, or includes data that's been added without using the form
|Re: How do I print the entire form summary||ahab||7/2/09 1:19 AM|
"**Note: I'm not sure if this summary excludes data that's been deleted, or includes data that's been added without using the form"
I'm sure it doesn't, deleted data or data directly entered in the spreadsheet are never reflected in the summary.
|Re: How do I print the entire form summary||sdrahcir||9/2/09 8:52 AM|
I tried the viewanalytics suggestion and am getting "opps" "It looks like the form "..." does not have published results
and replaced it with
|Re: How do I print the entire form summary||EulaMac||10/14/09 10:30 AM|
I found a solution using CutePDF.
Download it here -> http://www.cutepdf.com/products/cutepdf/Writer.asp
1) Install CutePDF
2) Navigate to Show summary response page.
3) Select Print from your browser and select CutePDF
4) Print your summary to PDF -
|Re: How do I print the entire form summary||joost_vp||10/23/09 10:14 AM|
I found a solution to "easily" print the Summary of Responses:
1. Select the alle the tekst and graphs from the summary of responses
2. Copy paste everything in >>OneNote!<<
2a. In OneNote all the graphs and tekst appear quite nice and really quick!
2b. For if i copy everything in Word directly, things tend te get messy, and some of the graphs won't appear
3. After copying it all into OneNote, you can either:
3a. Print directly from OneNote
3b.Select everything in OneNote and copy paste this to Word. Then you get all the tekst and graphs nicely in Word.
Hope it helps others.
|Re: How do I print the entire form summary||Jesper Ordrup||10/24/09 12:30 AM|
Workaround using only the browser:
First we need to allow public access to responses:
0. You've opened a spreadsheet with responses.
1. Edit form
2. more actions, edit confirmation
3. enable "Let everyone see response summary"
5. close window
Now we can access the stats by changing the address in browser:
0. You've looking at the spreadsheet with responses.
1. Form menu, Go to live form
2. Look at the address in the browser. Replace the part "viewform" with "viewanalytics" and hit your enter key.
3. The summary should be displayed now in your browser.
4. Print or whatever you need.
If you don't want everybody to see the response summary after submitting a form entry, please remember to disable "Let everyone see response summary".
|Re: How do I print the entire form summary||sebasibarguen||11/1/09 10:49 AM|
Hey, I was able to easily copy-paste all the contents in a new
Google Document. I only copied the "inside" of the from,
or where it say's "# Responses",
until the last question (I did this by selecting the first part then shiftand then clicked the end of the form). Then just simply paste it in a new
Google Docs. (I did it in Safari, don't know if it will work in another browser).
|Re: How do I print the entire form summary||devitol||11/3/09 11:53 AM|
It seems like EulaMac advice no longer works as Google added an internal scroll to the Summary of Responses....worked for a bit at least.
|Re: How do I print the entire form summary||yvanox||11/4/09 6:46 AM|
I fund something quite simple...
Cut and paste the entire page in FrontPage, a little clean up, copy/paste in word and print to PDF !
|Re: How do I print the entire form summary||aarin80||11/12/09 11:17 AM|
I have a solution! That's if your on an Apple Computer. I think you can do this with a Microsoft product called OneNote, but it will be a huge project, because it's a Microsoft Product.
This is what you do:
Print (select the option PDF and save as a PDF) each section of the screen (your data results). It took me eleven "print to PDFs". (might want to create a new folder on the desk top (or wherever) to make this next step easer) (ALSO, save each file as a page number; 1,2,3. . . (so you can keep them in order).
After you do this, reopen all of them in Apple Previewer (if they don't all open don't worry, you can just add the pages to this program that did not open, "drag and drop"). This is why I said to number them.
Finally, select all pages within Apple previewer and "print to PDF". Now you have all the pages in one PDF file. To save paper etc. print 2 pages per 1 and back to front. This is also possible with Apple.
|Re: How do I print the entire form summary||jnielsen||11/12/09 7:47 PM|
The form summary isn't something that I used a lot for this, but I found a way to print or email out a tidy page created from each form sent in. I downloaded openoffice and created a new text doc. Then I downloaded a copy of the spreadsheet to my computer. I then added fields (Menus: Insert .... Fields.... other) into the new document which imported the data from the spreadsheet columns. I then used the Mail Merge feature (Tools menu) to create a 400 page merged document for the 400 people that used my google form. I even imported my email settings into OpenOffice and using the email address people gave me in their form entries I sent them back the info that they typed in the form. For a spreadsheet backup this was a nice way to print a one pager for each entry on the form. It took some learning though.
|Re: How do I print the entire form summary||Mattias Lönnqvist||11/13/09 6:08 PM|
Now I've tried most of the advice given in this thread, and I still can not print (or save) my entire summary. I created a test spreadsheet ( here: http://spreadsheets.google.com/gform?key=0Ar6uU5W5tVPIdDZBc2hWekN0eHF3Ym5CRlVyc3NEWVE&hl=en&gridId=0#chart - it should be public) but whenever I try to print it I only get the first question.
Printing simply doesnt seem to print all answers, only the first of them. I've tried this in both Chrome, FF and IE but it's the same in all for them.
Spreadsheets works really nice, and the summary would be great if you could actually use it, but since it isnt printable (or exportable) the functionaly becomes very very limited for this part.
|Re: How do I print the entire form summary||Terry10_100||11/16/09 9:02 AM|
I did use Jesper's workaround, and it was successful. Way too tedious for what should be a simple and straightforward procedure, however.
|Re: How do I print the entire form summary||MandyH||11/18/09 2:43 AM|
I tried the copy/paste to Word workaround and my Word crashed :0.
So then I tried copying (by click and drag through the summary rather than select all) and pasting to a google document and it copied over beautifully and printed to a pdf document, also beautifully.
|Re: How do I print the entire form summary||tham||4/14/10 1:35 AM|
For printing I rightclick on summary, print it to a pdf woriter (I use primo pdf = free), convert the pdf to word using one of the many free converting programs or sites.
My problem is that a lot of my respondents write long comments and the space for comments is very limited. Any way around this?
|Re: How do I print the entire form summary||boelleand||4/21/10 1:43 AM|
I have the exact same problemI need the Show Summary of Responses sheet to show all the responses that my students have submitted.
Basically whenever there is a textbox question in the form and I get say 30 responses to that question, each answer is a 10-word answer, I get only the first few answers displayed in the summary and then I get the "3 dots"... which replace the rest of the answers. For space sake I assume.
I would like a summary sheet that views all the answers no matter how long or how much space they take.
Any way around this?
Would be much appreciated
|Re: How do I print the entire form summary||myrockmyshelter||9/8/10 4:43 PM|
I have tried all the advice on here.
When I try to do this part, it will not let me save. Just give me a "Oops there was a problem saving"...over and over again.
This advice did work, but is a pain.
What people are asking for is simple...a FULL report of the results in a nice easy to view layout, i.e. the Response Summary layout (or a report like MS ACCESS has.....rolls all the data up into a full report...not just some of it).
Please.....pretty please with sugar on top Google??!!!