ActPresentation.com HOME FAQ forum info@ActPresentation.com
Addons for ACT! by Sage :
Abacus Calculated Fields for ACT!
make calculations involving ACT! fields
  • Create calculations involving ACT! fields
  • Assign calculation formula to field (make a field "calculated")
  • Calculate Total
  • Run your calculations either automatically or manually
  • Over 80 supported functions (mathematical, string, datetime, financial)
  • Mortgage/loan calculation
  • Use "IF" and "CASE" conditional statements to build calculation scenarios
  • Automatic data entry (fill fields automatically)
  • Calculate Interest Rates
  • Accounting software functions
  • Mass replace field values
Dynamic Field Color for ACT! by Sage
highlight fields depending on field values
  • Calculate and change field colors "ON THE FLY"
  • Conditional color calculations using "IF" and "CASE" statements
  • Perform data entry validation
  • Highlight incorrecly entered fields
  • Highlight fields depending on field values
New Contact List for ACT! by Sage
say "good bye" to look-ups!
  • Contact list is EMBEDDED in Detail View
  • List can be docked or floating
  • Built-in search by any field
  • Built-in FILTER bar - build quick LOOKUPS!
  • "Two monitors view" in floating mode
PicturePlus for ACT! by Sage
advanced features for picture fields + Scanner & Camera support
  • Links picture fields to Image files
  • Links to PDF, Video and Audio files
  • Scan directly to picture fields!
  • Load images from digital cameras
  • Full size image view
  • Open pictures in your favourite image viewer
  • Clipboard support (copy/paste images)
  • Drag'n'drop image files to/form ACT!
Employment History for ACT! by Sage
track who works for whom records
  • Associate chronological employment history with contacts
  • Enter work period ( start date, end date ) for every company associated with contact
  • Usefull for recruitment agencies
Quick Search for ACT! by Sage
find contacts quickly and easily!
  • Quick search tool for contacts, companies, groups and opportunities
  • Search by several fields simultaneously
Presentation for ACT! by Sage
run slide show based on ACT! report
  • Run slide show based on ACT! report
  • Convert report to MS Powerpoint Presentation

Our add-ons are compatible with:

ACT! 2005 (v7)
ACT! 2006 (v8)
ACT! 2007 (v9)
ACT! 2008 (v10)
ACT! 2009 (v11)
ACT! 2010 (v12)
ACT! 2011 (v13)
ACT! 2012 (v14)
Sage ACT! 2013 (v15)
Swiftpage ACT! 2014 (v16)
Swiftpage ACT! 2015 (v17)
Swiftpage ACT! 2016 (v18)
Swiftpage ACT! 2017 (v19)
Swiftpage ACT! 2018 (v20)
Swiftpage ACT! 2019 (v21)

forum
Abacus Calculated Fields for ACT!
On-line help - Statements

IF...THEN...ELSE...END
Imposes conditions on the execution of a formula. The formula following a THEN keyword is executed if the condition is satisfied (when the Boolean expression returns TRUE).
The optional ELSE keyword introduces an alternate formula that is executed when the IF condition is not satisfied (when the Boolean expression returns FALSE).

Syntax
IF Boolean_expression THEN
    formula_1
[ ELSE
  formula_2 ]
END

Remarks
IF...THEN...ELSE...END statements can NOT be nested. If you need to compose statement with several conditions use searched CASE WHEN... THEN...ELSE...END statement

Examples:

IF ( [Country]='Canada' OR [Country]='United States' ) THEN
    [Country] + ' is in North America'
ELSE
    'International'
END



CASE...WHEN...THEN...ELSE...END
Evaluates a list of conditions and returns one of multiple possible result expressions.
CASE has two formats:
The simple CASE statement compares an expression to a set of simple expressions to determine the result.

The searched CASE statement evaluates a set of Boolean expressions to determine the result.

Both formats support an optional ELSE argument.


Syntax
Simple CASE statement:
CASE input_expression
   WHEN when_expression THEN result_expression
       [ ...n ]
   [
       ELSE else_result_expression
   ]
