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.
https://cl.ly/f991b6fc6738
⋅ 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
⋅ 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!
Dillon
⋅ 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.
Regards,
Dmytro
⋅ October 18, 2018
Dmytro,
If it gets added, do I have anyway to track it?
Thanks!
⋅ October 18, 2018
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 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.
Thanks
