What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.


  • Profile Image

    Table report sorting

    Asked by ccreport 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?

     

    Thanks!

    table table report sorting html table grid listing
  • Profile Image
    JotForm Support

    Answered by Charlie on October 27, 2014 at 09:03 PM

    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.

     

  • Profile Image

    Answered by ccreport 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?

     

  • Profile Image
    JotForm Support

    Answered by Jan on October 28, 2014 at 06:49 AM

    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!

  • Profile Image

    Answered by ccreport 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?

  • Profile Image

    Answered by Ben on October 28, 2014 at 02:20 PM

    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

  • Profile Image

    Answered by ccreport 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.

  • Profile Image
    JotForm Support

    Answered by Jan on October 28, 2014 at 04:58 PM

    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.

  • Profile Image
    JotForm Support

    Answered by Charlie on October 29, 2014 at 08:30 AM

    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.