Community
Showing results for 
Search instead for 
Do you mean 
Reply

Advance Lookup

Copper Contributor
Posts: 57
Country: Canada

Advance Lookup

Is there anyway of creating an advanced lookup based upon lets say a "History Event" of a "Letter Sent"? and then sorting by a specific date range?

 

Frank

Copper Elite Contributor
Posts: 127
Country: Australia

Re: Advance Lookup

You can perform a lookup on most fields in the database. Right click on the field, such as "Letter Date" and then select the search function. From there you can select the appropriate date function. This would deliver a selection of records matching your criteria.
Regards
Neil Gilford
ACT! Certified Consultant
Gilford Computer Solutions
neil@gilford.com.au
Copper Contributor
Posts: 57
Country: Canada

Re: Advance Lookup

On the contact dashboard there is a History tab and all the activities that have occurred with that contact are there.  What I would like to do is simply create a lookup based upon a letter sent on a given day that is recorded there.
Nickel Elite Contributor
Posts: 934
Country: USA

Re: Advance Lookup

[ Edited ]

Here is one way - (there is more than one).

example1:

Lookup

 Keyword Search

   Search for:  EnewsLetter

     (look in:  select:  Activities and History)  (contacts select;  All Contacts)

 

Click Find Now

  Create Lookup

Then search for your desired Date(assuming the date format the same?)

 Search For:  03-11-2008

   (Look in : select; Activities and History ) (Contacts select;  Current Lookup)

Select Find Now.

 

that is just one way - may not be the best?

 ======================================

 

You can also Schedule these Mailing EVENTS and do lookup on those criteria.

If you add/schedule a Custom Event such as EnewsLetter Mailing

 You can use your Activities Tab  and select a Specific Date

==============================================================

 

Also - 

Lookup

 Contact Activity   option

=====================================================================

Also

From your History Tab - You can select specific Dates

======================================================================

Cheers - FSB

 

 

 

 

 

Message Edited by FillStaffBill on 03-10-2009 08:54 AM
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