Multiple filters on a report - how many are too many, and are there better ways?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Some of our (marketing...) data does not have easily filtered data in the "Job Title" category. In order to attempt to filter out what we don't want, I end up needing to use 10+ filters, and could easily end up with 20 or more. Is this normal? Is there a better way to do this?  I will eventually download the report to excel so I can make a mailing list out of it, but would like it as filtered as possible on the QuickBase side before I deal with it in Excel. (Cleaning up the data is not an option - 16k records)

Photo of Beth

Beth

  • 1,066 Points 1k badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,520 Points 50k badge 2x thumb
In general, your options are to

(a)hardcode of formula which essentially contains all these filters into a checkbox field called [show on report?]  or

(b) if any of these are lookup fields then you could include a checkbox field in the source table as to if the records should make it on to the report.

You can also choose  to Include rather than exclude if that would make for fewer filter criteria.