- ccreportAsked on October 27, 2014 at 08:12 PM
Is it possible to have the table sorted to a specific column when the report is first loaded/viewed?
- CharlieAnswered on October 27, 2014 at 09:03 PM
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.
- ccreportAnswered on October 27, 2014 at 11:39 PM
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?
- JotForm SupportJanAnswered on October 28, 2014 at 06:49 AM
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!
- ccreportAnswered on October 28, 2014 at 12:04 PM
Ok, I created a Grid Listing, but how to I filter it so I specific column is sorted?
- BenAnswered on October 28, 2014 at 02:20 PM
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.
- ccreportAnswered on October 28, 2014 at 03:57 PM
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.
- JotForm SupportJanAnswered on October 28, 2014 at 04:58 PM
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.
- CharlieAnswered on October 29, 2014 at 08:30 AM
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.