Community
Showing results for 
Search instead for 
Do you mean 
Reply

What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don't ?

Nickel Elite Contributor
Posts: 934
Country: USA

What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don't ?

What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don't ? Why is there no specific lookup for Area Code? Thanks FSB

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Bronze Contributor
Posts: 955
Country: Australia

Re: What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don'

Bill my understanding

 

1. Country codes are not included in phone field lookups

2. If you do a lookup starts with then this should give you all based on the area code i.e. 675

3. If this is not working why not add a field to put in the area code when entering the record and then you should be able to lookup exactly what you want

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
Nickel Elite Contributor
Posts: 934
Country: USA

Re: What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don'

Thanks for the feedback Paul,

We considered adding a Area Code field, but doesn't it seem odd that there is no area code field already in such a powerful CRM software? or a specific lookup for Area code?  When there is irregular data where some fields have country codes and some do not, the lookup results are not 100% accurate, but my customer says the results are close enough for his needs at present.  Thanks again - Cheers - FSB

 

Bill Williams - Owner/Consultant/Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Protect your Files & Folders with Folder Lock Pro by New Software http://download.cnet.com/Folder-Lock/3000-2092_4-10063343.html
Silver Super Contributor
Posts: 2,328
Country: USA

Re: What is best way to lookup contacts by phone "AREA CODE" (ACT!2012 Pro) ? AND - What if some records contain country codes and some don'

Bill,

 

I have a program called FixPhoneMasks that I sell that will fix the country code fields as well as a few other things in the phone table.  Give me a call if you'd like to discuss distributing it to your users.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!