Browse Article by Topicsreports html grid visual excel rss listing output
- Adding a Form to a Web Page
- How to Export Form Data to Excel
- How to Download Form Submissions as Excel/CSV/PDF?
- How to Create an Excel Report?
- How to Create a Grid Listing Report?
- Create a Submission Limit Using JotForm with PHP and RSS Reports
- How to Create a Visual Report with Your Form Submissions
- How to Save a Form
- How to Create an HTML Table Listing Report?
- How to Create an RSS Listing Report?
Related Forum Questions
- Problem -- Whitelisting email addresses
- When I update a form, it doesn't email the new updated person
- Occasional stall on "please wait" after Submit button when using file-upload
- I can't export all submissions to Excel as some of them are missing
- How to download Encryption Form Submissions in Excel format?
- Time information does not have a separator in the imported data
- Reports of forms not emailing us.
- How do I sort submissions?
- Create complex form from Excel Spreadsheet
- Lost form submission data
How To Create Form Reports in JotFormLast Update: June 3, 2016
It does not matter if you’re running a small website, or a large organization- seeing your results in an easy to understand report is essential. JotForm not only gives you the ability to collect data from people, but also to view it in a variety of different types of reports. These allow you to see the latest updates from your users all in one place.
JotForm has several different reports that you can use, which are described below.
All JotForm reports hold the option to add password and protect them from any people that should not or no longer see them.
Benefits of JotForm reports include:
View an overview your submissions
Manage who and when can access / see them
Manage the data that can be seen
Access them from any location with an internet connection
Create as many as you need per form
Easily modify the report or remove it completely
To create a report simply navigate to the MyForms page, and select the form you’d like to create a report for. Then click the Report, and then Add New Report button.
This will bring up a list of possible report options for that form.
Select the report type you’d like, then follow the instruction below for it.
HTML Table Listing Report
Want to have a table, but do not want to have to open Excel every time? HTML Table Listing report is probably the option for you. It will allow you to quickly view all the form submissions online. You can sort them by name by clicking the field heading.
It displays thumbnails of photos, and you click them for a larger preview.
Take a look at it in action to see for yourself: HTML Table Listing Report
Most people, when they hear “report”, the first thing they are thinking is Excel. There is a good reason for this - it is simple and offers all functions that you need to collect, save and process your data.
For this reason we give you the option to download Excel file - to be able to utilize the power of Excel and make further calculations or business predictions.
If you are familiar with JotForm you will know there is also the option to download the Excel file from within the Submissions Panel. Downloading the excel file from the Submissions panel will give you all the results. The benefit to using the Excel report is that it will allow you to select only the columns you need.
The Excel report can be opened with any compatible application including Google Spreadsheets, Microsoft Office, Libre Calc and any other Excel alternative.
Check out the following link to see a sample of an Excel Report.
Grid Listing Report
Although the name may not have a lot of draw, this is one of our favorites. The reason is that it has all the features you need from a table like report, and many extras.
It is similar to the HTML Table Listing, but unlike it, you can hide or display columns as you please. This allows you to create custom reports as you go.
Another great feature is its search functionality. You can quickly find the info you’re looking for.
It automatically compacts the data from widgets or complex fields, such as the Address field. The empty fields are not shown. You can set it up in seconds.
Notice the bar in the bottom, which gives you more features:
Advance through the pages (next and previous, first and last)
Refresh submissions (to show the latest ones)
Displays the number of currently displayed submissions
You can see it here: Grid Listing Report.
This report is a staple for many, as it’s the most customizable and graphically visual. It allows you to take the parts that you want and display them in attractive charts and graphs, as well as including the grid format if desired. This is what monthly reports are made of along with quarterly and annual reports.
Take a look here for an example: http://www.jotform.com/report/50887607306057
Details on Visual Report filters can be found here, How To Use Visual Report Filters which allow you to create several Visual Reports each for a branch, segment, or particular piece of information that you’d like.
You may want to have a report for only a certain branch of your company and not include the values from other branches.
You can quickly sort through them by matching any or all filters. The results are shown immediately.
CSV reports are for those who might use Excel, or may prefer to load their information into a separate or custom built application. It’s an extremely simple way to transfer data- by separating each value by a comma.
Opened in notepad:
You can see it here: http://www.jotform.com/csv/50925237181050
This is a great way to see what data was received and when. Notice the ‘dots’ on the dates. Clicking them will open up a submission for that form.
If you click on it again it will bring up the full results of that submission.
Please see this link below for a full example of a calendar report.
RSS Listing Report
RSS is a type of feed that allows you to subscribe with any Feed app or application and get notifications of new submissions right on your desktop or your app. There are also browser extensions that allow you to read. Here are some example RSS Readers.
Here’s a sample JotForm RSS feed, which can be subscribed to via any RSS reader: http://www.jotform.com/rss/50925407016046
If you have any questions to ask, feel free to do that on our forum. We are more than happy to hear from you.