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.
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.
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!
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.
If it gets added, do I have anyway to track it?
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.