How do I create a report of comments?

  • Profile Image
    SUAA
    Asked on March 12, 2013 at 10:35 AM

    I have a survey that has a comment box.  How do I create a report listing just the comments?  I made an excel report with just the comments selected and that worked great except when I saved it as a pdf all the comments were cut off at the end, ie. the comments didn't wrap to the next line.

     

    http://suaa.org/surveyPensionReformConsiderations2013-2.php

  • Profile Image
    KadeJM
    Answered on March 12, 2013 at 11:26 AM

    You could use the Gridlisting method to create this via a comment field. Then you can either share it, link it or embed it. Please check it out and let us know if this is something that might work for you.

  • Profile Image
    SUAA
    Answered on March 15, 2013 at 11:05 AM

    http://www.jotform.com/grid/30734114819048

     

    I tried the grid listing and it gave me the results but with large expanses of spacing between answers because of those who did not answer the survey.  It will only print out 1 page at a time.  I need something in a pdf or word doc or something easy to manipulate to get it in a more condensed form to print.

  • Profile Image
    KadeJM
    Answered on March 15, 2013 at 11:51 AM

    Unfortunately I don't think or know of a current way to setup a report of comments via a pdf or word doc so I'm not quite sure that would work. The only way the pdf is configured to work with our forms as of now is to create a pdf form, send data as pdf to google drive or dropbox from your form, download submissions as pdf, or embed a pdf on your form. The word doc is only workable to through uploading it as an allowable file type and both of these together to create that. You would have to manually copy and paste it or possibly send some post data to create it with some sort of custom scripting outside of JotForm with the form's source code.

    If you are having a problem with blank submissions from people not filling out the survey then a simple recommended way to help combat that would be to add a captcha field which will help to prevent spam and bot attacks creating empty responses.

    Alternatively though you could also go the Google Spreadsheet Integration route and share that via a link as it is also stored online, savable, embeddable, and you can manipulate the stored data some.