Description of the data type
The following data types are available:
String
Field is string with number, letters and special characters.
Date
Field is date. Uses system’s date format.
Time
Field is time. Uses system’s time format.
Date and time
Field is date with time. Uses system’s date format.
Integer
Field is number.
Decimal
Field is number with decimal. Define decimal places in Decimal places field.
List of values (LOV)
Creates list of values.
Define values in values field. Enter key(id or code) and value.
You can set default value to be selected in Default value field.
Automatic
Field is set automatically. Field is set after document rules are set to fill values after an event. When event happens the trigger activates and automatically fills corresponding value into field.
Set trigger in Triggers field and select trigger type – Always or Once. Always updates the field every time event occurs.
Quick guide to setup automatic field:
a) set data type to “Automatic”
b) set triggers in Triggers field (description below)
c) set trigger type in Trigger type field.
Trigger types:
Internal (value changed on dependent field)
Trigger is activated when dependant filed’s value is changed.
External
Trigger is activated on a specific event:
– Document reception (documen received via exhange)
– Document liquidation (action on document)
– Capture, Scanning (when we capture the document)
– Create (forms, templates)
– Sending (at sending document)
– Document meta-data change
– New
Any trigger (in rules, scripts)
Define custom trigger.
Script
In the Script field, specify the patterns used to set the automatic values in the EBA DMS system. The patterns have the characteristics of a scripting language, so it is recommended that they are set by experts in programming languages.
Pattern structure
A pattern is structured as a string of characters that may contain special expressions (program variables) that the program converts into corresponding values. Each expression in the character string must be enclosed in square brackets (“{}”). Any characters outside the curly braces are literally rewritten in the result as text.
Special expressions shall be written into the pattern by first defining a global object (described below) and then any number of dot-separated functions to be executed over the value of the global object.
The parameters of the functions are given in single or double quotes (“” or ”). A function parameter may again be followed by an expression or a global object. This is called expression nesting (e.g. {counter(env(‘USER’))} ).
The values of other fields in the stamp can also be accessed in the expression. Fields on a stamp are accessed by specifying the field name in the expression. The field name is specified in the Id property. The field id must be preceded by a $ (e.g. $id).
Concrete values are always in single or double quotes, whatever their type.
Functions
You can use the following functions in the sample:
toString(p); the function returns a formatted string of characters. If the object is of type date, time or date_time, the function converts the date or time into a character string formatted according to the description of the format given in the parameter. The following formats are possible:
d day without leading zero (1-31)
dd day with leading zero (01-31)
ddd abbreviated localised name of the day (e.g. “Mon”… “Sun”)
dddd long localised name of the day (e.g. ‘Mon’…’Sun’)
M month without leading zero (1-12)
MM month with leading zero (01-12)
MMM abbreviated localised month name (e.g. ‘Jan’…’Dec’)
MMMM long localised month name (e.g. ‘Jan’…’Dec’)
yy year as a two-digit number (00-99)
yyyy year as a four-digit number (1752-8000)
h hour without leading zero (0..23)
hh hour with leading zero (00..23)
m minute without leading zero (0..59)
mm minute with leading zero (00..59)
s second without leading zero (0..59)
ss second with leading zero (00..59)
If the object is of numeric type, the function parameter is formatted as %d (e.g. %0.4d formats the number 100 to at least 5 digits, with leading digit 5, the result looks like this: 0.100).
arg(a); the function replaces the smallest code %1, %2, …, %9 by the value of the parameter a.
replace(a, b); the function replaces each occurrence of parameter a in a character string by the value of parameter b.
left(n); the function returns a substring of characters containing the n starting characters of the string.
right(n); the function returns a substring of characters containing the n ending characters of the string.
mid(i, n); the function returns a substring of length n characters, starting at position i.
append(a); the function appends the value of the parameter a to the end of the character string.
preppend(a); the function appends the value of parameter a to the character string at the beginning.
Table
Select table if you want to show fields in table. You must create columns within table with double click on table field caption on the left pane. Columns are create the same way as stand-alone fields with same properties available. You can even create table inside a table.
List of values (database)
As source for LOV you can use external database. You can create queries to define a set of values.
You need to define database in database field and create query to return the result.
Example: using code lists that are created and maintained in another system e.g. your company’s ERP system.
Quick guide to setup database LOV:
a) set data type to “List of Values (database)”
b) set database in Database field
c) enter query in Query field. Set display and value field.
d) (optional) Edit columns to desired setup.
String (database)
Uses an external database as a data source, you can create queries to define a set of values. It has a few more options than a list of values (database), creating nested queries and the ability to create automatic nesting/linking.
You need to define database in database field and create query to return the result.
Boolean (yes/no)
Provides checkbox option true or false. You can set default value to either yes or no.
Text area
Creates field with text area. You can set default row number.
Multi select combo
Drop-down list with multiple choice selection. Enter values in Values field. You must enter key (id or code) and value name.
Check grid
Provides grid of checked boxes.
Image
Image field where you can insert image.
Hyperlink
Field with URL. You must enter URL and hyperlink text.