# Complex

- Package name: special

# Checklist lookup

Number of categories

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/27VYtwLPRaWWL4pO-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/27VYtwLPRaWWL4pO-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/IpsZVfxySh7UUpNG-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IpsZVfxySh7UUpNG-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/EWGOJeTbpBNuRA43-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/EWGOJeTbpBNuRA43-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 62
- SQL datatype: INT(11)
- Class name: FieldMultiSelect

# Signature

Digital signature or approval

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: \[Yes/no\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/x4T6mak2gEGI06YX-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/x4T6mak2gEGI06YX-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/Oof50C554uGnyQX3-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Oof50C554uGnyQX3-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/n7lvM2VMpbUZlE2l-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/n7lvM2VMpbUZlE2l-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 65
- SQL datatype: INT(11)
- Class name: FieldSignature

# Calc: Formula

Formula based on other fields

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/wMImTzYq1PdGt51W-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/wMImTzYq1PdGt51W-image.png)

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/J52Y5dH3Qrf48T3P-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/J52Y5dH3Qrf48T3P-image.png)

<span class="mw-headline">\[Description of configs\]</span>

### Complex formulas

Calculated formulas syntax follows is compliant with JavaScript syntax.

#### <span class="mw-headline" id="bkmrk-common-operators-1">Common operators</span>

- Add: +
- Subtract: -
- Division: /
- Multiply: \*
- Modulus: %
- Precedence: ( ... )

#### <span class="mw-headline" id="bkmrk-mathematical-functio-1">Mathematical functions</span>

- Absolute: abs
- Minimum: max
- Maximum: min
- Power: pow
- Square root: sqrt
- Logarithms: log log10 exp
- Rounding: ceil floor round

#### <span class="mw-headline" id="bkmrk-mathematical-constan-1">Mathematical constants</span>

- Pi: pi
- E: e

#### <span class="mw-headline" id="bkmrk-support-for-statemen-1">Support for statements</span>

This feature is enabled starting from version 2366.

##### <span class="mw-headline" id="bkmrk-if-statement-1">IF statement</span>

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 )
```

- Test 
    - First value or expression
    - Operator 
        - Equal: =
        - Unequal: !=
        - Greater: &gt; (&gt;=)
        - Lesser: &lt; (&lt;=)
    - Second value or expression
- Result 
    - TRUE value or expression
    - FALSE value or expression

##### <span class="mw-headline" id="bkmrk-examples-1">Examples</span>

Script code / specification

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

Expression to use in formula

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

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 81
- SQL datatype: DECIMAL(20,4)
- Class name: FieldCalcFormula

# Calc: Test value

Test of the value of another field

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/JSUct74xU9OTIifh-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/JSUct74xU9OTIifh-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 80
- SQL datatype: TINYINT(1)
- Class name: FieldCalcTest

# Calc: Concatenate

Making a text based on values from other fields.

The field supports a basic version of [Complex formulas](https://docs.tsnocode.com/books/field-type-reference/page/calc-formula "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:

- One level of math, eg. `[FIELDX] + [FIELDY] == [FIELDZ] + [FIELDQ]`
- Supported mathematics are: plus, minus, divide, multiply and modulus
- Supported number comparators are: equal (= or ==), unequal (!=), less than (&lt;), greater than (&gt;), less than or equal (&lt;=) and greater than or equal (&gt;=)
- Supported text comparators are: equal (= or ==) and unequal (!=)

Samples of basic formulas:

<table class="wikitable" id="bkmrk-expression-result-%28-" style="width: 100%;"><tbody><tr><th style="width: 54.4696%;">Expression</th><th style="width: 45.5304%;">Result</th></tr><tr><td style="width: 54.4696%;">`( [FIELDX] > [FIELDY] ? X ([FIELDX]) is greater : Y ([FIELDY]) is greater )`</td><td style="width: 45.5304%;">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

</td></tr><tr><td style="width: 54.4696%;">`( [RADIO] = Yes ? User accepted : User didn't accept )`</td><td style="width: 45.5304%;">Given that \[RADIO\] is a [FieldNumberBoolean](https://wiki.tsnocode.com/index.php?title=FieldNumberBoolean "FieldNumberBoolean") and the TRUE value has been set to "Yes", if the user selects it. The result would be: `User accepted`

</td></tr><tr><td style="width: 54.4696%;">```
(
    [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
    )
)
```

</td><td style="width: 45.5304%;">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.

</td></tr><tr><td style="width: 54.4696%;">`( [ACCEPT] != YES ? <a href=\"https://acme.com?( [X] > [Y] ? test1 : test2 )\">Link</a> : <a href=\"https://acme.net?( [X] < [Y] ? test1 : test2 )\">Link</a> )`</td><td style="width: 45.5304%;">This is just an example of nesting.</td></tr></tbody></table>

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/ujrRyEZvukn3yoGo-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ujrRyEZvukn3yoGo-image.png)

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/3v5TnIta4FBonRot-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/3v5TnIta4FBonRot-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 82
- SQL datatype: TEXT
- Class name: FieldCalcConcatenate

# Calc: JavaScript

Executing Javascripts client AND serverside

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

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

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

## <span class="mw-headline">Configuration</span>

This field requires configuration before deployment.

<span class="mw-headline">\[INSERT IMAGE\]</span>

Edit the values using "Manual edit" feature

Required:

- Functional JavaScript (Configuration1)

#### <span class="mw-headline" id="bkmrk-help-for-syntax-1">Help for syntax</span>

The API currently supports the following language features

- All standard functions from JavaScript 
    - Librarys like Math
- Support for basic TS form functions 
    - getValue( variable )
    - setValue( variable, valueToAssign )
