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

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

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!

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.

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"

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:

Sorry, 

What i mean and looking for is :

Filtering then and once filtered sort the filtered result? 

Jan

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.