Does Jotform has a feature to query submitted data to produce a report?

  • Profile Image
    pstacks
    Asked on June 10, 2015 at 08:54 AM

    I have created a form that gathers player data (demographic, school, game stats, etc).  This data will be viewed by coaches in recruitment for college.  I currently have the form integrated to Google sheets which can be viewed on the site as a table.  I'd like to make it possible for a coach to query that data based on player name and produce a report in something like a PDF.

    The intake form (http://pstacks.com/form1/) is currently on a testing site.  The stats from google sheets is here: http://pstacks.com/player-stats/

     

    Thanks.

    Pressley

  • Profile Image
    Carina
    Answered on June 10, 2015 at 11:23 AM

    It is possible to download the form submissions in PDF, but this would include all the fields in the form. In order to do so please go to My forms > submissions:

    What kind of query would you need?

    We'll wait for more details to proceed.

  • Profile Image
    pstacks
    Answered on June 10, 2015 at 11:57 AM

    The query would be one where a coach ( say Coach Smith) could get all data from a single player submission ( player Michael Jordan ).  My data table would most likely eventually show only the most critical data.  The report from query would contain all player data in a pdf format.  It would even have to be a PDF.  It could also be a printable web page.

  • Profile Image
    david
    Answered on June 10, 2015 at 01:35 PM

    I do not believe what you are looking for is currently possible.  It is possible to create a live grid list of your data:

    http://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report

    But this is similar to simply having the data in a Google Spreadsheet.  The only way to create a PDF of the submission data would be from the submission view of your account as described by my colleague, or view a link in the submission notification:

    http://www.jotform.com/answers/503347-How-to-add-pdf-download-link-in-notification-email

    I do not believe it would be possible to include the PDF capabilities elsewhere.