
Kyle Freeman asked a question.
More robust app filter options
I have a multiple choice category field in my Companies app and would like to be able to filter out a specific option, for example to view "Existing Customer" but not "Facility". Currently filters are only additive rather than exemptive.
I would also like to filter by a custom relative past date for a date field. I want a custom view of items from the past 2 years (or other amount of time that's not an existing option).
An "advanced filter" option that worked like the calculation field, with and/or logic and parentheses would get a lot of use from us.
I know I can separate the category into separate fields, or use a calculation field, but being able to do more with the filter function would be nice.