Adding a filter section

[Joykareko]

Can we add a filter section to the list, so we can easily filter by #worldwide or #USA or whichever instead of scrolling down to the full list?

[dougaitken]

Great idea, filtering is something I'd love to have help with.

That said, the search field will work for region term.

[GabrielModog]

I like to implement that. But we have to decide where the filter input will be shown.

[dougaitken]

What thoughts do you have @GabrielModog - I'm open to ideas.

[GabrielModog]

Currently we can search by company. My idea is add another filter below this one.

[dougaitken]

How do you think this would be populated @GabrielModog? I ask as the region is fairly standardized but there are some edge-cases with single country or some timezones.

Would your filter parse the list and offer the existing entries as filter options or would you provide a smaller specific set?

[GabrielModog]

I don't know if a get it what you trying to say...

So I was thinking rewrite the current filter code to make reusable as possible to maybe add others filters in the future.

For now I thought to make a radio button to switch the type of filter (by company or country). When I made some test by adding a new input don't look so nice. So to me the solution is a radio button to switch the type of filter.

[dougaitken]

@GabrielModog Can you open a PR with what you have? It'll generate a preview URL so I can take a look.

This is a tricky scenario so I appreciate any ideas people have 😀

[kb-s]

@Joykareko what I'm thinking we can do this by a formula.

COUNTIF(range, criteria)

eg. COUNTIF(tblFilterList[FilterList],[@Country])=1

"Tell me if i'm wrong", Thanks.

[dougaitken]

@kb-s Thanks for the comment, your solution is intended for a spreadsheet, that isn't how the data is stored here.

[kb-s]

@dougaitken Thanks for the response.