Skip to main content

Filter by keyword across all fields

  • December 30, 2016
  • 2 replies
  • 19 views

Steven_Zhang
Forum|alt.badge.img+9

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 replies

Forum|alt.badge.img+9
  • Known Participant
  • January 6, 2017

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:


Steven_Zhang
Forum|alt.badge.img+9
  • Author
  • Known Participant
  • January 10, 2017

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