`Spreadsheet` + `H Table` components: Ability to filter a column by its dropdown values (if it is a dropdown field) (built in element)

[ninetteadhikari]

https://element.eleme.io/#/en-US/component/table#filter

Design

Component

Component in use on the Indicator page in Metrics. For columns that have more than 5 options, enable the scroll. The user will be able to also use the search input field to find other options:

This is an example from Google Sheets:

[andrewtpham]

@michaelbukachi For filtering a column by its dropdown values, I saw revogrid had some related documentation on advanced filtering:

• https://revolist.github.io/revogrid/guide/filters.html#advance-usage
• Filter plugin: https://github.com/revolist/revogrid/blob/master/src/plugins/filter/filter.plugin.tsx

[andrewtpham]

Hey @michaelbukachi I realized we already have this built into the Member Table for the Dots workspace. Can we add this functionality to the h-table-edit-enabled component and in the new spreadsheet-table component you're working on?