Download Abacus Calculated Fields for ACT!
Over 28,629 Win x64 downloads! Bookmark Now!

Windows 64 bit Software - the latest is here right now! But that's not all. We update our collections every single minute -

Home > >


Abacus Calculated Fields for ACT!  

Abacus Calculated Fields for ACT! 9.1 Windows

    Platform: Win95,WinNT,WinXP,Win98,WinME,Windows Server 2003,Windows XP x64,Windows Server 2003 x64
Download Abacus Calculated Fields for ACT! Now
  Buy Now     
Size: 1 MB $ 69.95  
"Abacus Calculated Fields" for ACT! now brings you the ability to calculate fields,
copy fields, manipulate data and produce results dependant on the data within other
fields all within a simple, easy to use interface.

It was designed with ease of use as its main aim.
-Writing a formula is simple.
-Assigning the formula to a field is simple.
-Reviewing and changing your formulae is simple.

Make any field "calculated" in 2 steps : just select a field on layout(using context menu)
and write calculation formula.

"Calculated" fields will be always up-to-date since calculations will be run automatically
every time when you change value of any field that is a part of formula.

"Abacus Calculated Fields" addon really makes light work of what has been the missing link
in ACT! for years.

Abacus integrates smoothly into the ACT menu system and the calculations just work.
Isn't that what you want from a field calculator?

If you need complex conditional calculations Abacus can do that too - just use
IF...THEN...ELSE and CASE conditional statements to build calculation scenarios.
In fact Abacus can handle very complex calculations, simply.
Take a look at EXAMPLES OF CALCULATIONS below.

Links to the Statements, Functions and Operators can be found on the [LEFT]-hand side
of this page.

There are over 80 functions supported by Abacus addon ( mathematical, string, datetime,
financial functions - mortgage/loan calculation, standard arithmetic operators along with boolean
functions and data type conversion functions. ). Abacus can handle any calculation with ease.


Abacus addon can be used on Contact fields, Group fields or Company fields and you can
run your calculations either automatically or manually.

When it comes to calculations "Abacus Calculated Fields for ACT!" is the first choice.


EXAMPLES OF CALCULATIONS

CALCULATING THE AGE OF A CONTACT

If 'Birth Date' is the date of birth field then use one of the following formulae :

Age( [Birth Date] )
DATEDIFF( year, [Birth Date], GETDATE() )
DATEDIFF( month, [Birth Date], GETDATE() ) /12


ADDING FIELDS

[Field 1] + [Field 2]


MULTIPLICATION OF FIELDS
[Field 1] * [Field 2]


CONVERTING A DATE INTO A STRING

If 'Birth Date' is the date field to convert:
DATENAME(weekday,[Birth Date])+", "+DATENAME(month,[Birth Date])+" "+DATENAME(day,[Birth Date])+", "+DATENAME(yyyy,[Birth Date])
Ex: 01/11/2004 is converted into string 'Sunday, January 11, 2004'



CAPITALIZING THE FIRST CHARACTER OF A FIELD

Lets use 'User 1' field for example:
UPPER(Left([User 1],1)) + LOWER( Substring([User 1],2,Len([User 1])-1) )

Ex: "Send an Invoice" is converted to "Send an invoice"


COPYING THE CONTENT OF A FIELD TO ANOTHER FIELD

This is really simple.
If 'User 1' is the field to copy to 'User 2', open 'Formula Editor' for field 'User 2' and simply
insert [User 1] as formula: [User 1]



FORMATTING A NUMBER ( Lets assume that 'FieldA' is numeric field )

Format( [FieldA],"$###,###.00" )

Ex: if FieldA contains 2343.3 then it will be formated as $2,343.00



BLANKING OUT A FIELD

Simply type a double quote "" in the 'Formula Editor' and the target field will be reset to a blank value.


CONDITIONAL CALCULATIONS

Example 1 ( IF...CASE statement usage ) :

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

Example 2 ( simple CASE statement usage ) :

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


Example 3 ( simple CASE statement usage ) :

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


Example 4 ( searched CASE statement usage ) :

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


For further examples see functions reference http://www.actpresentation.com/abacus.htm
Every function description provides formulae examples.
Publisher: ActPresentation | More by ActPresentation | Visit Home Page
Downloads: so far this month, 0 last month, 44 total
License: Shareware $ 69.95
Last updated: More than a year ago ( 2 Oct 09)
Install support: No Install Support
Watch for updates:
Want to be notified when Abacus Calculated Fields for ACT! is updated?
(no spam, just a single confirmation email)
Subscribe

Tell a friend... | Add to My CD | What's on My CD
User Rating: NOT RATED
Rated by: 0 user(s)
3 out of 5 stars
User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars User 0/5 stars  
Ask a question about Abacus Calculated Fields for ACT!

Add this link to your website:

Or to a forum:


PayWindow Payroll System - Winner of Best Business Application Award, and the People's Choice, Best Business Application Award at the Shareware Industry Conference Awards. Pay by any pay period; hourly, salaried,... ...
Multilingual Stock Exchange & Investment Dictionary Screen shot

Multilingual Stock Exchange & Investment Dictionary

This Multilingual Dictionary of Stock Exchange & Investment Terms contains an extensive vocabulary, covering a wide...

Shareware | $ 19.16
Peachtree Password Recovery (for personal use) buy, download and review

Peachtree Password Recovery (for personal use)

Peachtree Password Recovery is a tool that instantly recovers passwords for Peachtree Accounting company files...

Shareware | $ 29.95
MLDownloader buy, download and review

MLDownloader

MLDownloader downloads intraday, end of day and historical stock quotes, Options and Futures from various Internet...

Shareware | $ 58.15
Zorro MT4 Bridge buy, download and review

Zorro MT4 Bridge

Zorro is a robot platform and development system for automated trading strategies. It supports Gamestudio's lite-C...

Shareware | $ 19.40
MLDownloader buy, download and review

MLDownloader

MLDownloader downloads intraday, end of day and historical stock quotes, Options and Futures from various Internet...

Shareware | $ 58.15
VMInvoice Invoices Management PRO (12 months license) buy, download and review

VMInvoice Invoices Management PRO (12 months license)

VMInvoice - Invoices Management Fast and easy software to create, manage, print and email invoices. VMInvoice is...

Shareware | $ 57.23
MYOB Password Recovery (for personal use) buy, download and review

MYOB Password Recovery (for personal use)

MYOB Password Recovery is a solution that instantly recovers passwords for MYOB Accounting files. All passwords are...

Shareware | $ 29.95
MYOB Password Recovery (for business use) buy, download and review

MYOB Password Recovery (for business use)

MYOB Password Recovery is a solution that instantly recovers passwords for MYOB Accounting files. All passwords are...

Shareware | $ 59.95
ReNoNet Add-In (1-2 User) buy, download and review

ReNoNet Add-In (1-2 User)

Sorry, German Text only ReNoNet ist ein fur den Einsatz in kleinen Netzwerken geeignetes Tools zum Einfugen und...

Shareware | $ 28.13
Friscal Screen shot

Friscal

Friscal is both a FOREX risk calculator as well as a useful toolkit for assisting you with your FOREX currency...

Shareware | $ 25.00