|
|
|
Sum/Count/Total
values in a column
Contact List Plus has math functions built into each
column and row like displaying the group count on each group
row State: NY ( 11 contacts). Contact
List Plus can add totals and counts at the bottom of each column
using Aggregate Function that include : Count, Sum, Average,
Min, Max, StdDeviation, ValueCount.
Displayed here CLP is
totaling the value of the $Promos column to the value of
$1,657.00

BACK TO TOP |
|
Save/Restore the List
Contact List Plus allows you to save the contact list.
This is extremely useful when using the tag mode
and you have selected contacts based on your own independent
criteria. The name of the saved list will appear in the
'Lookups' list for easy restoring. You can even restore multiple
lists at the same time!

BACK TO TOP |
|
Tag Mode
You can tag and un-tag contacts to create a lookup
manually. Occasionally you may want to send an email to contacts
that do not share common lookup criteria, using the tag mode you
can create a lists of contacts.

BACK TO TOP |
|
Edit data in any column.
Contact List Plus has several “built-in” editors like: Textbox,
CheckBox, Calendar DropDown, Combo* and DropDown Controls. The
dropdown controls are prefilled with user defined list values
from ACT!. Never go back to the details window to make changes
to a contact. Edit any value with one click. The list will go
into edit mode and display an editing object like a calender or
dropdown list depending on the type of data.

BACK TO TOP |
|
Design and
Save Column Layouts.
You can customize the order of the columns in the
contact list by adding a new "Column Layout." Once created,
simply change the layout by selecting a different "Column
Layout". You can quickly switch between multiple "Column
Layouts" by a simple popup list. Below is an example of five
different layouts that are installed by default.

BACK TO TOP |
|
One Click To Apply
Color.
Add color to any contact in the list. Simply select any
contact and right click exposing the "Color Picker". Select the
desired color and the contact row will always appears as that
color.

BACK TO TOP |
|
Contact List Plus replaces ACT! 2005 contact list view.
Contact List Plus replaces the existing contact list view with a
robust data and color driven view. This new view allows the
users to create as many data and color rules as you desire. View
only the contacts that match your rules like contacts in a
specific city or contacts in a group.

BACK TO TOP |
|
Save/Restore Lookups
Turn on/off lookups with a quick click of the mouse. View only
the contacts you want. Easily add the current lookup to the list
with a simple "Save" button. Save multiple Lookups using basic
find features or the more Advanced Query dialog. |

BACK TO TOP |
|
 |
Colorize your list
Add color to your list with simple rules. Color rules are
automatically applied to all the contacts matching any lookup.
Colorize contacts like
'Prospects to be called'.
Extract hidden information like
'Decision Maker(s)'
in New York.
BACK TO TOP |
|
Printing in Color
Contact List Plus for ACT! also includes a print
function to easily achieve WYSIWYG
(What-You-See-Is-What-You-Get) printing
of the
data presented by the control
including color. |
Export: One button export
to Microsoft Excel, Microsoft Word, HTML or XML formats. Simple
click the 'Export' button and give your export file a name. The
new export file will auto-open in the program of your selected
format. (XLS, DOC, HTM or XML)
BACK TO TOP |
 |
Settings at the
tip of your finger.
All the setting like the master "Edit mode" switch and Data and
Color Rules builders are easily accessible from this settings
list..
Edit mode switch.
Activates the one click edit mode.
Tag mode switch.
Activates the list's tag mode option.
Layouts - UserFields ... Opens the
Layout selector.
Lookup Rules... Opens the
Lookup builder.
Color Rules... Opens the color rules
builder.
Export...
Opens the save dialog box to export your list.
Select columns...
Opens a window to select the columns.
Print... Opens the
preview window with the current list.
Filter.. Opens a
filter window to add filter conditions.
Sort.. Opens the
sort window.
Group By... Opens
the Group by window to group like contacts together visually.
Header switch.
Turns on or off the list header box. When this is on you can
drag columns into the box for quick grouping.
BACK TO TOP |
|
ACT! 6 Tip
How to compress
and reindex a database
1)Open
ACT!, logging into the database as a database administrator. All
other users must be logged out.
2)Click the File menu, point to Administration, then
click Database Maintenance. The Database Maintenance dialog box
appears.
3)Under the Periodic Maintenance tab, enable the Compress
Database check box, then click the Reindex button. ACT! begins
to reindex your database.
Back to Top... |
|
ACT! 7 Tip
Creating Groups
To create a new group you must be in the Groups view:
1. To display the main Groups view, click the Groups
button in the navigation bar, press F10, or click the View menu,
and then click Groups.
2. In the Groups view, there are two different ways of
displaying group information:
From the toolbar you can select Groups to view the Group Detail
information. This will show the detailed information of one
group.
From the toolbar you can select Groups List to view a list of
groups in the database.
3. Click the New Group icon or click the Groups menu, and
then click New Group.
4. Type in the name of the group, and a description (if
needed) as shown below.
5. Once completed, click the File menu,
and then select Save. You will notice the Hierarchy field now
contains the name of your group.
Creating Subgroups
1. From the Groups view, click Group List
icon on the toolbar.
2. If you want to create a subgroup of an already
existing subgroup, check the Include Subgroups check box to
display all subgroups.
3. Select the group or subgroup you wish to create a
subgroup for and click the New Subgroup icon . ACT! will
automatically switch back to the Group Detail view.
4. Enter the name of the subgroup and a description.
5. Once completed, click the File menu, and then click
Save. You will notice the Hierarchy field now contains the name
of your original group and your subgroup.
Back to Top... |
|
Word Tip
The
F Keys
If you press the F1 key this will open the Help menu.
If you press the F5 key the Go To/Find and Replace dialogue box
opens.
If you press the F7 key the spelling checker will open.
If you press the F12 key the Save As dialogue box opens, just as
it would if you choose File, Save As.
This works in Word, PowerPoint and Excel.
Back to Top... |
|
Excel Tip
Combine Text from Multiple Cells
To combine text from multiple cells into one cell, use the &
(ampersand) operator.
1)Select the cell in which you want the combined data
2)Type an = (equal sign) to start the formula
3)Click on the first cell
4)Type the & operator (shift + 7)
5)Click on the second cell
6)Press Enter to complete the formula
Back to Top... |