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

    Submissions not sorting correctly

    Asked by TerriH 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.)

    Page URL:
    http://www.jotform.com/submissions/51095973604965

    Screenshot
    Submissions sorting correctly format thanks
  • Profile Image
    JotForm Support

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

    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.

    Thanks!

     

     

  • Profile Image

    Answered by TerriH 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!!

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on August 12, 2015 at 02:13 PM

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