Forum Discussion
KatherineOakey
4 years agoQrew Member
Yes, I know you can indent to create a set of ANY/ALL.
Not sure that I am aware of using the OR in a filter?
I usually end up messing up the filters when I try to add a new condition in the middle of the filter someplace.
------------------------------
Katherine Oakey
------------------------------
Not sure that I am aware of using the OR in a filter?
I usually end up messing up the filters when I try to add a new condition in the middle of the filter someplace.
------------------------------
Katherine Oakey
------------------------------
MarkShnier__You
Qrew Legend
4 years agoYou can have a filter like
[Subject] contains cats OR dogs OR gerbils
The OR must be in upper case.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
[Subject] contains cats OR dogs OR gerbils
The OR must be in upper case.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- KatherineOakey4 years agoQrew MemberI am using the Initial filter (not dynamic)
IF ( a = value
and
b = value )
OR
( ( a = different value1
OR
a = different value2
OR
a = different value3
OR
a = different value4 )
AND
c = value ))
THEN
record included in report
------------------------------
Katherine Oakey
------------------------------- MarkShnier__You4 years ago
Qrew Legend
This part needs more clarity.
AND
c = value ))to be clear, you are making a report filter, and not a formula, right?
An option if you're more comfortable with formulas to make a checkbox formula which is true if you want it included on the report and then the report was simply filter aware that field is true.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- KatherineOakey4 years agoQrew MemberNo, these are field filters...
DAYS OLD is on or after 60 in the past
AND
INPUT SOURCE is equal to the value DESK
OR
INPUT SOURCE is equal to the value WALK-IN
for example - INPUT SOURCE is a list of values that I want to selectively report along with date values where the INPUT SOURCE value is tied to different date fields.
------------------------------
Katherine Oakey
------------------------------
Related Content
- 3 months ago
- 8 months ago