Community
New Idea
0 Kudos

I want to find all the contacts in my database in the Sheffield area by postcode.

 

Sheffield postcodes go from S1 ### to S81 ###

 

Frustratingly, there's no sensible way to do postcode lookups in ACT!

 

Lookup > Postcode . Starts with "S", returns spurious results, e.g. SW1 is in London.

 

I can try Lookup > Postcode . Starts with "S_ _", using the underscore as a character placeholder, but that just finds S1 to S9 and misses out S10 and above.

 

What we need is the ability to use number and letter placeholders in lookups and queries.

For example if "#" is a number and "%" is a letter, I could use..

 

Lookup > Postcode . Starts with "S#" to find what I want. 

 

In more general terms I also want to be able to do things like  lookup records where the third character in a field is a number. Is that too much to ask?

 

You can do this sort of stuff in Universal search, but you can't do lookups from universal search, so it's not much use.

 

The world uses postcodes and zip codes. It has done for decades. It's nearly 2012. ACT! should be able to handle these effectively if it is to remain a relevant sales and marketing tool.

Featured Partner
Tech Benders

Roy Laudenslager joined TechBenders in 2005. Tech Benders literally wrote the books on Act! – also the lynda.com training videos. We specialize in improving your bottom line with effective CRM usage, custom Act! reports and Act! database repairs and conversions.

Location: USA
techbenders.com
Contact: Email
Tel: 561.470.5450

Share your Ideas

We want to hear your cool ideas for improving Act! products and services. So add your own ideas or kudo (vote) on the ideas of others here!

I have an idea! How do I get started?

  1. Read our submission guidelines.

  2. Search for your idea. If you don't see it, submit a new one!

  3. Provide feedback on the ideas of others by voting with kudos and adding comments.

  4. Track your ideas and those you like. Once you've posted or kudoed and idea, subscribe to be notified via email of the latest updates to the idea. From within the idea, click "Idea Options" which appears above the idea title and choose, "Subscribe to this idea".

Be sure to check back from time to time to see new ideas and status updates!

Here is a quick list of the ideas for speedy browsing!