How do I print the entire form summary

Showing 1-42 of 42 messages
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!

thanks!
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
"Would there be a reason not to show all the answers?"
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: "Forms: Viewing form responseshttp://docs.google.com/support/bin/answer.py?answer=139706&hl=en

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


"Do you mean the address of the summary popup window when you say "copy the link"?"
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:
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!

"Do I need to send out invites with the permission to view?"
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

I took

https://spreadsheets.google.com/gform?key=0Am...nc&hl=en&gridId=0#chart


and replaced it with

https://spreadsheets.google.com/viewanalytics?key=0Am...nc&hl=en&gridId=0#chart


I tried publishing the page, and still didn't change anything - did I miss something, did this technique work for other people?


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"
4. Save
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.

Clean up:
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".

/Jesper
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 shift
and 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 madmkh 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.
 
HTH
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
@tham
I have the exact same problem
I 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
Thanks

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.

"3. enable "Let everyone see response summary"
4. Save
5. close window"

This advice did work, but is a pain.

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

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??!!!
More topics »