官术网_书友最值得收藏!

Filtering based on a contact activity lookup

In the first task, we created a relatively simple lookup based on two contact fields. In this task we will create a more complex lookup based on contact activity. The resulting lookup can be used with any contact report. The contact activity lookup is very flexible with a number of options. For this task, we do a relatively simple lookup of any call activity recorded in history since a specified date.

How to do it…

  1. Click on Contacts on the navigation bar on the left-hand side of the ACT! screen.
  2. Click on the Lookup menu and select Contact Activity....
  3. In the Contact Activity dialog, click on the radio button next to Changed.
  4. For Since Date, click on the dropdown and click on a date in the calendar displayed.
  5. For Search In, uncheck Contact fields, Notes, Opportunities, and Activities.
  6. Click on the Histories dropdown and click None.
    How to do it…
  7. Scroll the list of history types to the call types and click on all five call types as shown in the preceding screenshot.
  8. Press the Tab key to save the type selection.
  9. Click OK to execute the query.

How it works…

In this case, we wanted to filter for those contacts that we had tried to call or we had a conversation within a time period ending at today. This query checks all the history records for two things:

  • One of the specified call history types
  • A last modified date within the date range selected

When a history record is found that meets the criteria, the contact record it's linked to is added to the lookup list. As in the first task, the temporary lookup list is retained and can be used for the Current Lookup option in the report filters.

There's more…

The contact activity lookup we created was very simple, but the contact activity lookups can be very complex. For example, we created our lookup based on records that were changed within the time period ending with today. This is very good for tracking what we have done. But a more powerful version where we want to plan future activity would be Not Changed. With this we can create a report that lists all the contacts that we had not called recently. Because it's somewhat hidden, this powerful lookup is often overlooked as a useful filter.

主站蜘蛛池模板: 台南县| 福建省| 莆田市| 孟津县| 丹江口市| 林州市| 耒阳市| 余姚市| 乌什县| 海南省| 肥城市| 丹阳市| 麻栗坡县| 甘南县| 苏尼特右旗| 深州市| 惠州市| 秦安县| 桐庐县| 鹤壁市| 罗定市| 合作市| 南和县| 泰和县| 八宿县| 景宁| 崇明县| 兰考县| 刚察县| 马公市| 两当县| 四川省| 邛崃市| 古丈县| 龙口市| 楚雄市| 叙永县| 修武县| 金乡县| 济阳县| 塔河县|