Complex

Checklist lookup

Number of categories

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

[Description of configs]

Developer info

Signature

Digital signature or approval

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

[Description of configs]

Developer info

Calc: Formula

Formula based on other fields

Properties

User interface

Field in show mode

image.png

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Complex formulas

Calculated formulas syntax follows is compliant with JavaScript syntax.

Common operators

Mathematical functions

Mathematical constants

Support for statements

This feature is enabled starting from version 2366.

IF statement

Syntax used matches JavaScript inline IF statements.

To make the statement work make sure to add a space: before ), after (, before and after ? and :.

( Value1 Operator Value2 ? ValueIfTrue : ValueIfFalse )
Examples

Script code / specification

 var result;
 if ( [NUMBER1] >  [NUMBER2] ) {
       result = [NUMBER1] * 11;
 }
 else {
       result = [NUMBER3];
 }
 return result;

Expression to use in formula

( [NUMBER1] >  [NUMBER2] ? [NUMBER1] * 11 : [NUMBER3] )

Developer info

Calc: Test value

Test of the value of another field

Properties

User interface

Field in show mode

[INSERT IMAGE]

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Calc: Concatenate

Making a text based on values from other fields.

The field supports a basic version of Complex formulas as of version 6144, the last and innermost formula i calculated first. The separators ? and : has to have a space on both sides!

Supported comparisons and mathematics:

Samples of basic formulas:

Expression Result
( [FIELDX] > [FIELDY] ? X ([FIELDX]) is greater : Y ([FIELDY]) is greater ) Given that the value of both fields are numbers (int or float), and FIELDX has a greater value.

The result would be: X ([FIELDX]) is greater, where [FIELDX] would be replaced with the value of the field
( [RADIO] = Yes ? User accepted : User didn't accept ) Given that [RADIO] is a FieldNumberBoolean and the TRUE value has been set to "Yes", if the user selects it.

The result would be: User accepted

 
(
    [PROVIDER] = IMDB
    ? <a href="https://www.imdb.com/title/[ID]/">Link to IMDB<a/>
    : (
        [PROVIDER] = TheMovieDB
        ? <a href="https://www.themoviedb.org/movie/[ID]">Link to TheMovieDB<a/>
        : Unknown provider
    )
)
 This is an example of two nested formulas, enabling comparison of an element against multiple values.

Given that [PROVIDER] is a string value (text, dropdown, etc), [ID] could be anything.

If provider equals "IMDB" a link to IMDB would show up, and the ID would be input.

If provider equals "TheMovieDB" a link to TheMovieDB would show up, and the ID would be input.
( [ACCEPT] != YES ? <a href=\"https://acme.com?( [X] > [Y] ? test1 : test2 )\">Link</a> : <a href=\"https://acme.net?( [X] < [Y] ? test1 : test2 )\">Link</a> ) This is just an example of nesting.

Properties

User interface

Field in show mode

image.png

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Calc: JavaScript

Executing Javascripts client AND serverside

NOTE: This feature is currently BETA, and features are subject to change.

Properties

User interface

Due to its nature this field has no special show or edit mode.

Configuration

This field requires configuration before deployment.

[INSERT IMAGE]

Edit the values using "Manual edit" feature

Required:

Help for syntax

The API currently supports the following language features

Important notice

Some field values are represented differently server and client side, namely date and decimal values

Field Client side example Server side format
Date 31/1/2014 2014-01-31
Decimal 1,23 1.234

Future versions will include these methods callable server and clientside

Example

if( getValue('NUMBER2') > 1000 )
    setValue('NUMBER1',  Math.round( 100 * Math.random() ) );

Developer info

Calc: Time lifecycle

Time spent since the beginning of the case or since last correction

Properties

User interface

Field in show mode

[INSERT IMAGE]

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Calc: Time measured

Total waiting time

Properties

User interface

Field in show mode

[INSERT IMAGE]

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Calc: Score interval

Translation of values in intervals

Properties

User interface

Field in show mode

[INSERT IMAGE]

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Calc: Check fields

Check if a list of fields has been filled out

Properties

User interface

Field in show mode

[INSERT IMAGE]

Due to its nature this field has no special editing mode.

Configuration

image.png

[Description of configs]

Developer info

Comments

Entry of a list of comments from the users of the case

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

[INSERT IMAGE]

[Description of configs]

Developer info

Related form multiselect

Filter with single parameters including standard security.

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

[Description of configs]

Special features

There is automatically added a special JS function named: getValueDisplay + [FieldSystemName]

Example for displaying the values selected in the field "My statements" (System name ="STATEMENTS"):

alert('You have selected the following values ' + getValueDisplaySTATEMENTS());

Developer info

Related form multiselect SQL

Freeform definition with multiple parameters with optional security.

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

[Eventuel beskrivelse af configs]

Developer info

XML data

XML data in lists, table or own output format

Properties

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

[Description of configs]

Developer info

Barcode (status change)

Barcode to change status automatically

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

image.png

[Description of configs]

Developer info

SQL: Table query

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info

Calc: Flag

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info

Related entity multiline decimal

A table of lines from another table, maybe with a filter that relates them to this items DataID, and the option to input a decimal number next to each of them.

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

This field requires configuration of both parameters before it shows.

Config1

The SQL-query executed, to list the items in the table.
The first column should be *DataID* of the subitem, but it doesn't have to be. As long as *a* column includes this data.
To relate the subtable to the current item, ad a *where clause* comparing to *[DataID]*, where *[DataID]* will be replaced be the current records DataID.

Config2

The Label of the input column in the table.

Developer info

Token display

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info

Calc: Document section

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info

Geomap Coding

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info

Geomap

[DESCRIPTION]

Properties

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

[Eventuel beskrivelse af configs]

Developer info