|
These formulas are presented when the formula editor is being accessed in the SE Form component. In SE Form, these functions will be presented when editing a formula for a form field or a form associated with a process.
Form
Functions that return values of the table:
▪TABLE LIST VALUE: Returns the value of a table field.
Syntax:
|
LISTVALUE('<table ID #>';'<relationship ID #>';'<field ID #>')
|
▪TABLE FIELD VALUE: Returns the value of a table field.
Syntax:
|
FIELDVALUE('<table ID #>';'<field ID #>')
|
▪FIELD VALUE WITH FILTER: Returns the table value.
Syntax:
|
FIELDVALUEFILTER('<table ID #>';'<field ID #>';'<filter>')
|
▪TOTAL GRID: Returns total value.
Syntax:
|
TOTALGRID('<relationship ID #>';'<table ID #>';'<field ID #>';'<operation>')
|
|
Functions that perform some action on the items of the form:
▪ACTION: The number of parameters varies, because it depends on the number of variables for the calculation.
Syntax:
|
ACTION('<field ID # list>';'<field ID # list>';'<field ID # list>';'<field ID # list>';'<field ID # list>';... ;'<variable number of parameters>')
|
▪GROUP ACTION: Applies actions (enable, disable, etc.) for a group of actions within a fieldset.
Syntax:
|
GROUPACTION('<field ID #>';'<operation>';'<value>')
|
▪ACTION IN GRAPHIC ITEM: Applies actions (enable, disable, etc.) to a graphic element. Example: Fieldset, image, etc.
Syntax:
|
ACTIONGRAPHICITEM ('<fiedlid#>';'<operation>';'<value>')
|
▪DISABLE GRID ACTION: Disables defined buttons on the form grid.
Syntax:
|
DISABLEACTIONGRID('<grid ID #>';'<grid buttons that will be disabled (E.g.:Add,Edit,Delete)>')
|
▪ENABLE GRID ACTION: Enables defined buttons on the form grid.
Syntax:
|
ENABLEACTIONGRID('<grid ID #>';'<grid buttons that will be enabled (E.g.:Add,Edit,Delete)>')
|
▪EXECUTE SCRIPT: Executes an event in selected element
Syntax:
|
EXECUTESCRIPT('<Id #>';'<Event>')
|
|
▪EDIT LIMIT: Edits field limit (textarea/memo) from 4000 characters to less.
Syntax:
|
EDITLIMIT ('<field ID #>';'<value>')
|
▪OPEN FORM: Opens form in execution mode.
Syntax:
|
OPENFORM('<Form ID #>')
|
|
▪IMPORT SPREADSHEET TO GRID: Updates a grid with a listing originating from a spreadsheet.
Syntax:
|
IMPORTSPREADSHEETTOGRID('<Grid relationship ID #>';'<List of the relation between the table attributes and the spreadsheet columns (E.g.: ATR01=A, ATR02=D, ATR03=E)>';'<Clear the grid before the import? (Ex: TRUE|FALSE)>';'<First row of the spreadsheet>';'<Last row of the spreadsheet>';'<Spreadsheet name>')
|
▪FIELD OPERATION WITH FILTER: Returns filter field operation.
Syntax:
|
FIELDOPERATIONFILTER('<table ID #>';'<field ID #>';'<operation>';'<filter>)
|
▪EDIT COMBOBOX FIELD: Edits the field of a combobox.
Syntax:
|
EDITCOMBOBOXFIELD('<ComboBox id #>';'<Table attribute ID #>')
|
▪GEOLOCATION: Returns the current longitude or latitude, with 1 to return the longitude and 2 to return the latitude.
Syntax:
|
GEOLOCATION('<1 or 2>';'<Field ID #>')
|
▪EXECUTE QUERY: Executes query and updates the fields with the execution result.
Syntax:
|
QUERYEXECUTE(<ID # of the previously created query: e.g.: userlist>;<Persist values: e.g.: FORMFIELD1=CODE, FORMFIELD2=NAME>)
|
▪OPEN ZOOM FROM QUERY: Opens a screen and displays the query execution result. A record can be selected to update the form fields.
Syntax:
|
QUERYZOOM(<ID # of the previously created query: e.g.: userlist>;<Persist values: e.g.: FORMFIELD1=CODE, FORMFIELD2=NAME>;<Columns: e.g.: CODE, NAME>)
|
▪OPEN ZOOM FROM QUERY TO UPDATE GRID: Opens a screen and displays the query execution result. Several records can be selected to be added to the form grid.
Syntax:
|
QUERYZOOMTOGRID(<ID # of the previously created query: e.g.: userlist>;<ID # of the grid relationship: e.g.: Rel01>;<From/To of zoom fields that will be added to the columns in the grid: e.g.: FORMFIELD1=CODE, FORMFIELD2=NAME>;<Clear the grid before the update? e.g.: TRUE | FALSE>;<Columns: e.g.: CODE, NAME>)
|
|
Functions that display messages on the form:
▪ALERT: Returns alert on the screen.
▪CONFIRM: Returns a dialog box.
Syntax:
|
CONFIRM('<parameter>')
|
|
Functions that make information conversions in the form:
▪TABLE FILTER: Returns a filter object
Syntax:
|
TABLEFILTER('<table ID #>';'<field ID #>';'<value>')
|
▪DATE TO NUMBER: Changes <Date> parameter to a number Timestamp Unix. If the <Date> has a format other than the system standard, the user can enter the format in <Format> parameter. By default, the user can enter ' ' (empty).
Syntax:
|
DATETONUMBER('<Date>';'<Format>')
|
▪NUMBERTODATE: Changes a <Number> Timestamp Unix to a date in <Format>, for instance, NUMBERTODATE(1411603200; 'dd/mm/yyyy'). <Format> parameter is optional, that is, it can be omitted ' ' (empty).
Syntax:
|
NUMBERTODATE('<Number>';'<Format>')
|
▪HOUR TO NUMBER: Changes <Time> parameter to number of seconds. If the <Hour> has a format other than the system standard, the user can enter the format in <Format> parameter. By default, the user can enter ' ' (empty).
Syntax:
|
HOURTONUMBER('<Hour>';'<Format>')
|
▪NUMBER TO HOUR: Changes a <Number> of seconds to an hour using the <Format>, for example, NUMBERTOHOUR(7200; 'HH:mm:ss'). <Format> parameter is optional, that is, it can be omitted ' ' (empty).
Syntax:
|
NUMBERTOHUR('<Number>';'<Format>')
|
▪TEXT TO NUMBER: Changes the <Text> parameter to a number.
Syntax:
|
TEXTTONUMBER('<Text>')
|
|
Process
Functions that return information about the process instance (workflow, incident, or problem):
▪PROCESS TITLE: Returns the process title.
▪SE SUITE ID #: Returns the process (Workflow, Incident, Problem) or project (SE Project) ID # to which the form has been associated.
▪PROCESS DESCRIPTION: Returns the process description.
Syntax:
|
PROCESSDESCRIPTION()
|
▪STATUS: Returns the process instance automation status. The <return> may be "ID #" or "Name".
Syntax:
|
STATUS('<return>')
|
▪PRIORITY: Returns priority. The <return> may be "Name", "Order" or "Value".
Syntax:
|
PRIORITY('<return>')
|
▪ACTIVITY: Returns the activity where the form is displayed. The <return> can be "ID #" or "Activity name".
Syntax:
|
ACTIVITY('<return>')
|
▪REQUESTER CHARACTER: Returns the requester information. For a client, it can be the company name, contact name or contact e-mail. For a user, it can be the login, user ID, user name, e-mail, department or position.
Syntax:
|
REQUESTERCHARACTER('<Character>';'<Return>')
|
▪DEFINE PROCESS ATTRIBUTE: Defines the value of a process attribute, if the attribute is multivalued, the values must be separated by "|". Example: value1|value2|value3.
Syntax:
|
DEFINEPROCESSATTRIBUTE(<attribute id#>; <attribute value>)
|
|
▪STARTER: Returns the user who is the starter of the process. The <return> can be the "login", the "registration" or "user name".
Syntax:
|
STARTER('<return>')
|
▪STARTER DEPARTMENT: Returns the ID # of the process starter department.
Syntax:
|
STARTERDEPARTMENT()
|
▪STARTER POSITION: Returns the position ID # of process starter.
Syntax:
|
STARTERPOSITION()
|
▪LOGGED USER: Returns the user who is logged in the system. The <return> can be "code", "login", "registration" or "user name".
Syntax:
|
LOGGEDUSER('<return>')
|
▪LOGGED USER ATTRIBUTE: Returns the value of an attribute associated with the user who is logged in the system.
Syntax:
|
LOGGEDUSERATTRIBUTE('return')
|
|
▪SAVE COMMENT: Saves the <comment> in the history of the instance of the workflow, incident or problem.
Syntax:
|
SAVECOMMENT('<comment>')
|
▪EXECUTE ACTIVITY ACTION: Executes the action with the same name and that is related to the activity that loaded the form.
Syntax:
|
EXECUTEACTIVITYACTION('<Action name>')
|
▪EDIT STATUS: Edits the instance status.
Syntax:
|
EDITSTATUS('<status id #>')
|
|
▪CHANGE PRIORITY: Set the <priority value> in the instance
Syntax:
|
CHANGEPRIORITY('<evaluation method>';'<priority identification>';'<priority value>')
|
▪CREATE CAUSE: Creates a cause in the problem instance.
Syntax:
|
CREATECAUSE('<cause id #>';'<cause name>';'<cause type>')
|
|
DATE/TIME
▪TODAY: Creates a date that represents today's date.
▪SERVER DATE: Returns the server date.
|
▪CURRENT TIME: Returns current time using 'HH:mm:ss' format.
▪SERVER TIME: Returns server time.
|
▪CALENDAR: Returns calendar ID #.
▪PROCESS CALENDAR: Returns the ID # of process calendar.
Syntax:
|
PROCESSCALENDARO()
|
▪WORKING DATE: Returns if the calendar considers the date as working date
Syntax:
|
WORKINGDATE('<date>';'<calendar code>')
|
|
▪DATE/TIME: Returns date/time using 'dd/mm/yyyy HH:mm:ss' format.
Syntax:
|
DATETIME('<date>';'<time>')
|
|
▪BEFORE: Compares two dates and returns TRUE if <Date 1> is before <Date 2>; otherwise, returns FALSE.
Syntax:
|
BEFORE('<Date 1>';'<Date 2>')
|
▪EQUAL DATE: Compares two dates and returns TRUE if <Date 1> is equal to <Date 2>, otherwise, returns FALSE.
Syntax:
|
EQUALDATE('<Date 1>';'<Date 2>')
|
▪AFTER: Compares two dates and returns TRUE if <Date 1>is after <Date 2>, otherwise, returns FALSE.
Syntax:
|
AFTER('<Date 1>';'<Date 2>')
|
▪DAYS BETWEEN: Returns the number of days between <Date 1> and <Date 2>.
Syntax:
|
DAYSBETWEEN('<Date 1>';'<Date 2>')
|
|
▪TIME BETWEEN: Returns the number of hours between <Time 1> and <Time 2>. Parameters between <Time 1> and <Time 2> should be in 'HH:mm:ss' format.
Syntax:
|
TIMEBETWEEN('<Time 1>';'<Time 2>')
|
▪BEFORE TIME: Compares two times and returns TRUE if <Time 1> is before <Time 2>, otherwise, returns FALSE. Parameters between <Time 1> and <Time 2> should be in 'HH:mm:ss' format.
Syntax:
|
BEFORE_TIME('<Time 1>';'<Time 2>')
|
▪AFTER TIME: Compares two times and returns TRUE if <Time 1> is after <Time 2>, otherwise, returns FALSE. Parameters between <Time 1> and <Time 2> should be in 'HH:mm:ss' format.
Syntax:
|
AFTER_TIME('<Time 1>';'<Time 2>')
|
▪EQUAL TIME: Compares two dates and returns TRUE if <Time 1> is equal to <Time 2>, otherwise, returns FALSE. Parameters between <Date 1> and <Date 2> should be in "HH:mm:ss" format.
Syntax:
|
EQUAL_DATETIME('<Time 1>';'<Time 2>')
|
|
▪BEFORE DATE/TIME: Compares two dates and returns TRUE if <Date 1> is before <Date 2>, otherwise, returns FALSE. <Date 1> and <Date 2> should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
BEFORE_DATETIME('<Date 1>';'<Date 2>')
|
▪AFTER DATE/TIME: Compares two dates and returns TRUE if <Date 1> is after <Date 2>, otherwise, returns FALSE. <Date 1> and <Date 2> should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
AFTER_DATETIME(<'Date 1>';'<Date 2>')
|
▪EQUAL DATE/TIME: Compares two dates and returns TRUE if <Date 1> is equal to <Date 2>, otherwise, returns FALSE. <Date 1> and <Date 2> should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
EQUAL_DATETIME('<Date 1>';'<Date 2>')
|
|
▪SEPARATE DATE FROM DATE/TIME: Returns date from date/time in "dd/mm/yyyy" format. The <date/time> parameter should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
DATETIME_DATE('<date/time>')
|
▪SEPARATE DATE FROM DATE/TIME: Returns time from the <date/time> in "HH:mm:ss" format. The <date/time> parameter should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
DATETIME_TIME('<date/time>')
|
|
▪YEAR: Extracts the year from the <Date>.
▪MONTH: Extracts the month from the <Date>.
▪DAY: Extracts the day from the <Date>.
▪WEEK DAY: Extracts the week day from the <Date>.
Syntax:
|
WEEKDAY('<Date>')
|
▪WEEK NUMBER: Extracts the week number (of the year) from the <Date>.
Syntax:
|
NUMWEEK('<Date>')
|
|
▪HOUR: Returns the number of hours.
▪MINUTE: Returns the minutes.
|
▪ADD NUMBER OF HOURS: Returns new date/time in "dd/mm/yyyy HH:mm:ss" format, after adding number of hours. The <date/time> parameter should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
ADDHOURS('<date/time>';'<number>';'<calendar>')
|
▪ADD HOURS: Returns new date/time in "dd/mm/yyyy HH:mm:ss" format, after adding hours. The <date/time> parameter should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
ADDHOURS('<date/time>';'<hours>';'<process calendar>')
|
▪ADD DAYS: Returns new date/time in "dd/mm/yyyy HH:mm:ss" format, after adding number of days. The <date/time> parameter should be in "dd/mm/yyyy HH:mm:ss" format.
Syntax:
|
ADDDAYS('<date/time>';'<days>';'<process calendar>')
|
|
|
