TriggerCalc Pro is the add-on you need if you want to make calculations involving ACT! fields. It is mainly designed to be used in conjunction with the ACT! field trigger feature which allows to launch a program when you exit or change a field. This way, your calculated fields are always up-to-date.
TriggerCalc allows to run multiple calculations at once for the current contact, current lookup or all contacts. It also works with companies and groups.
There are 2 versions of TriggerCalc. The standard version allows to make calculations using operators (like +, -, *, \, AND, OR, etc.) while the Pro version gives you the ability to use more than 50 functions.
With more than 50 functions
(date/time, string, conditional, financial...)
TriggerCalc Pro will allow you to perform
the calculation you want
Here are a few examples of what can be done with TriggerCalc Pro:
- Use an If statement to populate a field
(ex: if FieldA=valueA then FieldB=valueB else FieldB=valueC, etc.)
Functions can be nested inside other functions, so you could make it as complicated as you want (ex: if FieldA+FieldB=valueA then if FieldC=valueC then FieldD=valueD, etc.)
- Copy the content of a field to another field
- Launch an outside program or document
- Format a number
- Calculate an age
- Blank out a field
And all the calculations you can imagine using more than 50 functions! Date/Time, String, Mathematical, Conditional, Statistical, Financial functions (see the user's manual for all details).
TriggerCalc Pro uses a convenient wizard to set up your triggers and calculations (see screenshot).