TriggerCalc

Frequently Asked Questions:

1. What kind of calculations can I make with TriggerCalc?

Any calculation with the +, -, * (multiply), / (divide) operators. You may use parenthesis also. Remember to include your field IDs in between brackets. Here are a few examples:

[fieldC]=[fieldA]+[fieldB]

[fieldC]=([fieldA]*5) + ([fieldB]*10) - 50

[fieldC]=([FieldA]+100)/[fieldB]

etc.

TriggerCalc and TriggerCalc Pro now support more than 50 functions. Make sure you download our user's manual to find out more about all these functions.

2. Does TriggerCalc allow me to modify a lookup of contacts?

TriggerCalc is designed to work automatically when you modify a contact but the Pro version also allows you to modify a lookup of contacts.

3. Do I absolutely need to set up a trigger for TriggerCalc to work?

No. You may want to add a button to your toolbar and launch the calculation by clicking on the button. See our User's manual for more on this.

4. Can I do string concatenation with TriggerCalc?

Yes, you can. When you use the + sign and one of the values is not numeric, then the program will concatenate the values.

Example:

[fieldA]&[fieldB] gives 12 if fieldA=10 and fieldB=2

[fieldA]&[fieldB] gives 10A if fieldA=10 and fieldB=A

[fieldA]&[fieldB] gives MrBrown if fieldA=Mr and fieldB=Brown

Use the underscore sign to insert a space:

[fieldA]&"_"&[fieldB] gives Mr Brown if fieldA=Mr and fieldB=Brown

5. When I try to run a trigger, ACT! displays an "Invalid path" error message. What gives?

ACT! does not tolerate spaces in the arguments of a trigger. So make sure you have no space in your arguments.

For instance,

C:\Program Files\Exponenciel\TriggerCalc\triggercalc.exe /[50]=[51] + [52]

is invalid because of the spaces before and after the + sign.

Note in the previous question the use of the underscore sign for inserting a space in a concatenation of strings.

BACK

CONTACT US  1-800-806-5288
Copyright © 2011 SJR Productions, Inc.
All brands and product names are trademarks or registered trademarks
of their respective companies.