Building the Call Address Formula to add new fields, user defined fields or to delete fields.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Building the Call Address Formula to add new fields, user defined fields or to delete fields.
Document ID : 000-000324 Created: 6/14/1999 Last changed on: 6/14/1999

You can override the Service Call Address Field layout by entering a Call Address Formula. The normal layout of this field is as follows:

Name
Address
City State Zip
Country

You can use a different formula to enter and field from the Organization (Company), Department and Contact tables. The fields in these tables are
defined in your data dictionary file, NKCAP.CLA

The data dictionary file is a text file that can be printed as needed. However, be careful not to change this file as it is used by the CFIL file
management utility.

Entering the formula
Once you have decided which fields to pick from the tables, enter the formula into the text box without pressing the ENTER key. The ENTER key will
add a carriage return to the formula and the formula will not work. For clarity, you can enter a space or two between fields. Do not enter too many
spaces as the formula length is limited to about 500 characters.

Formula example:
The new layout will include the department name and the contact's tile. Also a user defined field will be added at the end. The resulting layout is:

Name
Company Name
Department Name
Contact's Title
Address
Att: Secretary

The formula for the above layout is as follows:

CLIP(ccm:FirstName)&' '&CLIP(ccm:LastName)& chr(13)&chr(10)&CLIP(cim:Name)&chr(13)&chr(10)&clip(cdm:Name) &chr(13)&chr(10)&clip(ccm:title)
&chr(13)&chr(10)&clip(ccm:Address1) &chr(13)&chr(10)&clip(ccm:City)&' ' & clip(ccm:State)&' ' & clip(ccm:ZipCode) & ' Att: '& CLIP(ccm:UserDef201)

Notes:
1- Do not press ENTER while entering the formula. The program will wrap the formula to fit the text box. Pressing ENTER while entering the formula
will create an incorrect formula.

2- The chr(13)&chr(10) sequence enters a carriage return and line feed sequence to start a new line
3- Literal text is enclosed in single quotes, not double quotes.
4- The CLIP() function removes trailing spaces.
5- The UPPER() function capitalizes a field.
6- To add spaces between fields add literal text as follows : ' ' (single quote space single quote)
7- The & (ampersand) symbol is used to concatenate the fields together
8- An incorrect formula will result in a blank address field.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.