Column filters do not adjust based on displayed content

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.
https://cl.ly/f991b6fc6738

5 answers

Public
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: https://www.flexmonster.com/api/setfilter/. You can use reportchange event to define when the filtering is performed: https://www.flexmonster.com/api/reportchange/. 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.
Regards,
Dmytro

Public
Dillon Jenkins 2 days ago

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!
Dillon
 

Public
Dmytro Zvazhii Flexmonster 2 days ago

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.
Regards,
  Dmytro

Public
Dillon Jenkins 2 days ago

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

Public
Dmytro Zvazhii Flexmonster 2 days ago

Dillon,
Usually, we keep the history of the client’s requests and every feature in our CRM has a list of the related customers. So you 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. 
Thanks

Please login or Register to Submit Answer