Forum Discussion

LauraMcFeely's avatar
LauraMcFeely
Qrew Cadet
7 years ago

Searching by a specific field within a report

Hello! Is there a way to do more specific searches within a report? For example, I have a table that tracks communication with teachers, and I'd like to search for all communication to or from John Smith. The field I want to search by is called "Teacher Name." It feels like I should be able to write in the search bar something like: "{Teacher Name}=John Smith". When I just search using "John Smith", I get the relevant records plus a bunch of other records where John Smith was referenced in the body of the email (which is another field) but weren't actually to or from him. 

I know about filters, but in this instance, I have so many teachers that Quick Base won't let me filter by their names. Plus, there are only 5 filters allowed, and it would be nice to quickly search by specific criteria rather than editing the report to change the filter. 

Thank you! 

12 Replies

  • OK, at least we are now understanding each other.
    You would need to make a new report with an <ask the user> filter or make a Dashboard search element on the dashboard of the app to search based on a search limited to a specific report.  The report would just be limited to a few fields.
  • Okay. I didn't know about the <ask the user> filter, which isn't exactly what I was looking for, but I think it's close enough to serve my needs. Thank you very much for your time and for telling me about it!