Custom Defined Fields

yellowbox

The Custom Defined Fields tab of the Codes Maintenance program consists of three sections:

  • Custom Defined Fields Setup

  • List Values

  • Access From TruckMate Programs

Custom Defined Fields Setup

Table Name

Double click this field to select a table Name from your system tables. Not all TruckMate tables are available for selection for Custom Defined fields. The table you specify will limit the programs that you may add this Custom Defined field to in the Access From TruckMate Programs section.

Label

Enter a Label for the Custom Defined Field you are about to add to the table you have selected above. This label will appear next to the input field on the Custom Defined tab of the program you specify.

Type

Click the pull down menu arrow to select a 'Type' Code for your Custom Definitions. Available values are: 'LIST', 'TEXT', 'DOUBLE' and 'DATE'. These types function as follows:

  • LIST fields appear as 'Drop-down' menu fields (populated with entries that you specify in the 'List Values' section described below).

  • TEXT fields are free format text entry fields, commonly used in TruckMate as 'Note' fields.

  • DOUBLE fields are used to contain precise decimal numbers (FLOAT values >= 22 characters in length), or very large integers. When entering large integers into a 'DOUBLE' field, the numbers will be formatted using normal Scientific Notation conventions. For example: '1000000000000000' becomes '1E15'.

  • DATE-TIME fields are time stamp fields, used to record pickup and delivery dates along with times, and so on. Double-clicking these fields will open the standard TruckMate Calendar menu, where you may select a date using a graphical interface. A date along with a time stamp will be stored in the database.

  • DATE-ONLY fields are used to store only the date portion of the time. The system will only store the date without the time-of-the-day in the database.

Read Only

This is a flag that has the possible values of 'True' or 'False' (the default value). If set to 'True', this means that the selected field cannot be updated by users, and can only be used for viewing.

List Values

If you have chosen the 'List' field type in the 'Type' field above, enter any number of List Values in the List Values section by clicking the '+' button and manually typing them into the 'List Values' field. The values you enter here will be accessible as a drop-down menu from the Custom Defined tab of whatever program(s) you specify in the 'Access From TruckMate Programs' section described below.

Access From TruckMate Programs

The Access From TruckMate Programs section displays all of the TruckMate programs that may access the Custom Definitions being created.

You can use the TruckMate Navigation bar to add program records one at a time by using the '+' button, or you can use the 'Auto-Add All' button to add all possible programs at once.

Auto-Add All

image33 Click the 'Auto-Add All' button to quickly add all possible programs that can access the Custom Definitions being created.

Set Order of Appearance

image42 If a program has more than one Custom Defined field setup, you can use this button to open the Set Order of Appearance window, which will allow you to configure the order that the Custom Defined fields will appear on the program’s Custom Defined tab.