I don’t like the default filtering system proposed by Grist, it’s OK for static filtering and even in this case, only AND logic is available. I needed something faster and easy to use.
So I’ve designed a simple widget to filter quickly a table.
Basically it will display each lines which match at least one word (OR logic).
Sources and full instructions are available on Github, and an example is available here.
It started as a simple filtering system, but well now there are many options like: AND, negation, exactly equals, start with, regex or column selection… Please read the README on Github for full details (english and french).
This widget looks very good and is indeed very useful. Is it ok with you if we add this widget to the Grist Widget Gallery (in this repository), to make it available in grist-core and in docs.getgrist.com ?
New version with important bug correction is available.
Due to a mistake, I used row ids instead of table indexes when I browse the table. Then if some row have been removed from the table, ids don’t match anymore indexes, and the filter provides wrong results.
Hi @jarek, thank you for the proposal, I would be happy if the widget can be available easily.
I think the most of bug are corrected, and the most features are implemented, so I guess we can release it. Just to know, for any future update, can I do a pull request on this repository ?
so usefull & productive !