JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Submissions not sorting correctlyAsked by TerriH on August 12, 2015 at 10:35 AM
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?? :)
(I've attached a screenshot where I have sorted the "Final Art Due Date" column descendingly. Also include the url.)
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.
Perhaps what you need is to sort them base on the submissions date?
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.
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
JotForm Support Manager
Glad to know you have fixed the problem. Let us know should you need further help.