Submissions not sorting correctly

  • TerriH
    Asked on August 12, 2015 at 10:35 AM

    Hello,

    Lately, as I have gone in to sort our submissions, they are not sorting correctly when it's by dates. For example, we have a column called "Final Art Due Date". When I go in to sort this column in descending order, it doesn't sort it correctly.

    At first, I thought it was the date format we using. So, I went in and changed all them to be consistent. But, that didn't work either.

    Can you help me out?? :)

    Thanks, 

    Terri

    (I've attached a screenshot where I have sorted the "Final Art Due Date" column descendingly. Also include the url.)

    Jotform Thread 636337 Screenshot
  • Elton Support Team Lead
    Replied on August 12, 2015 at 12:22 PM

    Sorry but I see no problem on your screenshot. It shows the data in descending order base on "Final Art Due Date" field not with the submissions date, just to clarify. 

    If you'll focus on that column only, you see the dates are sorted in descending order.

    Submissions not sorting correctly Image 1 Screenshot 30

    Perhaps what you need is to sort them base on the submissions date?

    Submissions not sorting correctly Image 2 Screenshot 41

    Please take note that the data grid does not support sorting base on multiple columns. It can only sort data base on a single column.

    Thanks!

     

     

  • TerriH
    Replied on August 12, 2015 at 12:35 PM

    Sorry about that. I did not take the correct screenshot apparently. I actually can't give you a correct screenshot as we have had some additional forms submitted and I can't get my screenshot big enough to show you what it's doing. 

    But after digging through it some more, I believe it's because of how the dates are formatted. I may have fixed the problem.

    If not, I'll let you know...lol

    Thanks!!

  • Jeanette JotForm Support
    Replied on August 12, 2015 at 2:13 PM

    Glad to know you have fixed the problem. Let us know should you need further help.