Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Fields are the different types of input fields that are used inside module layout to enter user inputs. User can drag and drop a list of required fields inside a module to create a desired form. The different types of fields supported by ONEWEB are as follows:
Field Type
Description
Text box
To enter text and numbers.
Label
To show static labels on the screen. It comes with rich text options.
Hidden
To store hidden fields on screen. Mostly used to manipulate the module keys.
Text Area
To enter text of more than 100 characters.
Radio button
To allow selection of a specific choice from multiple choices.
Checkbox
To allow selection of one or more data from multiple choices.
Listbox
To display a list of static data as a dropdown. The values to be shown are set in the field itself.
Dynamic List
To display a list of values dynamically as a dropdown. The data is shown from a table in the database and can be controlled to show values depending on another field in the module.
Popup
To display a list of data from a table in database as a popup window. It also has a text box for searching data based on the key
Calendar
To enter date fields
Suggestion box
This field can suggest data to user in a dropdown based on the data keyed in. Moreover, users can use keyword search in this field
No Object
Special field used to display a custom value on the screen that is not part of the data in the table of the module.
Multi Select
To provide multiple select option.
Upload
To attach and upload files.
Note: Fields can only be dragged and dropped inside your Entity Modules. So, It is important to note that user must first drag the module inside entity and specify the rows and columns, and then only can begin to add fields into entity.
The Hidden field is a field used to store hidden values on page like id. Once user drags a field of type Hidden onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Hidden 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.
Default Value
The default value for this field.
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.
The Label is a field used to display text. Once user drags a field of type Label onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Label 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.
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
Show Data
To enter the text to be displayed in the place of this field. User can enable RichText option to add RichText content
Alignment
left
To set Text Alignment. It provides 3 options to choose from: right /left /center.
Authen
N
Enabling it, calls an ONEWEB authorization engine (IAM)
The Text area is an input field used to enter text of more than 100 characters. Once user drags a field of type Text area onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Text area 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.
Row Size
4
The number of rows to be displayed in the text area.
Default Value
The default value for this field.
Display as Rich Text
N
To define whether to enable Rich Text or not.
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.
The List Box is an input field used to display a list of static data as a dropdown. Once user drags a field of type List Box onto the entity, user must click on the edit icon to open the configuration window as shown below.
The List 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.
Listbox Form Values
Value
Y
Value of the list item
ShowName
Y
Displayed text for the list item
Seq
N
Sequence of the list item
Default Check
N
To have the item selected by default
Source tag
This field is used to insert JavaScript at the item level.
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
Condition Tab
N
To define if this field trigger condition tab feature.
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.
The Calendar is an input field used to enter dates. Once user drags a field of type Calendar onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Calendar 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
Use Calendar
Y
This is used to define if the calendar icon needs to be displayed or not.
Buddhist Calendar
N
To use Buddhist date.
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.
The Radio is an input field used to allow selection of a specific choice from multiple choices. Once user drags a field of type Radio onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Radio 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.
Radio Display Data
Value
Y
Value of the radio item
ShowName
Y
Displayed text for the radio item
Seq
N
Sequence of the radio item
Default Check
N
To have the item checked by default
Source tag
This field is used to insert the JavaScript at the item level.
ColumnCount
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 savingCHECK_EMAIL_FORMAT - require user to input value in email format before saving.
The MultiSelect is an input field used to select multiple values. Once user drags a field of type MultiSelect onto the entity, user must click on the edit icon to open the configuration window as shown below.
The MultiSelect 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.
Default Value
The default value for this field.
Source Tag
This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
Table Name
Y
To define the table from where the data is retrieved dynamically.
Column Show
Y
To define the column whose value should be displayed in the list.
Column Value
Y
To define the column whose value will be used as the value of selected data.
Condition
To define any condition for retrieving data.
Alt Desc
Destination Table
The table to store the multiple values
Parent Key
To define the column which is used for foreign key reference.
MultiSelect List Key
To define the corresponding key column in multi select table.
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.
The Suggestion is an input field used to suggest data to user in a drop down based on the data keyed in. Moreover, users can use keyword search in this field. Once user drags a field of type Suggestion onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Suggestion 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
Maximum number of characters allowed on this field
Size
Maximum size to be displayed.
Default Value
The default value for this field.
Table Name
Y
To define the table from where the data is retrieved dynamically.
Column Show
Y
To define the column whose value should be displayed in the list.
Condition
To define any condition for retrieving data.
Global ID
To define Global ID of the field.
Dependency Data
Depend Column
To define the column on which the data will depend on.
Sequence
To define the sequence of the column in the condition.
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
Condition Tab
N
To define if this field trigger condition tab feature.
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.
The Upload is an input field used to attach and upload files. Once user drags a field of type Upload onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Upload 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.
Upload Path
The upload file path on server.
Max File Size
256
To define the maximum file size allowed.
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.
The Checkbox is an input field used to allow selection of one or more choice from multiple choices. Once user drags a field of type Checkbox onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Checkbox 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.
Tabular Type
N
To set the checkbox as a table.
Checkbox Form Values
Value
Y
Value of the radio item
ShowName
Y
Displayed text for the radio item
Seq
N
Sequence of the radio item
Default Check
N
To have the item checked by default
Source tag
This field is used to insert JavaScript at the item level.
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.
The Dynamic List is an input field used to display a list of values dynamically as a dropdown. Once user drags a field of type Dynamic List onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Dynamic List 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.
Default Value
The default value for this field.
Source Tag
This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
Table Name
Y
To define the table from where the data is retrieved dynamically.
Column Show
Y
To define the column whose value should be displayed in the list.
Column Value
Y
To define the column whose value will be used as the value of selected data.
Condition
To define any condition for retrieving data.
Global ID
To define Global ID of the field.
Dependency Data
Depend Column
To define the column on which the data will depend on.
Sequence
To define the sequence of the column in the condition.
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
Condition Tab
N
To define if this field trigger condition tab feature.
Search Criteria
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.
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.
The No Object is an input field used to display a custom value on the screen that is not part of the data in the table of the module. It is mostly used to display custom data or data from another table. Once user drags a field of type No Object onto the entity, user must click on the edit icon to open the configuration window as shown below.
The No Object 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.
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.
The Popup is an input field used to display a list of data from a table in database as a popup window. It also has a text box for searching data based on the key. Once user drags a field of type Popup onto the entity, user must click on the edit icon to open the configuration window as shown below.
The Popup 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.
Popup Display Data
DB Column Name
DB Column
Show Name
Display name on popup window
Seq
Sequence of the fields
Alignment
Alignment of field on popup
Display
Yes
To define field as hidden field or display field.
SQL Command
Y
The SQL Command to retrieve the data to be displayed on popup.
Search Key
The field to be used for the search
Map Column
Y
The column whose value is mapped back to main field if selected
Map Column Display
Y
The column that is displayed as code on the main field
Map Description
Y
The column that is displayed as description on the main field
Source Tag
This field is used to insert the JavaScript at the Field level e.g.: readonly, onchange = validateNum(this) etc.
Text Size
Size of the Code field.
Max Length
Maximum number of characters allowed on this field
Map Entity
Show Go Button
Description Size
To define size of description field.
SearchLike in Popup
N
To define wildcard search in the popup.
UNClose Flag
N
To define if popup needs to close automatically on selection or not.
SearchIgnoreCase in Popup
N
To define if the search should ignore case.
Search Criteria Entity ID
Global ID
To define Global ID of the field.
Dependency Data
Depend Column
To define the column on which the data will depend on.
Sequence
To define the sequence of the column in the condition.
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.