- **Unsupported** features include 
    - JQuery commands (clientside only)
    - JavaScript IO functions like **alert** and **input**
    - JavaScript DOM objects like **window** and **document**

#### <span class="mw-headline" id="bkmrk-important-notice-1">Important notice</span>

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

<table id="bkmrk-field-client-side-ex"><tbody><tr><th>Field</th><th>Client side example</th><th>Server side format</th></tr><tr><td>Date</td><td>31/1/2014</td><td>2014-01-31</td></tr><tr><td>Decimal</td><td>1,23</td><td>1.234</td></tr></tbody></table>

Future versions will include these methods callable server and clientside

- getValueDate( fieldname )
- getValueDecimal( fieldname )
- getDateFromString( string )
- getDecimalFromString( string )

#### <span class="mw-headline" id="bkmrk-example-1">Example</span>

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

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 83
- SQL datatype: N/A
- Class name: FieldJavaScripting

# Calc: Time lifecycle

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

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/6asdz7mZ6oRnP2nf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6asdz7mZ6oRnP2nf-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 84
- SQL datatype: N/A
- Class name: FieldCalcAge

# Calc: Time measured

Total waiting time

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/EvM0WIvFJUmgMs2Q-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/EvM0WIvFJUmgMs2Q-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 85
- SQL datatype: N/A
- Class name: FieldCalcMeasure

# Calc: Score interval

Translation of values in intervals

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/N7FC90dZKqbPehpA-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/N7FC90dZKqbPehpA-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 88
- SQL datatype: DECIMAL(20,4)
- Class name: FieldCalcScore

# Calc: Check fields

Check if a list of fields has been filled out

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

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

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/5oDvv1nmDPCeDnSv-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/5oDvv1nmDPCeDnSv-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 89
- SQL datatype: TINYINT(1)
- Class name: FieldCalcTestMany

# Comments

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

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/MIa6okOaqF0I80VZ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/MIa6okOaqF0I80VZ-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/j4H5uBtzmkiyrbe0-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/j4H5uBtzmkiyrbe0-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 140
- SQL datatype: INT(11)
- Class name: FieldComplexComment

# Related form multiselect

Filter with single parameters including standard security.

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/a6GGbVHFXhGuLr5A-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/a6GGbVHFXhGuLr5A-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/nn1XB79gNFsDYQPV-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/nn1XB79gNFsDYQPV-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/dQjo0umikza1td3G-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dQjo0umikza1td3G-image.png)

<span class="mw-headline">\[Description of configs\]</span>

### <span class="mw-headline" id="bkmrk-special-features-1">Special features</span>

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

- The function returns a comma seperated list of *display* values.
- The function is only referable clientside.

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

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

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 230
- SQL datatype: INT(11)
- Class name: FieldMultiSelectSubform

# Related form multiselect SQL

Freeform definition with multiple parameters with optional security.

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/DVS8SxNXEeEf9qGI-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/DVS8SxNXEeEf9qGI-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/IJr8OPMawn2xXfRK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IJr8OPMawn2xXfRK-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/todKdAwT3gjn30Z6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/todKdAwT3gjn30Z6-image.png)

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 231
- SQL datatype: INT(11)
- Class name: FieldMultiSelectSubformSQL

# XML data

XML data in lists, table or own output format

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No
- Requires configuration: Yes

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/FFVu5n3k42ZBhESf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/FFVu5n3k42ZBhESf-image.png)

<span class="mw-headline">Field in edit mode</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/7V5Oyy4dn5IvfObf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/7V5Oyy4dn5IvfObf-image.png)

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/l8uATPBj49uw3lPt-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/l8uATPBj49uw3lPt-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 400
- SQL datatype: LONGTEXT
- Class name: FieldXmlData

# Barcode (status change)

Barcode to change status automatically

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/L3WxxTb0r4FFsu1g-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/L3WxxTb0r4FFsu1g-image.png)

<span class="mw-headline">\[Description of configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 651
- SQL datatype: N/A
- Class name: FieldBarcodeAutomation

# SQL: Table query

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 520
- SQL datatype: N/A
- Class name: FieldSqlData

# Calc: Flag

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 180
- SQL datatype: TINYINT(1)
- Class name: FieldCalcTestFlag

# 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

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: No
- Show in lists: No
- Searchable: No

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

This field requires configuration of both parameters before it shows.

### <span class="mw-headline" id="bkmrk-config1-1">Config1</span>

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.

### <span class="mw-headline" id="bkmrk-config2-1">Config2</span>

The Label of the input column in the table.

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 232
- SQL datatype: INT(11)
- Class name: FieldMultiInputSubformListSQL

# Token display

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 760
- SQL datatype: N/A
- Class name: FieldTokenShow

# Calc: Document section

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 2085
- SQL datatype: N/A
- Class name: FieldCalcDocumentSection

# Geomap Coding

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 2201
- SQL datatype: VARCHAR(80)
- Class name: FieldGeoAddressCoding

# Geomap

\[DESCRIPTION\]

### Properties

- Type: [Complex](https://docs.tsnocode.com/books/field-type-reference/chapter/complex)
- Groupable: \[YES/NO\]
- Show in lists: \[YES/NO\]
- Searchable: \[YES/NO\]

## <span class="mw-headline" id="bkmrk-user-interface-1">User interface</span>

<span class="mw-headline">Field in show mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">Field in edit mode</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

## <span class="mw-headline" id="bkmrk-configuration-1">Configuration</span>

<span class="mw-headline">\[INSERT IMAGE\]</span>

<span class="mw-headline">\[Eventuel beskrivelse af configs\]</span>

## <span class="mw-headline" id="bkmrk-developer-info-1">Developer info</span>

- FeltTypeID: 2200
- SQL datatype: DECIMAL(10,6)
- Class name: FieldGeoLocation