END

Searched CASE statement:
CASE
   WHEN Boolean_expression THEN result_expression
       [ ...n ]
   [
       ELSE else_result_expression
   ]
END

Arguments
input_expression
Is the expression evaluated when using the simple CASE format. input_expression is any valid expression.
WHEN when_expression
Is a simple expression to which input_expression is compared when using the simple CASE format. when_expression is any valid expression. The data types of input_expression and each when_expression must be the same or must be an implicit conversion.
Is a placeholder indicating that multiple WHEN when_expression THEN result_expression clauses, or multiple WHEN Boolean_expression THEN result_expression clauses can be used.
THEN result_expression
Is the expression returned when input_expression equals when_expression evaluates to TRUE, or Boolean_expression evaluates to TRUE. result expression is any valid expression.
ELSE else_result_expression
Is the expression returned if no comparison operation evaluates to TRUE. If this argument is omitted and no comparison operation evaluates to TRUE, CASE returns NULL. else_result_expression is any valid expression. The data types of else_result_expression and any result_expression must be the same or must be an implicit conversion.
WHEN Boolean_expression
Is the Boolean expression evaluated when using the searched CASE format. Boolean_expression is any valid Boolean expression.
Result Types
Returns the highest precedence type from the set of types in result_expressions and the optional else_result_expression.
Result Values
Simple CASE statement:
Evaluates input_expression, and then, in the order specified, evaluates input_expression = when_expression for each WHEN clause.

Returns the result_expression of the first (input_expression = when_expression) that evaluates to TRUE.
If no input_expression = when_expression evaluates to TRUE, CASE returns the else_result_expression if an ELSE clause is specified, or a NULL value if no ELSE clause is specified.

Searched CASE statement:
Evaluates, in the order specified, Boolean_expression for each WHEN clause.

Returns result_expression of the first Boolean_expression that evaluates to TRUE.
If no Boolean_expression evaluates to TRUE, CASE returns the else_result_expression if an ELSE clause is specified, or a NULL value if no ELSE clause is specified.

Examples
A. Use a simple CASE statement

CASE( [Country] )
    WHEN 'United States' THEN 'Domestic'
    WHEN 'Canada' THEN 'North America'
    WHEN 'Mexico' THEN 'North America'
    ELSE 'International'
END

B. Use a simple CASE statement
CASE [State]
    WHEN 'NY' THEN ' State is New York'
    WHEN 'NJ' THEN ' State is New Jersey'
    WHEN 'NY' THEN ' State is New York'
    WHEN 'NV' THEN ' State is Nevada'
    ELSE 'State is ' + [State]
END

C. Use a searched CASE statement
CASE
    WHEN UPPER([First Name]) = 'CHERYL' THEN 'Contact ' + [Contact] + ', type 1'
    WHEN SUBSTRING([Last Name],1,1) = 'J' THEN 'Contact ' + [Contact] + ', type 2'
    WHEN ([First Name] = 'Sean')AND([State] = 'NY')THEN 'Contact ' + [Contact] + ', type 3'
    ELSE 'Unsupported contact type'
END
 Information:
How to install addon
How to uninstall addon
Getting started
 On-line help:
User reference
Statements
Operators
Functions
Financial functions
 Tutorials:
Flash demo 1
Flash demo 2
Flash demo 3
Flash demo 4
Examples of calculations
Download free trial
BUY NOW
 Compatible with:
ACT! 7 / 2005
ACT! 8 / 2006
ACT! 9 / 2007
ACT! 10 / 2008
ACT! 11 / 2009
ACT! 12 / 2010
ACT! 13 / 2011
ACT! 14 / 2012
ACT! 15 / 2013
Swiftpage ACT! 16 / 2014
Swiftpage ACT! 17 / 2015
Swiftpage ACT! 18 / 2016
Swiftpage ACT! 19 / 2017
Swiftpage ACT! 20 / 2018
Swiftpage ACT! 21 / 2019
 Screenshots:
Click on these sample screenshots
to see larger views.

ACT! software addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, ACT!2009, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.