Showing results for 
Search instead for 
Do you mean 

Act! Calculated Fields Peek #Actv16Peek #ActCRM

by ‎08-02-2013 07:57 AM - edited ‎08-02-2013 07:57 AM (14,456 Views)

How many days do we have until this customer’s contract renewal?  What is my commission on this opportunity based off of its weighted total? What’s the average age of my key customers?


Aaaaaaarg!! These simple questions can drive a person mad trying to figure out how to get to this information. I’ve got the data, but I need to export it to Excel and figure out date calculations?!


I need this in Act! or quickly available outside of it.




Act! v16 puts your data to work for you by performing calculations automatically in a field using data from other standard or custom fields.  Use calculations based on age, date, percentage, dollar value, currency, and other data to help you prioritize and make data-driven decisions.  Automate specific actions based on calculated data, including contract renewals, birthday and thank you notes, follow-up surveys, restock reminders – and more.


Act! v16 has a new field type of calculated fields that allows you to count days and years between today and a date, or make simple to complicated mathematical expressions of off number fields in your database. This is available for Contacts, Groups, Companies, Opportunities, and even products (customer ordered 2,112 units, how many boxes is that?). We implemented this in a way that makes this instantly available through desktop, web, or mobile. This data syncs, exports, and you can create lookups off of it. You can even trigger a Smart Task so that 15 days before the contract renewal date you schedule a call to review this year’s plan.


See below for a silent video of Age and Commission fields in use.


How would this feature make your life easier?


Benjamin Lederer

Product Manager for Act!

on ‎08-02-2013 10:13 AM

Have been asked if this could be done more than once. Thanks.

on ‎08-07-2013 09:44 AM

Mark, just FYI, it's been possible for a few years (with a few extra functions):


But yes, great that the basic functions are going to be in the product


Mike Lazarus
ACT! Evangelist
GL Computing, Australia

GL Computing Facebook Page -
LinkedIN ACT! Fanatics Group -

on ‎10-25-2013 02:25 PM

Does anyone have any guideline, manuals or examples of how to use calculation fields in V16?