Get Free Trial

Column filters do not adjust based on displayed content

Dillon Jenkins asked on October 8, 2018

If a filter on one column eliminates options for other columns, I don’t want to see those options when I go to filter those columns. This behavior is consistent with other spreadsheet applications.

5 answers

Dmytro Zvazhii Dmytro Zvazhii Flexmonster October 10, 2018

Hello Dillon,
Thank you for providing us with the video example. It was really helpful. Right now, Flexmonster does not have native support of such behavior. The possible workaround is to apply the filter to the necessary field using setFilter() API call: You can use reportchange event to define when the filtering is performed: Also, could you please share the example of the other application where such functionality is implemented? It would be very helpful for us to dig a little bit deeper into the question.
Please let us know if you need any other assistance.

Dillon Jenkins October 17, 2018

Hey Dmytro,
The setFilter() call wouldn’t fix the problem we’re seeing, because the root of the problem is the filter modal not showing the current state of the filters (only showing all available items every time). If this doesn’t get fixed on your side, the solution to that would be to provide an API where we can intercept the `showFilterModal` click and use our own logic there to show our own implementation of a modal with an updated current state of the flexmonster filters. Does that functionality exist? And if not, can we get that prioritized on your side?
As you requested, Excel, Google Sheets, and Wdesk Spreadsheets all have this functionality.
Thanks for the help!

Dmytro Zvazhii Dmytro Zvazhii Flexmonster October 18, 2018

Hi Dillon!
Yes, I understand your need. Unfortunately, we don’t have such functionality right now but I already added it to client’s wishlist. I hope we will include it in the roadmap for our next major release.

Dillon Jenkins October 18, 2018

If it gets added, do I have anyway to track it?

Dmytro Zvazhii Dmytro Zvazhii Flexmonster October 18, 2018

Usually, we keep the history of the client’s requests and every feature in our CRM has a list of the related customers. So we will update you as soon as the development process is finished.
Also, you can check all the updates on the Release Notes page. We update it biweekly. 

Please login or Register to Submit Answer