Setup

Each Extension Type has its own Extension table (named by convention 'Type'_Ext e.g. Jobs_Ext), with this table holding all the Extension data for that Type. For historical reasons, the Plant extension data is in the JobSupplement table, and the Log extension data is in the LogExtension table.

For each Extension Field, an Extension Column is automatically added to the relevant Extension table via the "Extensions Table Maintenance" screen.

ADDING EXTENSION COLUMNS

In the Extension table Maintenance screen, select an Extension Type from the dropdown (e.g. Jobs)
In the example below, the Job related Extension data has been selected

The caption for the tab / button which will display (in this case on the Jobs screen) will display underneath the Extension Type. This will default to 'Custom Data Columns', but can be changed (say to Additional Job Data)

On the Extension Fields tab, now enter the Custom Data fields that you want to use in conjunction with the Job Maintenance screen. The example below shows Extension Fields that have been created for the Jobs tab

Data to be entered / selected is:

Field
This is the name of the field that will be created in the table (in this case the Jobs_Ext table). No spaces are allowed in these names

Display Label
The label that will display on the screen for this custom field

Data Type
Selected from the following via the dropdown:

• Text
• Date
• Number
• Yes /No (checkbox)
• Quantity
• Currency
• Combo (user defined selections, including a query on data from another table, entered in the Combo List column on the screen)

For example, a typical query for Plant related data would be
SELECT DISTINCTROW PlantGroupClasses.PlantClassCode, PlantClasses.PlantClassDesc FROM PlantClasses INNER JOIN PlantGroupClasses ON PlantClasses.PlantClassCode = PlantGroupClasses.PlantClassCode ORDER BY PlantGroupClasses.PlantClassCode;

Size
The number of characters allowed in the field

Combo List
Data for the Combo dropdown. A semi-colon delimited list of allowed values or a SQL query

System Column
There are some columns supplied with the standard application which are relevant to standard functionality. They cannot be deleted / changed, and are flagged as System columns

Formatting and Defaults
At the bottom of the screen, for the selected field, the user can enter a default Width and Height (in cms)

• Mouseover text can be entered, which will display when the user hovers with the mouse over the label when in the screen
• A Required checkbox allows the field to be designated as Required. If no data is entered a warning (and only a warning) will be given when exiting the screen.
• A selection of these entered Extension Fields can now be used in the Default View (e.g. on ALL Jobs).
• A selection of these Extension Fields can now be used in other views (e.g. just on Jobs of Job Type = Drainage)