Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Filter by keyword across all fields

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Steven_Zhang
6 - Interface Innovator
6 - Interface Innovator

Is there a way to filter a table by keyword that searches across all columns?

I would like something like the current ctrl/cmd+f feature, but instead just highlighting the rows that have a hit, the rows are filtered in.

I could do a hacky workaround where I concatenate all the columns in a calculated column, but this is impractical in bases with 30+ fields

2 Comments
David_Smedberg
6 - Interface Innovator
6 - Interface Innovator

You can create a filter that uses OR. Set up the filter on all columns. Itโ€™d look something like this, but with more columns included in the filter:

28c06aa8e61bf07614c701a132a073949ff22788.PNG

Steven_Zhang
6 - Interface Innovator
6 - Interface Innovator

Yes, but if you have 50+ columns, this method becomes pretty untenable. But agreed, it works fine for a few columns!