Field Defaults

Displays the fields already assigned to the mask in Field Assignment. Special master attributes for the mask-field relationship can be modified and a title for the mask can be assigned No additional fields can be selected for display in the mask.

Field Name the field's name
Sequence a field's numerical position in the mask
M-Title mask-specific field title/graphic/image
Title regular field title or graphic/image
M-Description mask-specific verbose description of a field
Description regular verbose description of a field
M-Check String mask-specific string to validate user-entered data
Check String regular string to validate user-entered data
M-Default Value provides a mask-specific default value for the field
Default Value regular default value for the field
R-Title vertical position of a field's title in forms
C-Title horizontal position of a field's title in forms
L-Title length of a field title in forms
W-Title width of a field title in forms
V-Title color of the field's title

Shift opens the Mask Data form for a mask component
Form opens the record's Field Data form
Mask Assignment displays a field's usage in masks

Field Name

Name of a field displayed in the mask

attribute master attribute for field (T_FIELD)
type, entry string, no special characters, display only
max. no. of characters 50
selection tool no
multilingual field no

Identifies the field uniquely in the mask-field default relationship. However, you can only (re-)assign fields in Field Assignment.

Syntax:

TABLENAME.COLUMNNAME
for table fields

anything (without a period)
for mask-only fields

@MASKNAME
for placeholders

Sequence

A field's numerical position in the mask

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry Integer, display only
max. no. of characters 5
selection tool no
multilingual field no

Numerical position determines the field's logical position in the mask.

In lists, the fields appear in their logical order, in forms they can be placed arbitrarily.

M-Title

Mask-specific field title, or (for forms) a graphic or image

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 5
selection tool no
multilingual field yes

The entry overwrites the field's regular title, which in turn applies if nothing is entered here.


Field title

In Lists, the title is the field's column label in the list header. In forms, the title can be placed anywhere.

More information: -> Field titles


Graphic (forms only)

When you use this field in forms, you can insert a graphic or image as a label and use it to help design the form.

Entry for the type of graphic:

@RECT
creates a rectangle

@CIRC
creates an ellipse

@LINE
creates a line

You can also set the stroke width of a line or outline.

Entry for the border style:

SOLID
simple lines

BUMP
3D embossed

HOLE
3D engraved

DITCH
edge only engraved

RIDGE
edge only embossed

Example: for a raised rectangle, enter @RECT2BUMP

More information: -> Graphics and images in forms


Images (forms only)

An image is displayed in place of the field title.

Syntax:

#filename

More information: -> Graphics and images in forms

Field Title

Regular field title or (in forms) graphic/image

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 50
selection tool no
multilingual field yes

Shows the field's regular title, which can be overwritten for single masks.

M-Description

Mask-specific verbose description of a field

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 50
selection tool no
multilingual field yes

The entry overwrites the field's regular description, which in turn applies if nothing is entered here.

When users are editing a record and the cursor enters a field, its verbose description appears in the mask's footer. You should use the description to characterized the field in more detail or warn of potential invalid data.

Description

Regular verbose description of a field

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 50
selection tool no
multilingual field yes

Shows the field's regular verbose description, which can be overwritten for single masks.

M-Check String

Mask-specific string for validating data entered into a field

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 50
selection tool no
multilingual field no

The entry overwrites the field's regular check string, which in turn applies if nothing is entered here.

You can use check strings to check the syntax of the data entered into a field, e.g. whether an article number complies with certain conventions. Check strings consist of a series of check characters.

Check characters:

0
The character entered will be changed into a space character. If the position is pre-assigned by a character (Default value), this character is fixed to the position. If the pre-assigned value is shorter than the check pattern, a space character will be entered.

a
Capitals automatically changed to lower case, any character permitted.

A
Lower case automatically capitalized, any character permitted.

I
Capitals automatically changed to lower case, no special characters.

L
Lower case automatically capitalized, no special characters.

N
Only numerical characters.

X
X represents any fixed character. Any character entered will be automatically changed into the fixed character specified here. This process is case-sensitive, irrespective of whether the user presses the Shift key or not. Special characters are allowed.
With \X the meaning of check characters cease. They become regular characters and can be used as fixed characters.

>[check character]
Placing > in front of a check character requires that every character after the position of the check character complies with the check character. The check character ">0" (even as a sub-string) is illegal.

Attention! The check string may not contain spaces followed by further check characters.

More information: -> Check string for field entries

Check String

Regular string for validating data entered into a field

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 50
selection tool no
multilingual field no

Shows the regular check string, which can be overwritten for single masks.

M-Default Value

Provides a field with a mask-specific default value when a record is created.

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry string, entry optional
max. no. of characters 50
selection tool no
multilingual field no

The entry overwrites the field's regular default value, which in turn applies if nothing is entered here.

If the field is used in a mask, DataView automatically enters the default whenever a user creates a new record. The user may or may not be able to alter the default, depending on the field's access status.

Entry:

@DEFAULT
references a variable in the Default Data list. DataView writes the variable's value into the field, allowing it to be set independently of the user

@USER
enters the current user into the field

@GROUP
enters the current group into the field

@TODAY
enters the current date into the field - which must be of type DATE

Filename
Default graphic file for BLOB fields. This is the graphic displayed in forms if the database BLOB field is empty. The default graphic file must be stored in a folder on the server. The path may also be given.

More information: -> Automatically filling fields

Default Value

Regular default value for a field when a record is created.

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 50
selection tool no
multilingual field no

Shows the regular default value, which can be overwritten for single masks.

R-Title

Vertical position of a field's title in forms

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry Integer, entry required
max. no. of characters 5
selection tool no
multilingual field no

The vertical position of a field title or graphic/image is given relative to the field's position in forms, in lists, the entry is ignored.

More information: -> Field titles, -> Graphics and images in forms

C-Title

Horizontal position of a field's title in forms

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry Integer, entry required
max. no. of characters 5
selection tool no
multilingual field no

The horizontal position of a field title or graphic/image is given relative to the field's position in forms, in lists, the entry is ignored.

More information: -> Field titles, -> Graphics and images in forms

L-Title

A field title's length within forms.

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry Integer, entry required
max. no. of characters 5
selection tool no
multilingual field no

A title is always one row long in lists, and DataView ignores the entry.

The entry determines the appearance of graphics as follows:

For an image window, the entry depends on the image itself and the grid settings.

More information: -> Field titles, -> Graphics and images in forms, -> Scaling graphics on the grid

W-Title

A field title's width within forms.

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry Integer, entry required
max. no. of characters 5
selection tool no
multilingual field no

A title is always as wide as the field in lists, and DataView ignores the entry.

The entry determines the appearance of graphics as follows:

For an image window, the entry depends on the image itself and the grid settings.

More information: -> Field titles, -> Graphics and images in forms, -> Scaling graphics on the grid

V-Title

A field title's foreground and background color within a mask

attribute relation attribute for mask-field (T_MAS_FLD)
type, entry two-digit integer, entry required
max. no. of characters 2
selection tool menu containing all video settings, colors are displayed
multilingual field no

The entry is mask-specific. You can make global changes using the Client Settings Tool.

Entry:

first digit (0 ... 5)
foreground (field entry) color

second digit (0 ... 5)
background color

More information: -> Color settings for fields and field titles

Shift

Opens the Mask Data form, if the record contains a mask component.

If a mask component exists as a field name, the corresponding form for editing it is opened.

Form

Opens the record's Field Data form.

Mask Assignment

Opens the Mask Assignment form and shows the masks where a field is displayed.