Can I change the default for custom filters?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cbry - 11 Sep 2006 07:50 GMT

"Custom filte" always begins with "Show rows where <field name> EQUALS ..."
I almost always use CONTAINS. Can I change the default so that it'll
automatically display CONTAINS as the starting criterion? If so, how? I'm in
Mac OS 10.4.7. Thanks.

Reply to this Message

Dave Peterson - 11 Sep 2006 14:12 GMT

You can't change it the wintel version.

But you can fool it.

Say you want to check to see if the value contains cbry.

Use Equals and
*cbry*
surround your value with asterisks to get the equivalent of Contains

Leading asterisk (*cbry) is the same as ends with
trailing asterisk (cbry*) is the same as begins with

Why, oh, why isn't that dropdown box just a hair bigger!

> "Custom filte" always begins with "Show rows where <field name> EQUALS ..."
> I almost always use CONTAINS. Can I change the default so that it'll
> automatically display CONTAINS as the starting criterion? If so, how? I'm in
> Mac OS 10.4.7. Thanks.

Signature

Dave Peterson

Reply to this Message

cbry - 12 Sep 2006 03:58 GMT

> You can't change it the wintel version.
> But you can fool it... Use Equals and
> *cbry*
> surround your value with asterisks to get the equivalent of Contains

YEEEAAAAHHH -- works fine! A muy cool workaround. Many thanks, Dave P!

Reply to this Message