Text Box

Text Box onto the entity, user must click on the edit icon to open the configuration window as shown below.

The Text Box Configuration Settings are described below:

Property

Default value

Mandatory

Description

MF ID

System Generated number

Y

MF ID is unique and is generated by system automatically.

Source Tag

This field is used to insert the Javascript at the Field level e.g.: readonly, onchange = validateNum(this) etc.

Max Length

20

Maximum Field length of content to be stored.

Size

20

Maximum Field length to be displayed

Password Flag

N

This is used to display the characters in password format.

Default Value

The default value for this field.

Number Formatter

Help to format fields containing numbers. It contains 3 types to choose from: Integer, currency and Decimal.

Field_ID

[FIELD_ID]

To define the database field mapped to this field on the smart form.

ShowFieldName

[SHOW_FIELD_NAME]

Y

To define the field label to be displayed on the screen. Clicking on the blue icon will auto generate the field name based on field id

SearchCriteria

N

To define if this field is to be used as one of the search criteria in the search screen.

ShowSearch

N

To define if this field is to be one of the search results (in table)

SearchFromTo

N

To define if the field is to be searched in range in the search criteria.

SearchPreLike

N

To define if this field should allow wildcard search e.g. (%XXX)

SearchLike

N

To define if this field to allow wildcard search e.g. (XXX%)

SearchIgnoreCase

N

To define if this field is to allow search by ignoring case.

JoinSearchTable

N/A

Usually required when JOIN SQL is used to produce the search screen. Join with another table to show results

SearchFieldGroup

0

This setting is used to configure the position of the field in the search criteria screen horizontally (row).

SearchCriteriaSeq

0

To configure the position of field in the search criteria screen vertically (column).

ShowSearchSeq

0

To configure the position of the field in the search results.

Alignment

left

To set Text Alignment. It provides 3 options to choose from: right /left /center.

OnlyGuiFlag

N

To configure the field as a UI field. This field is not persisted into the database.

ViewFlag

N

Y- To view field in read/view mode in Edit screen.

KeepHistory

N

To configure the field values to have history information persisted into database.

FilterFlag

N

Used in 1-Many module to filter the records based on value of the field.

Authen

N

Enabling it, calls an ONEWEB authorization engine (IAM)

MergeFlag

N

To merge this field to the next column as well. Usually used to display a field across two columns

Validate Code

CHECK_NULL

Y - to make Validation check.

CHECK_NULL- will check for null in the field before saving.

CHECK_INTEGER - will check for integer value before saving.

CHECK_DECIMAL - will check for decimal value before saving.

CHECK_EMAIL_FORMAT - require user to input value in email format before saving.

Last updated