[pixelplumber Contributions: 0Level 1☆]

Under the setup > sales > sales rules you can specify postcodes as ranges between two values (high and low) per search line.

I’d like to do this with a saved contact search as well (to use as part of a contact group for an email campaign) but when using postal code as the column type on a search line, I can only choose from “any, is, is empty, starts with, contains, is not, is not empty, does not start with, does not contain.”

Is there any way of using a formula field to do a range search for post codes?

eg: line1 might be searching for postcodes between 4054 to 4068 and line2 might be looking for 4868 to 4888.

I’d prefer to avoid having to put in 20+ lines with an individual “is” match for a single postcode per line if possible.

Thanks in advance for any help.
This is a cached copy. Click here to see the original post.

[michoel Contributions: 0Level 1☆]

You can do this as follows:

Filter – Formula (Numeric)

Description – is between 4054 and 4068

Formula – TO_NUMBER({zipcode})

[pixelplumber Contributions: 0Level 1☆]

Thanks a lot, that’s worked.

Cheers.

[Author]

Posts