Table report sorting

Is it possible to have the table sorted to a specific column when the report is first loaded/viewed?

Thanks!

Hi,

May I know what kind of Report you are using? Is is an HTML Listing, Grip Listing, etc...?

I see there are some concerns regarding sorting the report at first load, but the problem is that when you receive a submission, the new entry will be placed in the next row or how the submissions are received. You can explore other options to make a saved filter like using the Excel Report type, although you will need to find a way to embed it or share to others.

But I will try to learn more of this, I will get back to you later on this day if I can make a workaround.

Thank you.

I am using the Table (HTML) report and want to embed it on a web page.

When a new submission is received it wouldn't appear in the report until it's refreshed, correct? Then if a column could be sorted (ascending or descending) on load/refresh, the new submission would be put in the correct place.

When you click on a column header, the code changes:

<th aria-label=": Descending sort applied, activate to apply an ascending sort">

Couldn't this be applied to a specific column on load?

Hi,

I understand that you want a specific column on the report to be sorted out whether descending or ascending once the page was loaded. Unfortunately that is not possible. The HTML Table Report does not save the filter you make on the report.

You can also try Grid Listing report.  You can also embed it on your website as well. Here's a guide on How to Create a Grid Listing Report (http://www.jotform.com/help/105-How-to-create-a-Grid-Listing-report)

Hope this helps. Thanks!

Ok, I created a Grid Listing, but how to I filter it so I specific column is sorted?

Hi,

To sort through it just click on the columns header and it will sort the data in the report based on it.

Do let us know if you have any further questions.

Best Regards,
Ben

And that keeps the sort order when the page is reloaded? I want a specific column sorted by default when the embedded grid or table is loaded.

Hi,

Sorry for the confusion. It is the same with HTML table reporting, it does not saved the filter either. By default the submissions are sorted based on the submission time.

Thank you for understanding.

Hi,

Just a follow up on this. I tried making a workaround, but unfortunately I was not able to have a success on making a saved filter for the reports, I was trying to use javascript to changed the filters when the page load, but it is not possible because the iFrame code which has a different domain makes it impossible to pass and receive from the parent page. Although I saw that the "Visual Report Builder" has a saved filter setting under "Grid".

But the problem with this is it has a very limited way of customizing the report and the widths are fix.

We can still explore other ways, but right now it is not possible to have a specific saved filter on page load.

Thank you for understanding.