JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Does Jotform has a feature to query submitted data to produce a report?Asked by pstacks 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/
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.
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.
I do not believe what you are looking for is currently possible. It is possible to create a live grid list of your data:
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:
I do not believe it would be possible to include the PDF capabilities elsewhere.