Custom display formulas in SQL products

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

Custom display formulas in SQL products
Document ID : 000-000823 Created:12/12/2003 Last changed on:12/12/2003

You can override the formatting of most areas used to display data such as the Service Call Address Field, the Request field, the inventory data field and others. See your NetKeeper product manual to check which fields can be re-defined in your version of NetKeeper software.

You can change the layout by entering a new formula. For example to you can change the 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.

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.