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.