The cart is empty
Category: Act!
Written by Ken Quigley
January 25 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

 
paybillicon56x58px  

Pay your bill online

 

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

Your Cart

×
Customers that ordered this item frequently bundle it with the following products or services for the best user experience
Save 10% on eligible items when bundled with this product
The cart is empty
Continue shopping