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

    Feature: Is it possible to add filtering option in Grid report.?

    Asked by kwvl on August 25, 2014 at 04:07 PM

    When i make a selection in my list of participants the sorting function of the rows is not working properly.

    Is there a solution?

    Jan

    Page URL:
    http://www.kwvlangweer.nl/wp/zeilwedstrijden-2/wedstrijden-deelnemers/

    Screenshot
    sorting Selection solution rows
  • Profile Image
    JotForm Support

    Answered by david on August 25, 2014 at 05:17 PM

    Hi,

    I checked the report and all of the sorting appears to work with the except of the numbers. Since it appears they are validated as text and not as numeric, they are being sorted as if they were text:

    In this case, 10-- comes before 11-- which comes before 12-- and so on. So for example, 1098 would come before 11 since it's like saying aabc would come before ab. If you change the validation to alphanumeric for the field that collects this data, rather than just text, it should solve this for any further submissions.

    Please let us know if you have any further questions and we will be happy to help.

    Thank you for using JotForm!

  • Profile Image

    Answered by kwvl on September 01, 2014 at 06:23 AM
    David,
     
    I understand the sorting is on a alphabetec colum but the question is a little bit different.
     
    1) In my full list i make a selection of the type of boats i like to see, suppose "FlitsA"
    2) Then i like to sort that selection and click on the rowheader, suppose "Verantwoordelijk Persoon"
     
    In that case the sorting is not working properly, i think.
     
    Sorting in a SELECTION is not working.
     
    Jan
     

     

  • Profile Image

    Answered by jedcadorna on September 01, 2014 at 08:36 AM

    Hello Jan,

    How I understand your question is that you wanted to sort let say "FlitsA" then select let say "Verantwoordelijk Persoon" and sort all "FlitsA" in "Verantwoordelijk Persoon"? If yes I think the sorting feature only allows you to sort single column.

    I think what you might be looking for is filtering then once filtered sort the filtered result? Please correct me if I'm wrong.

  • Profile Image

    Answered by kwvl on September 01, 2014 at 10:38 AM

    1) In my full list i make a selection of the type of boats i like to see, suppose "FlitsA"

     

    2) Then i like to sort that selection and click on the rowheader, suppose "Verantwoordelijk Persoon"

     

     

     

     

    In that case the sorting is not working properly, i think.
     
    Sorting in a SELECTION is not working.
     
    Jan
  • Profile Image

    Answered by jedcadorna on September 01, 2014 at 11:49 AM

    If you are using alphabetic for validation then it will not sort the numbers properly. Change the field validation to numeric so it sorts from highest to lowest or lowest to highest.

    Choose numeric validation if you want to sort numbers:

     

    Example:

  • Profile Image

    Answered by kwvl on September 01, 2014 at 12:44 PM

    Sorry, 

    What i mean and looking for is :

    Filtering then and once filtered sort the filtered result? 

    Jan

     

  • Profile Image

    Answered by jedcadorna on September 01, 2014 at 01:26 PM

    We currently don't have that filtering option but let me send this as a request or probably an enhancement in Grid report feature. I cannot guarantee that this will be implemented, but I assure you if ever this feature will be added then you'll get notified in this thread.