Sorting date problem on HTML Table Report

  • dmichaels
    Asked on June 30, 2015 at 12:10 PM

    I seem to have a problem with sorting a table in a grid report (dates)

    http://www.jotform.com/?formID=51789073726971

    Could you please take a look and tell me what's wrong? I realize that I've mucked up some of the dates in the date dropdown by adding trailing text, but if that's the reason for the problem, I still don't understand what it is actually sorting on.

    Thanks,
    David

  • Elton Support Team Lead
    Replied on June 30, 2015 at 12:16 PM

    Hi David,

    I checked the grid report of that form and it is sorting accordingly.  

    Sorting date problem on HTML Table Report Image 1 Screenshot 30

    Sorting date problem on HTML Table Report Image 2 Screenshot 41

    If this is not what you are referring to, kindly provide more details. Thanks.

  • dmichaels
    Replied on June 30, 2015 at 3:33 PM

    Very interesting...

    Indeed, the Grid Report does sort correctly when you view it outside of the form; but embedded in the form, it does NOT sort the same way. Now THAT is strange.

    I'm hopeful that you'll have an easy simple answer.

     

    Thanks,
    David

  • Mike
    Replied on June 30, 2015 at 4:56 PM

    It seems that filtering issue is related to HTML Table listing report. Please replace the report embed code with the actual Grid Listing code to fix the issue.

    Thank you.

  • dmichaels
    Replied on June 30, 2015 at 5:13 PM

    I'm sorry to day, I don't understand what you mean.

    How would I do that?

    David

     

  • dmichaels
    Replied on June 30, 2015 at 5:50 PM

    OK - I gave it a try and it now appears to work. I changed the iframe code supplied by JotForm to this:

    <iframe src="http://www.jotform.com/grid/51800806092046" frameborder="0" width= "100% height = 600px min-height: 700px; border:none;" scrolling="auto"></iframe>

    Without spending a lot more time figuring out exactly what was wrong, I do see that JotForm code looked like this:

    <iframe src="http://www.jotform.com/grid/51800806092046" frameborder="0" style="width: 100%; height: 100%; min-height: 500px; border:none;" scrolling="auto"></iframe>

    I see width= instead of width: as one difference.

    I'm not sure if the way I set it up the grid will automatically grow when needed.

    Thanks,

    David

  • dmichaels
    Replied on June 30, 2015 at 5:56 PM

    MY code now looks like this (a slight change as whatever I had before was wrong):

    <iframe src="http://www.jotform.com/grid/51800806092046" frameborder="0" width=600px height= 600px; min-height: 500px; border:none;" scrolling="auto"></iframe>

    It appears to be working.

    Thanks,

    David

  • Mike
    Replied on June 30, 2015 at 7:02 PM

    What I mean is that there are two reports associated with your form, Grid Listing and HTML Table Listing.

    Sorting date problem on HTML Table Report Image 1 Screenshot 20

    The HTML Table listing has incorrect filtering in this case. Now since you have embedded the Grid Listing report to the form, the filtering appears to be fine on form.

    Thank you for cooperation in this matter.