Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > support > online help > automatic field calculations for act! 2020 > table of content

Online help
Automatic Field Calculations

PREVIOUS TOPIC
Creating a calculation series

NEXT TOPIC
Functions Reference guide (PDF download)

Multiple databases

In a multiple database environment, be aware of the following options:

  • When creating a calculation or series, you have the option to make the calculation or the series available to all databases. If you do not select this option, the calculation or series will not be available when running Automatic Field Calculations in another database.
  • If a calculation is not available in the current database and you want to change this, go to Options>Multiple databases and you'll be able to see all the calculations and series you created, no matter the database and to change their scope.
  • When assigning a calculation or series to a field, you have the option to make the assignment available to all databases. If you do not select this option, the assignment will not be available when running Automatic Field Calculations in another database.

Important note

Even though only the "display" names of your fields appear in the syntax editor, Automatic Field Calculations actually stores the internal name of the field. For instance, you might have a field called "Sales Representative" (its display name) but the real name stored by AFC is "TBL_CONTACT.SALESREPRESENTATIVE_0129844". The internal field name is assigned to your field at creation time and cannot be controlled, nor modified.

This is a key notion to remember when making a calculation available to multiple databases. Even though your databases might all have a "Sales Representative" field, the calculation will work only if these fields have the same internal name.

Two databases have similar internal field names only:

  • for the standard fields that ACT! automatically creates when you create a database;
  • for all fields that are inherited from the other database (Ex: a satellite database that you create to synchronize will inherit the same field names as its master database. Same when you create an empty copy of a database);

PREVIOUS TOPIC
Creating a calculation series

NEXT TOPIC
Functions Reference guide (PDF download)

Back to the Table of Content

   

Across this Web site, ACT! and ACT! Premium, Sage ACT! Pro and Sage ACT! Premium are referred to as ACT! or Sage ACT!.

home | products | support | order now | resellers | contact us | meet now
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, Sage ACT! Pro and Sage ACT! Premium are registered trademarks of Sage Corporation.