The cart is empty
Log in

Login to your account

Username *
Password *
Remember Me

Filters

Search

A simple workaround to fix Calculated Fields

Category: Act!
25 January 2017

Calculated fields were introduced in Act! with version 16, but they didn't always work as expected with certain databases. The cause for this is based on Act!'s unique database design that employs spillover tables to manage constantly expanding database schemas.

Shortly into the release cycle of Act v16 it was discovered that if a database had too many spillover tables (typically ten spillover tablles or approximately 300 custom fields), date based caclulated fields did not work properly. That is to say if you had a field that caclulated the number of days or years from-or-to a particlular date field, the field calculting the number of days or years from that date would never update. An Age Field, for instance would not update the contacts age even when a birthday passed.

What we discovered is that this behaviour would only present itself if there were too many spill over tables in the database, AND the two fields in question were not in the same spill over table. In other words, if the age field and the date of birth field were in separate tables, they age would not calculate.

Workaround:

Create a new Birthday field and age field so that they end up in the same table. Once this is done the age field updates as expected, and the database information is accurate.

Share with a friend

Who we are?

Specializing in CRM software for small to medium sized businesses, through expert counsel, deployment, hosting, support, and development services.

Delivering fruitful CRM solutions since 1994, Keystroke is the #1 Act! Reseller in the World and Master Act! Distributor for Canada.

Contact Keystroke

Get in Touch

Toronto   500 Gordon Baker Rd. Toronto, ON, M2H 3B4
Toll Free : 800.857.0558
Office : 416.499.3090
Fax : 416.499.1090

Kitchener   250 Woolwich St. S. Breslau, ON N0B 1M0
Toll Free : 800.939.4737 Ext. 1
Office : 519.579.1408

Montreal   2030 Pie-IX, Local 202  Montréal, QC, H1V 2C8
Toll Free : 888.880.0449
Office : 514.666.7587
Fax : 514.666.9851

Monday to Friday: 9AM to 8PM EST
Saturday & Sunday: Closed