Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is There An Easy Way - Multiple Zip Codes & Advanced Lookup

Accepted Solution Solved
Highlighted
Bronze Super Contributor
Posts: 1,620
Country: USA
Accepted Solution

Is There An Easy Way - Multiple Zip Codes & Advanced Lookup

I need to build an advanced lookup that will look for contacts in a pretty large number of Zip Codes:

 

##201, ##202, ##203, ##204, ##205, ##206, ##207, ##208, ##209, ##210, ##211, ##212, ##213, ##214, ##215, ##216, ##217, ##218, ##219, ##220, ##221, ##222, ##223, ##224, ##225, ##226, ##227, ##228, ##229, ##230, ##231, ##232, ##233, ##234, ##235, ##236, ##237, ##238, ##239, ##240, ##241, ##242, ##243, ##244, ##245, ##246, ##247, ##248, ##249, ##250, ##251, ##252, ##253, ##254, ##255, ##256, ##257, ##258, ##259, ##260, ##261, ##262, ##263, ##264, ##265, ##266, ##268, ##269, ##270, ##275, ##2##, ##279, ##280, ##283, ##284, ##285, ##286, ##287, ##288, ##289, ##291, ##292, ##293, ##294, ##295, ##296, ##297, ##298, ##299.

 

Is there an easy way to build an advanced lookup that will search these zip codes without having to enter every one?

 

Thanks for your help.

John Purdy
ACT! Premium V. 22.1.212.0 Update 4
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor

Accepted Solutions
Highlighted
Solution
Accepted by topic author jnpurdy
‎10-31-2018 07:09 AM
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Is There An Easy Way - Multiple Zip Codes & Advanced Lookup

Maybe and it may not require and advanced lookup. The tricky part is the ZIP code field is a character field and not a number field so you can't use greater than or less than. However assuming that the first two or three numbers are the same, for example 01 pr 012, you can use the regular field lookup with the Starts With operator to find all the matches.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer

View solution in original post


All Replies
Highlighted
Solution
Accepted by topic author jnpurdy
‎10-31-2018 07:09 AM
Platinum Elite Contributor
Posts: 6,867
Country: USA

Re: Is There An Easy Way - Multiple Zip Codes & Advanced Lookup

Maybe and it may not require and advanced lookup. The tricky part is the ZIP code field is a character field and not a number field so you can't use greater than or less than. However assuming that the first two or three numbers are the same, for example 01 pr 012, you can use the regular field lookup with the Starts With operator to find all the matches.
Roy Laudenslager
Retired ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
Highlighted
Bronze Super Contributor
Posts: 1,620
Country: USA

Re: Is There An Easy Way - Multiple Zip Codes & Advanced Lookup

It is clear that common sense is not part of my thought process.

 

Actually the greater than and less than worked, since numbers are sorted ahead of letters I believe.

 

Roy, the community is fortunate to have your insights.

 

Best regards,

John Purdy
ACT! Premium V. 22.1.212.0 Update 4
HP ENVY 17m, 16GB, & Office 365, 32bit, 500GB SSD.
ACT CRM Advisor