If Then logic custom reports
It would be great if we could have "If-Then" logic for custom reports
19
votes
Jenny Molyneaux
shared this idea
-
Kiki Greene
commented
Or at least, it would be nice to allow "AND" "OR" logic within one filter, esp. for textbox fields. Right now the logic can only exist between different filters, but within one filter/field, there is no flexible logic built in for multiple criteria, nor does it allow using the same filter more than one time (with different values).
Examples:
(1) filter "Prefix" is "Mr." OR "Mrs." OR "Ms." AND "not null".
(2) filter "profile type" IS "x" AND IS NOT "y"I created a new idea for above (AND OR logic within one fitler) as well: https://idealab.foundant.com/forums/597718-communitysuite-idea-lab/suggestions/46782934-custom-report-filter-and-or-logic-within-one