Screen Builder Field Entry

User Field or Standard Field

Enter the field name. The field name can be either a standard pre-defined field or a user defined field. Standard fields have pre-defined lengths and field types. You will not need to specify any further information other than the field name in this case.

If you are editing a user defined field and wish to keep the information already entered in that field, do not change the field name.

Certain field names are reserved by CAPITAL for future use. This is to ensure that there are no field name clashes when upgrading CAPITAL. You may not create fields starting with the following letters in the areas specified:

Starting Letters	Area
ST	Stock Control
CUS	Customer Accounts
SUP	Suppliers
SM	Service Manager
HI	Hire Manager

There are no restrictions on field names when working with card files.

Type

Enter the field type.

Type	Description
Character	Letters and numbers can be entered.
Numeric	Only numbers, normally amounts of money, will be acceptable.
Date	Only valid dates will be accepted.
Yes/No (check box)	A check-box will be created. Users may either tick the box for 'yes' or untick for 'no'.
Transaction	Only standard CAPITAL transaction numbers are acceptable. These numbers are 9 characters wide and cannot contain punctuation. Numbers may be prefixed with letters. So: 1000, 23813, A23893, CR23931 are acceptable transaction numbers but 28983E or ABCD are not.
Quantity	CAPITAL stock quantities. These conform to the same characteristics as stock quantity tracking fields.
List Item	A list of items for the user to select from a drop down menu. The list may be defined via CBS or the field may be linked to a list within the CAPITAL List Manager. It is important to ensure that your Field Length is large enough to store the entry selected from your list of choices.
Editable List Item	Similar to a List Item, except that the entry may also be typed in directly or edited by the user, once selected from the list of choices.

Sort

Specify the sort order. You must specify a sort order on a field if you want to use the CAPITAL Fast Find feature to locate a record. Sorting a field also allows you to move through a series of records in alpha-numerical sequence based on the sorted order of the field.

For tips on designing fields for easy searching see Multi-Field Matching in the Screen Builder Solver topic.

Label

The name/title of the field. This is what appears in front of the field. This is optional but recommended.

Input Clause

The input or "picture" clause or "template". You may optionally apply further input restrictions depending on the field type you have specified.

A Accept letters of the alphabet only.

! Accept upper case only.

@! Accept upper case only for entire field.

N Characters and numbers only - punctuation is not acceptable.

D Accept numeric input only.

You may use these codes in combination but you must place the "@" codes before all other codes. For example:

@! NNNNNN

Forces all input to upper case (@!) and then the next 6 characters as letters or numbers only.

Other examples include:

NNNNNNNNNNN

Forces first 10 characters as alphanumeric only (no punctuation allowed).

!!!!!!!!!!

Forces first 10 characters to upper case.

Remember, this:

Forces the entire field to upper case regardless of the number of characters in the field.

Combinations of template characters may be used like so:

@! AAANNN-9

The entire field will be forced to upper case. The first three characters must be alphabetical, the next three must be numeric, a "-" will be inserted into every field at the 7th position and the character at the 8th position must be numeric.

The Input Clause is not available as an option if you select a List Item or Editable List Item as a field type.

Lookup List

Type in the name of the list you wish to link to the field or press F12 to view a selection of available lists.

The Lookup List selection is only avilable when the field you have defined is set as a List Item or Editable List Item type.

You may create your own lists from within the List Manager or they may be defined 'on the fly' using the CAPITAL Business Script language.

Status Message

The message to appear on the status bar at the bottom of the window when this field is prompted for. An entry in this field is optional.

Field Length

The length of the field. Standard fields have pre-defined field lengths.

Decimal Places

The number of decimal places to accept. This field will only be prompted for if a numeric field type was specified.

Display Length

The length of the field that will be shown on the page. The display length may be less than the actual field length, but cannot be greater. This defaults to the field's actual length.

Look-up Button

Tick this option to place a button next to a field. The button can be accessed by clicking on it or pressing F12.

Some fields have default buttons that cannot be deactivated. Date fields always have calendar buttons and these cannot be deactivated either.

If you have added a button to a field then when the button is pressed, any applicable script code assigned to that field is executed. You can distinguish between a user changing the contents of a field or pressing the button next to it, by checking the ButtonPress variable inside the script. For example:

If ButtonPress

* User pressed button

ScrLookUp("Rego", "Truckno", 1)

Else

* user must have edited contents

Endif

Pressing a button also triggers a mode 9 event. For more information on script programming and events see: Script Creation.

Access Level

The security access level the user who has logged in must have, in order to access this field. (The access level should be higher than the Start-up Security Level found under Install\Security, otherwise it may have no effect.)

The options that follow define the type of access allowed.

Lock

The field is locked unless a user has a sufficiently high security access level as defined by the Access Level setting. Locked fields cannot be edited and will appear on the page as greyed out.

Hide

The field is hidden unless a user has a sufficiently high security access level as defined by the Access Level setting. Hidden fields do not appear on the page for users without the necessary security clearance.

Always Lock

The field is always locked--cannot be edited--regardless of security access level. This is is useful if the field contains, for example, the results of a calculation and is not supposed to be edited.

Font Colour

The colour of the field. The default is black. The field colour can be changed in order to draw attention to a field on the screen. The colour of the font displayed in the field will be changed, not the colour of the edit control.