User Guide

 

How to Create Form Reports in JotForm

How to Create Form Reports in JotForm

Whether you’re running a small business 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, it also allows you to view it in a variety of reports. These reports go handy when you want to see the latest updates from your users in one place.

JotForm offers several reports that you can use, which are described in the detailed guides below:

🔘 HTML Table Listing Report

🔘 Grid Listing Report

🔘 Visual Report

🔘 CSV Report

🔘 Calendar Report

🔘 Excel Report

🔘 RSS Listing Report

This is just a brief overview of what each report does. For an in-depth instruction on how to set them up and which options are available for each, refer to the guides above. Some reports allow password protection to ensure that your Submission Data is safe and will only be shared with your peers.

Benefits of JotForm reports include:

🔘 View an overview of your submissions

🔘 Manage who can access 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, navigate to your MY FORMS page > select a form > click the REPORT ▼ menu > then ADD NEW REPORT.

This will bring up a list of all the possible report options for that form.

Excel Reports

You may be familiar with the option to download your data to an Excel file through the Submissions Page. Doing that will give you all the submission results. So, what's the difference? The benefit of using this Excel Report is it allows you to include/exclude the columns you need.

The generated Excel Report can be opened with any compatible application including Google Spreadsheets, Microsoft Office, Libre Calc and any other Excel alternative.

Example: https://www.jotform.com/excel/50907086543054

CSV Report

These are for those who might use Excel, or may prefer to load their information into a separate or custom built application. Using files in CSV format is an extremely simple and traditional way to transfer data between two end points.

Example: https://www.jotform.com/csv/50925237181050

Grid Listing Report

This is similar to the grid you see at the bottom of the Submissions Page. You can hide or show columns as you please which allows you to create a more flexible custom report. Another great feature is its search functionality.

The bar at the bottom has more to offer:

- Cycle through the pages (next and previous, first and last)

- Refresh submissions (to show the latest ones)

- Search submissions

- Displays the number of currently displayed submissions

Example: https://www.jotform.com/grid/50906888600057

HTML Table Listing Report

The HTML Table Listing Report will apply to users who want to share their submission data and present it as a table. It will allow you to quickly view all the form submissions online. You can sort them by columns by clicking the column name.

It also displays thumbnails of photos that opens with a larger preview when clicked.

Example: https://www.jotform.com/table/50906515524049

RSS Listing Report

If you're familiar with RSS feeds, this should work well with your favorite reader. On top of that, you can get notifications of new submissions right on your desktop or your app, just like how you get notifications about your favorite feed.

Here’s a sample JotForm RSS feed, which can be subscribed to via any RSS reader.

Example: https://www.jotform.com/rss/50925407016046

Visual Report

This report is a staple for many, as it’s the most customizable and offers a variety of visual options. It allows you to take the parts of your data and display them in 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.

You can quickly sort through them by matching any or all filters and the results are shown immediately.

Example: https://www.jotform.com/report/50887607306057

Calendar Report

This is a great way to see what data was received and when. Notice the dots on the dates below? Clicking them will open up the submissions for that particular date.

If you click it again, it will bring up the full results of that submission.

Example: https://www.jotform.com/calendar/50925115918053

Comments and suggestions are welcome below. If you have a question, post it in our Support Forum so we can assist you.

Send Comment