Forum Discussion
MarkShnier__You
Qrew Legend
4 years agoAre you aware that you can indent a set of filters to treat them as an Amy/All block?
Are you aware that you can use the syntax OR in upper case in a filter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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__You4 years ago
Qrew Legend
You 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
------------------------------- 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
------------------------------
Related Content
- 3 months ago
- 8 months ago