![act by sage training act by sage training](http://www.powertime.com/images/act-orangebox.jpg)
If 'User 1' is the field to copy to 'User 2', open 'Formula Editor' for field 'User 2' and simplyįORMATTING A NUMBER ( Lets assume that 'FieldA' is numeric field )Į.g.: if FieldA contains 2343.3 then it will be formated as $2,343.00 UPPER( Left( ,1)) + LOWER( Substring( ,2, Len( )-1) )Į.g.: "Send an Invoice" is converted to "Send an invoice"ĬOPYING THE CONTENT OF A FIELD TO ANOTHER FIELD
![act by sage training act by sage training](https://m.media-amazon.com/images/I/818bT+VSw-L._AC_SY606_.jpg)
If 'Birth Date' is the date field to convert:ĭATENAME(weekday, )+ ", "+ DATENAME( month, )+ " "+ĭATENAME( day, )+ ", "+ DATENAME(yyyy, )Į.g.: is converted into string 'Sunday, January 11, 2004'ĬAPITALIZING THE FIRST CHARACTER OF A FIELD If 'Birth Date' is the date of birth field then use one of the following formulae :ĭATEDIFF( year,, GETDATE() )ĭATEDIFF( month,, GETDATE() ) /12ĪDDING FIELDS ( CALCULATING A TOTAL SUM ) When it comes to calculations "Abacus Calculated Fields for ACT!" is the first choice. Isn't that what you want from a field calculator? "Abacus Calculated Fields" addon really makes light work of what has been the missing linkĪbacus integrates smoothly into the ACT menu system and the calculations just work. Run your calculations either automatically or manually. Abacus can handle any calculation with ease.Ībacus addon can be used on Contact fields, Group fields or Company fields and you can There are over 80 functions supported by Abacus addon ( mathematical, string, datetime,įinancial functions - mortgage/loan calculation, standard arithmetic operators along with booleanįunctions and data type conversion functions. Links to the Statements, Functions and Operators can be found on the right-hand side Take a look at EXAMPLES OF CALCULATIONS below. In fact Abacus can handle very complex calculations, simply. IF.THEN.ELSE and CASE conditional statements to build calculation scenarios. If you need complex conditional calculations Abacus add-on can do that too - just use Just assign formulae to fields you want to be filled in automatically. Speed up your data entry tasks using automatic data entry feature.Ībacus can automatically load any number of ACT! fields with values determined by the contents of another field. Tired of entering the same information over and over ? "Calculated" fields will be always up-to-date since calculations will be run automaticallyĮvery time when you change value of any field that is a part of formula. Make any field "calculated" in 2 steps : just select a field on layout(using context menu) Calculated fields are highlighted on ACT! layout.Reviewing and changing your formulae is simple.Assigning the formula to a field is simple.It was designed with ease of use as its main aim. "Abacus Calculated Fields" for ACT! now brings you the ability to calculate fields,Ĭopy fields, manipulate data and produce results dependant on the data within other fields, constants, functions and statements. Convert report to MS Powerpoint Presentation.Search by several fields simultaneously.Quick search tool for contacts, companies, groups and opportunities.Enter work period ( start date, end date ) for every company associated with contact.Associate chronological employment history with contacts.Open pictures in your favourite image viewer.Built-in FILTER bar - build quick LOOKUPS!Īdvanced features for picture fields + Scanner & Camera support.Contact list is EMBEDDED in Detail View.Highlight fields depending on field values.Conditional color calculations using "IF" and "CASE" statements.Calculate and change field colors "ON THE FLY".Highlight fields depending on field values Automatic data entry (fill fields automatically).Use "IF" and "CASE" conditional statements to build calculation scenarios.Over 80 supported functions (mathematical, string, datetime, financial).Run your calculations either automatically or manually.Assign calculation formula to field (make a field "calculated").Create calculations involving ACT! fields.
ACT BY SAGE TRAINING SOFTWARE
Customer relationship management ( CRM ) software training, consulting, customization and support. Addon products for ACT! Contact Management software : ACT!2005, ACT!2006, ACT!2007, ACT!2008. Act software : add-ons for ACT! by Sage - Abacus calculated fields ( calculate fields copy fields make calculations in contact group or company fields using over 80 supported functions ).