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

    Sorting date problem on HTML Table Report

    Asked by dmichaels 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

  • Profile Image
    JotForm Support

    Answered by EltonCris on June 30, 2015 at 12:16 PM

    Hi David,

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

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

  • Profile Image

    Answered by dmichaels on June 30, 2015 at 03: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

  • Profile Image
    JotForm Support

    Answered by Mike on June 30, 2015 at 04: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.

  • Profile Image

    Answered by dmichaels on June 30, 2015 at 05:13 PM

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

    How would I do that?

    David

     

  • Profile Image

    Answered by dmichaels on June 30, 2015 at 05: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

  • Profile Image

    Answered by dmichaels on June 30, 2015 at 05: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

  • Profile Image
    JotForm Support

    Answered by Mike on June 30, 2015 at 07:02 PM

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

    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.