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

    Can you define a sort order in the html table report?

    Asked by pinkphurree on April 02, 2013 at 08:05 AM

    Hi, I have created a report based on the html table format and I would like to change to sort on a custom date column called Event Date instead of the submission date. Is there any way to define custom sort in the html format report any other format besides RSS?  Your forms have been a tremendous help to our nonprofit.  We have a couple of projects planned and I am greatful for jotforms making it easy for us to manage project tasks.

    Page URL:
    http://www.jotform.com//table/30897216237055

    table html table report table report style size font
  • Profile Image

    Answered by sidharth_kch on April 02, 2013 at 09:11 AM

    @pinkphuree

    An HTML table report has a function to sort the submission entries. You will see that sorting functionality in the header section of your report. This is enabled for every field.

    Let us know if you need further assistance.

    Thanks,

    Sidharth

  • Profile Image

    Answered by pinkphurree on April 02, 2013 at 09:36 PM

    Hi, Thanks for reply...Although I do find the sorting functionality most helpful,  it is not intuitive for everyone who views the report. We have a pretty low tech group of end users.  I was hoping to define a primary sort column within the report. That way the sort would be based the form's Event Date column and not the submission date column by default. I can always make a note with screen shot for those who are reading the report.  We love jotform service, it's been most helpful in managing our projects.

  • Profile Image
    JotForm Support

    Answered by jonathan on April 02, 2013 at 10:12 PM

    @pinkphurree

    Hi, 

    I can understand where the inadequacy is coming from. I also experienced the same case when I used google spreadsheet integration as means of generating the report. For some still not a verified reason, the google spreadsheet sort function is also useless on some scenario because it would not save.

    I have a test google report here. But every time I add new submission it would not follow the First Name sorting.

    I am sharing you this idea because maybe you will be able to find in your own way how to save that sorting filter in google spreadsheet.

    ---

    Another means I know to have a static sort for the submissions report is using the Excel report. If you have the means to publish the Excel or embed the excel into your web page, then the excel sort function is saveable. So, your sort filter in your excel file will be reflected in the embedded excel file.

    Hope this help.

    Thanks.