# Field type reference

Documentation for all data model building blocks (content types)

# Basic

Basic fields that just store some information or do not require much, if any, configuration.

- Package name: basic

# Integer

Capable of containing whole numbers (no decimals).  
Due to technical limitations the number can't be smaller than -2.147.483.648 or larger than 2.147.483.647.

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-03/scaled-1680-/NQODU7rl8JLsNKf4-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/NQODU7rl8JLsNKf4-image.png)

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

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

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

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

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

- FeltTypeID: 10
- SQL datatype: INT(11)
- Class name: FieldNumberInteger

# Decimal

Numbers with decimal comma

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-03/scaled-1680-/hNWCIDkesTPSGMIZ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/hNWCIDkesTPSGMIZ-image.png)

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

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

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

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

\[Mangler forklaring af "Use category styling" samt link til side om hvad category betyder i platformen\]

Default precision is 2, if nothing else is set.

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

- FeltTypeID: 11
- SQL datatype: DECIMAL(20,6)
- Class name: FieldNumberDecimal

# Percentage

This field is used to show a bar in list views as seen below. It should only be used with whole percentages between 0 and 100. When using this field with formulas the value is not automatically divided by 100, which means that a value of 5% is interpreted as "5".

Note that the policy "showPercentageAsBar" must be true for the field to be rendered as a bar. [See Rendering policies](https://docs.tsnocode.com/books/policy-reference/page/rendering)

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-03/scaled-1680-/sRRKrusRofXBFgQu-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/sRRKrusRofXBFgQu-image.png)

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

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

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

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

## <span class="mw-headline" id="bkmrk--4"></span>

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

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

Decimal/ precision does not work on this field

Defining a unit name replaces the default unit of "%".

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

- FeltTypeID: 12
- SQL datatype: DECIMAL(10,4)
- Class name: FieldNumberDecimalPercent

# Yes/No

Check box. Yes/No. The values can be shown with other words or icons

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-03/scaled-1680-/aSAmft6lUHKLv0gw-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/aSAmft6lUHKLv0gw-image.png)

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

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

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

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

As of version 9943 adding a `TRUE value text`, when displaying the field as a checkbox, the value will be used as a label for the checkbox.

\[Description of configs\]

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

- FeltTypeID: 13
- SQL datatype: TINYINT(1)
- Class name: FieldNumberBoolean

# Serial

Unique serial number

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/CVmLHBTY0EoxIDA6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/CVmLHBTY0EoxIDA6-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/12nAaghDkKsPL7XJ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/12nAaghDkKsPL7XJ-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-/6HXpBKQOOV5xsJjw-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6HXpBKQOOV5xsJjw-image.png)

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

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

- FeltTypeID: 16
- SQL datatype: INT(11)
- Class name: FieldSerial

# Response

Interval in questionnaire

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- 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-/Rn0kh04Ag3L3Np5E-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Rn0kh04Ag3L3Np5E-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/fUo4ztYv5AEyYVXs-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/fUo4ztYv5AEyYVXs-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-/pBvjStJoPDdZGR1o-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/pBvjStJoPDdZGR1o-image.png)

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

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

- FeltTypeID: 17
- SQL datatype: INT(11)
- Class name: FieldNumberIntegerResponse

# Enumeration

Named numbers ex. Grades

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- 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>

<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-/ugZPw0fBgoBWDVar-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ugZPw0fBgoBWDVar-image.png)

Required:

- Values must be integers
- There should be one name for each value

Options:

- Options van be colored using the # syntax

```
 Option 1 #red
 Option 2 #blue
 ...
```

- Translations should be prefixed only once with the language qualifier

```
 en:Option 1
 Option 2
 Option 3
 ge:Wahl 1
 Wahl 2
 Wahl 3
```

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

- FeltTypeID: 18
- SQL datatype: INT(11)
- Class name: FieldNumberIntegerEnumeration

# Symbol

Use icons as status flow and categories

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: Yes
- 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-/l9m2kUH5zYlK0bHE-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/l9m2kUH5zYlK0bHE-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/ufRTbv8uelKAsD7P-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ufRTbv8uelKAsD7P-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-/SRpt5cJ9zAHibrLK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/SRpt5cJ9zAHibrLK-image.png)

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

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

- FeltTypeID: 19
- SQL datatype: INT(11)
- Class name: FieldNumberIntegerGlyph

# Date

Date with calendar look-up

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/1jdEkyM7GGdhyEvl-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/1jdEkyM7GGdhyEvl-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/vnR1fYl8EbElu2gt-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vnR1fYl8EbElu2gt-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-/D8ambXALl4Qvt3vD-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/D8ambXALl4Qvt3vD-image.png)

### <span class="mw-headline" id="bkmrk-show-mode-1">Show mode</span>

The date will be formatted as defined in format option.  
Default formatting is: dd/mm/yyyy

### <span class="mw-headline" id="bkmrk-edit-mode-1">Edit mode</span>

The date field will display a textbox. On activating the field a date selector will popup below the field.  
Normal input format is: dd/mm/yyyy

The values for dd and mm can be either 1 or two digits - examples

- 1/12/2013 or 01/12/2013
- 31/1/2013 or 31/01/2013

The separator method is also free: "/" or "-" will do

#### Relative date

The date output can be changed to output the number of dates between the stored date and "now".  
To do this input two colors, separated by a space, in the formatting config.  
eg. `red green`.  
This will change the list-output of the field to be a number of days.  
If the number is negative, the date is in the past, if it is positive the date is in the future.  
The two colors chosen will be be added as text-colors.

### <span class="mw-headline" id="bkmrk-other-options-1">Other options</span>

The date field can be set to strict or loose date parsing:

- Strict: Only the correct date format supplied by the date selector dd/mm/yyyy
- Loose: Interpretation of all values 
    - 31/12 &gt; 31/12/\[this year\]
    - 311213 &gt; 31/12/2013
    - 30 &gt; \[30 days from now\]
    - -7 &gt; \[7 days ago from now\]

The loose option is activated by setting the configuration (policy): **doSmartDateInput**

#### **Styling relative dates**

As of version 11476.  
The relative date output has the class `relativeDate` and depending on wether the date is before or after now, it has the class `before` or `after`.  
To spice up the style of this output, you can add this snippit to your stylesheet.

```css
.relativeDate.after {
    color: #096f58 !important;
    background: #7efbb7;
    padding: 0px 5px;
    border-radius: 3px;
}

.relativeDate.before {
    color: #a7175f !important;
    background: #ffc9d3;
    padding: 0px 5px;
    border-radius: 3px;
}
```

To limit the styling to a singe entity, add the style in the `headers and scripts` for that entity.

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

- FeltTypeID: 20
- SQL datatype: DATE
- Class name: FieldTimeDate

# Time

Selector for point in time

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/dEEvYuFVD05anwFI-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dEEvYuFVD05anwFI-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/c5vX1kt8n4WAqpDO-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/c5vX1kt8n4WAqpDO-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-/IC4uwvwYPgZnbO6C-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IC4uwvwYPgZnbO6C-image.png)

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

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

- FeltTypeID: 21
- SQL datatype: TIME
- Class name: FieldTimeTime

# Datetime

Date with calendar/time look-up

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/vspeY42UVQO9BBJX-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vspeY42UVQO9BBJX-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/V8EFqnLe4dWoSdrV-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/V8EFqnLe4dWoSdrV-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-/dUDZ5H9m98zuLysL-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dUDZ5H9m98zuLysL-image.png)

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

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

- FeltTypeID: 22
- SQL datatype: DATETIME
- Class name: FieldTimeDatetime

# Month

Choice of month, including translation

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/92qsokEtJbV2rE2A-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/92qsokEtJbV2rE2A-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 24
- SQL datatype: INT(11)
- Class name: FieldTimePartMonth

# Year

Choice of year

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/bg1p9Dwq1bq0Cb5H-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/bg1p9Dwq1bq0Cb5H-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 25
- SQL datatype: INT(11)
- Class name: FieldTimePartYear

# Text

A single line of a text (ex. Name).  
The text can't be longer than 255 characters.

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/Qww3whsWVyGc4dR5-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Qww3whsWVyGc4dR5-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/8nvrom5iHH3lvbO6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/8nvrom5iHH3lvbO6-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-/ehfPKDfb33P4XBB1-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ehfPKDfb33P4XBB1-image.png)

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

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

- FeltTypeID: 30
- SQL datatype: VARCHAR(255)
- Class name: FieldText

# Text multiline

Multiple lines of text (ex. Adresses)

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/6bigesKLgqDVWoDb-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6bigesKLgqDVWoDb-image.png)

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

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

- FeltTypeID: 31
- SQL datatype: TEXT
- Class name: FieldTextMemo

# Notepad

WYSIWYG Editor shown in the interface

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic "Basic")
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/mkUX6tVIWQ0qnlcw-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/mkUX6tVIWQ0qnlcw-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/6F5c7y2Gz9QclIq7-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6F5c7y2Gz9QclIq7-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-/zDs4k2mugF8ENKch-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/zDs4k2mugF8ENKch-image.png)

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

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

- FeltTypeID: 32
- SQL datatype: TEXT
- Class name: FieldTextMemoEditor

# Hierachy/tree

Hierarchy of values

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- 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-/IRMNHczHfhk6eahs-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IRMNHczHfhk6eahs-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/FxPBTwsJN3t34xrJ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/FxPBTwsJN3t34xrJ-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-/xfBI55gdg4aAEYRb-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/xfBI55gdg4aAEYRb-image.png)

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

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

- FeltTypeID: 33
- SQL datatype: VARCHAR(255)
- Class name: FieldTextHieraki

# Email

User email-adress

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/yExz80cfXfFwFKOn-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/yExz80cfXfFwFKOn-image.png)

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

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

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

No configuration required for this field type

To make the field enforce that the input is an actual email, add the following regex as validation.

```regex
^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$
```

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

- FeltTypeID: 34
- SQL datatype: VARCHAR(80)
- Class name: FieldTextEmail

# Website (URL)

Stores an internet address.

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/iPzQI48fCU5RF9ug-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/iPzQI48fCU5RF9ug-image.png)

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

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

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

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

One configuration is available.  
If Configuration1 is equal to "1", then the value will be displayed as a link in lists. The link will open in a new tab.

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

- FeltTypeID: 35
- SQL datatype: TEXT
- Class name: FieldTextURL

# Unique key (GUID)

Global Unique ID (GUID) for records, inserted automatically on record creation.

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

## <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: 37
- SQL datatype: VARCHAR(80)
- Class name: FieldUniqueIdentity

# Text with lookup

A single line text with look-up in exciting values

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/Akg4UHzbnzd1vLbT-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Akg4UHzbnzd1vLbT-image.png)

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

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

- FeltTypeID: 38
- SQL datatype: VARCHAR(80)
- Class name: FieldTextSuggest

# Phone

Phone number with the possibility for look-up

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/5SoKNA8p54JhKpzj-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/5SoKNA8p54JhKpzj-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/hAP8Ssptam4pSIwh-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/hAP8Ssptam4pSIwh-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-/ihYWolnBdNUc2cT0-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ihYWolnBdNUc2cT0-image.png)

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

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

- FeltTypeID: 40
- SQL datatype: VARCHAR(80)
- Class name: FieldTextPhone

# CPR nummer

Validation of control digits with the personal identification number

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/hRDtb8HoTK5bmGHV-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/hRDtb8HoTK5bmGHV-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/LogSHDhnYcKRBCOi-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/LogSHDhnYcKRBCOi-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-/QkGR5SxrgSWlAOXf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/QkGR5SxrgSWlAOXf-image.png)

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

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

- FeltTypeID: 41
- SQL datatype: VARCHAR(12)
- Class name: FieldTextCPR

# CVR nummer

CVR number with look-up in the CVR register

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/VKeoILgOxp4IMYIn-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/VKeoILgOxp4IMYIn-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 42
- SQL datatype: VARCHAR(10)
- Class name: FieldTextCVR

# Static content

A static message/information, that supports translation.

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- 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>

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-/S8rM9Xg9UcWILkGK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/S8rM9Xg9UcWILkGK-image.png)

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

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

- FeltTypeID: 600
- SQL datatype: Special
- Class name: FieldContentStatic

# Static button

Button with functionality

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- Groupable: No
- Show in lists: Yes
- 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>

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-/tNtBK38f4F2uvU2H-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/tNtBK38f4F2uvU2H-image.png)

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

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

- FeltTypeID: 601
- SQL datatype: N/A
- Class name: FieldContentButton

# Static message

Notification on top of the page

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- 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-/6mfK6NxEyZelneg1-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6mfK6NxEyZelneg1-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-/FJ3M4WDuiIDnuHAf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/FJ3M4WDuiIDnuHAf-image.png)

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

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

- FeltTypeID: 602
- SQL datatype: N/A
- Class name: FieldContentMessage

# Static script

Execution of the code when changing other boxes

### Properties

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

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

This field is not displayed as a normal field.

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-/XieKaFzJbYbMqHHd-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/XieKaFzJbYbMqHHd-image.png)

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

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

- FeltTypeID: 603
- SQL datatype: N/A
- Class name: FieldContentScript

# Script function

Execution of javascript with value insertion into other fields

### Properties

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

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

This field is not displayed as a normal field, nor is the value of it saved and available to codeunits/sql-statements.

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

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

<span class="mw-headline">Is a list of fields, which values will be available as variables in the following function.  
If a name contains "!", it will be loaded as a decimal.  
So this configuration:</span>

```
FIELD1 FIELD2! !FIELD3
```

<span class="mw-headline">Results is this code:</span>

```javascript
let FIELD1 = getValue("FIELD1")
let FIELD2 = getDecimal("FIELD2")
let FIELD3 = getDecimal("FIELD3")
```

<span class="mw-headline">Plus all those fields will trigger a re-evaluation of this field, whenever they are updates/changed.</span>

### <span class="mw-headline">Code (Function)</span>

<span class="mw-headline">The actual javascript that modifies the data collected from the inputs.  
Is pasted into a function, so should only contain lines of code.  
Must have a return statement!  
</span><span class="mw-headline">Sample:</span>

```javascript
return FIELD2 * FIELD3;
```

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

<span class="mw-headline">The field to set the value of, with the return value of the final function.  
The output of the function will also be the value of this field, but will not be saved, as this field is virtual and only works in the frontend.</span>

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

- FeltTypeID: 620
- SQL datatype: N/A
- Class name: FieldContentFunction

# Priority

\[DESCRIPTION\]

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- 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: 752
- SQL datatype: INT(11)
- Class name: FieldNumberIntegerPriority

# Currency

UNDER DEVELOPMENT

\[DESCRIPTION\]

### Properties

- Type: [Basic](https://docs.tsnocode.com/books/field-type-reference/chapter/basic)
- 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: 14
- SQL datatype: DECIMAL(20,2)
- Class name: FieldNumberDecimalCurrency

# Lookup

- Package name: lookup

# Lookup

Look-up in local list of values

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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-/2dxln0HqZYHVffKM-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/2dxln0HqZYHVffKM-image.png)

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

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

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

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

- FeltTypeID: 61
- SQL datatype: INT(11)
- Class name: FieldLookupListLocal

# Lookup (shared)

Look-up in common list of values

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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-/7xzSql6F7HycJxc8-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/7xzSql6F7HycJxc8-image.png)

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

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

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

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

- FeltTypeID: 60
- SQL datatype: INT(11)
- Class name: FieldLookupListShare

# User

Users of the system. Those who are being added, can as an option be notified

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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-/BKvM6Do7dlfvV7An-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/BKvM6Do7dlfvV7An-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/ofE4iiJ6S0kKR77V-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ofE4iiJ6S0kKR77V-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-/b3ITm98OdcZtXNL5-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/b3ITm98OdcZtXNL5-image.png)

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

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

- FeltTypeID: 63
- SQL datatype: INT(11)
- Class name: FieldLookupUser

# User Exclusive

User from a certain Exclusive group (the one set on the record)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup "Lookup")
- 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-/JGhImXnsXXIaXKz2-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/JGhImXnsXXIaXKz2-image.png)

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

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

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

No configuration required for this field type

To set the current user as the default value, manually edit the field and input `USER` as the default value.

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

- FeltTypeID: 163
- SQL datatype: INT(11)
- Class name: FieldLookupUserExclusive

# Group

Groups in the system. Those who are being added, can as an option be notified

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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-/oDHUIIzqjt5G1iF5-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/oDHUIIzqjt5G1iF5-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/LvrUzcKpmVk3wf83-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/LvrUzcKpmVk3wf83-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-/6LBgXED0QbNXHbdE-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/6LBgXED0QbNXHbdE-image.png)

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

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

- FeltTypeID: 64
- SQL datatype: INT(11)
- Class name: FieldLookupGroup

# Dependent list (lokal)

Choice based on another local list

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/9xMuF2MQQyQgdt2q-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/9xMuF2MQQyQgdt2q-image.png)

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

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

- FeltTypeID: 71
- SQL datatype: INT(11)
- Class name: FieldLookupListLocalNested

# Dependent category

Categories based on value

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/dZCUxP435vpLrZMH-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dZCUxP435vpLrZMH-image.png)

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

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

- FeltTypeID: 72
- SQL datatype: INT(11)
- Class name: FieldCategory

# List replica

Copy of another list (same options)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup "Lookup")
- 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>

<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-/KVlkNJ6XgkSCqza3-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/KVlkNJ6XgkSCqza3-image.png)

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

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

- FeltTypeID: 73
- SQL datatype: INT(11)
- Class name: FieldLookupListLocalReplika

# Lookup: Currency code

List of currency codes

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

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

No configuration required for this field type

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

- FeltTypeID: 95
- SQL datatype: VARCHAR(3)
- Class name: FieldLookupStaticCurrency

# Variant selector

List of types, which are controlling which other boxes are being showed

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- Groupable: Yes
- Show in lists: Yes
- 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-/D0XVzikrBD1wVBAK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/D0XVzikrBD1wVBAK-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/dBShQg4Jy3xXb5Lq-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dBShQg4Jy3xXb5Lq-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-/1lEpxq5EFsx0lLFm-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/1lEpxq5EFsx0lLFm-image.png)

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

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

- FeltTypeID: 300
- SQL datatype: INT(11)
- Class name: FieldVariant

# Database: Opslag indtastning

Look-up of values in foreign database

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/Q2yeEBWK1kQCTmp5-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Q2yeEBWK1kQCTmp5-image.png)

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

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

- FeltTypeID: 500
- SQL datatype: VARCHAR(20)
- Class name: FieldRemoteKey

# Database: Opslag liste valg

Table of values from foreign database

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/dogHPkk9RLbstlAT-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/dogHPkk9RLbstlAT-image.png)

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

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

- FeltTypeID: 501
- SQL datatype: VARCHAR(20)
- Class name: FieldRemoteKeyLookup

# SQL: Subselect

Enquiry in own or foreign database

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/CBG0fsrUWglbpVtj-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/CBG0fsrUWglbpVtj-image.png)

Required:

- SELECT query that returns a single record with a single value in the recordset

Options:

- Restrictions (when to display the value): 
    - Always: Single, list and subitem mode
    - Items: Single mode only (hidden in list mode)
    - Lists: List mode only (hidden in single mode)
    - Subitem: Lists displayed in single items (child records)

Notes for usage:

- Values are not cached or stored
- Consider activating INDEX for fields used in WHERE or JOIN clauses

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

#### <span class="mw-headline" id="bkmrk-solution-setup-1">Solution setup</span>

```
Solution "Child items" (system name: "testchild")
* Relation field "owner" (system name: "PARENT").

Solution: "Parent items" (system name: "testparent")
* Date field "starting date" (system name: "DATO")
```

#### <span class="mw-headline" id="bkmrk-business-requirement-1">Business requirement</span>

Display the starting date (system name: "DATO") from the related parent table, linked by the local field owner (system name: "PARENT").

#### <span class="mw-headline" id="bkmrk-subselect-sql-statem-1">Subselect SQL statement</span>

```mysql
SELECT DATO 
FROM data_testparent 
WHERE :PARENT = data_testparent.DataID
```

this is the shorthand version for

```mysql
...
WHERE data_testchild.PARENT = data_testparent.DataID
```

### <span class="mw-headline" id="bkmrk-configuration-exampl-3">Configuration example 2</span>

#### <span class="mw-headline" id="bkmrk-solution-setup-3">Solution setup</span>

```
Solution "Example" (system name: "example")
* Status log activated
```

#### <span class="mw-headline" id="bkmrk-business-requirement-3">Business requirement</span>

Display the number of state changes for a data item

#### <span class="mw-headline" id="bkmrk-subselect-sql-statem-3">Subselect SQL statement</span>

```mysql
SELECT CONCAT( COUNT(*), ' transitions') 
FROM data_example_statuslog 
WHERE data_example_statuslog.DataID = :DataID
```

this is the shorthand version for

```mysql
...
WHERE data_example_statuslog.DataID = data_example.DataID
```

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

- FeltTypeID: 510
- SQL datatype: N/A
- Class name: FieldSubselect

# Lookup: Data item

Create reference to another record. This works the same as the field "Parent reference", but creates a drop-down list of options instead of using auto-complete. Useful for when there isn't a vast amount of records to select from. This field must be used for [Lookup: Data item nested](https://docs.tsnocode.com/books/field-type-reference/page/lookup-data-item-nested) to work.

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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">This field requires configuration before deployment.</span>

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

<span class="mw-headline">Parent solution: Choose which entity the parent record will be chosen from.</span>

<span class="mw-headline">Status filter: Optionally, you can specify a StatusID of a single status in the parent entity that all the record options should have.</span>

<span class="mw-headline">Apply security: If this is not checked, then records will show up in the dropdown even if the user does not have permission to read them.</span>

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

- FeltTypeID: 561
- SQL datatype: INT(11)
- Class name: FieldLookupListRecordKey

# Lookup: Data item nested

Used when you want to limit the options from a regular "Lookup: Data item" field to only the ones that share a parent with this entity.

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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">This field requires configuration before deployment.</span>

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

<span class="mw-headline">Dependent Field: The field in this entity that references the shared parent.</span>

<span class="mw-headline">Parent Solution: The lookup options entity.</span>

<span class="mw-headline">Parent dependency field: The field in the lookup options entity that references the shared parent.</span>

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

- FeltTypeID: 571
- SQL datatype: INT(11)
- Class name: FieldLookupListRecordKeyNested

# Value copy

Showing other values based on a key

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/FelWV7oEJ0nHqncA-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/FelWV7oEJ0nHqncA-image.png)

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

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

- FeltTypeID: 610
- SQL datatype: N/A
- Class name: FieldReplicate

# Value copy (text)

Coping TEXT value based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/mnt1KXOhiYb3RuPg-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/mnt1KXOhiYb3RuPg-image.png)

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

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

- FeltTypeID: 611
- SQL datatype: N/A
- Class name: FieldReplicateText

# Value copy (Integer)

Coping DECIMAL value based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/7l4NaGoy11yRkMVZ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/7l4NaGoy11yRkMVZ-image.png)

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

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

- FeltTypeID: 612
- SQL datatype: INT(11)
- Class name: FieldReplicateInteger

# Value copy (decimal)

Coping DECIMAL value based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/kWK2M33DJd2WdObk-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/kWK2M33DJd2WdObk-image.png)

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

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

- FeltTypeID: 613
- SQL datatype: DECIMAL(20,4)
- Class name: FieldReplicateDecimal

# Value copy (yes/no)

Coping Yes/No values based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/gbEo6g2BndSJasXN-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/gbEo6g2BndSJasXN-image.png)

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

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

- FeltTypeID: 614
- SQL datatype: TINYINT(1)
- Class name: FieldReplicateBoolean

# Value copy (date)

Coping DATE values based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/lExzT9sulcZoTdtO-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/lExzT9sulcZoTdtO-image.png)

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

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

- FeltTypeID: 615
- SQL datatype: DATE
- Class name: FieldReplicateDate

# Value copy (cpr)

Coping CPR number based on key (searchable)

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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>

<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-/50Jjhi4adAdZDRnN-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/50Jjhi4adAdZDRnN-image.png)

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

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

- FeltTypeID: 616
- SQL datatype: VARCHAR(20)
- Class name: FieldReplicateCPR

# Dependent list replica

Copy field lookup options from another field in this solution

### Properties

- Type: [Lookup](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup)
- 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: 74
- SQL datatype: INT(11)
- Class name: FieldLookupListLocalNestedReplika

# Lookup AJAX

- Package name: ajax

# Lookup: Postnr / by

Autofilling of danish postal number and city

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/Y086qeMxPsnF4D0s-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Y086qeMxPsnF4D0s-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 90
- SQL datatype: INT(11)
- Class name: FieldAjaxPostalcode

# Lookup: UNSPSC

Autofilling of the product category system of UN

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/DcwuiPMFPXzZBuVB-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/DcwuiPMFPXzZBuVB-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 91
- SQL datatype: INT(11)
- Class name: FieldAjaxUNSPSC

# Lookup: NACE code

Autofilling of NACE business codes

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/PFfoORxUIJ0mfmmR-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/PFfoORxUIJ0mfmmR-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 92
- SQL datatype: INT(11)
- Class name: FieldAjaxNACE

# Lookup: Country

Autofilling of country

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/rpxNj2TqbyT0xsQM-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/rpxNj2TqbyT0xsQM-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 93
- SQL datatype: INT(11)
- Class name: FieldAjaxCountry

# Lookup: ICD diagnose

Autofilling of ICD diagnosis code

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/9oVBN6mMtlYRrmtt-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/9oVBN6mMtlYRrmtt-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 94
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxDiagnose

# SKS Undersøgelse

Dynamic lookup of values from SKS Undersøgelse

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/8ng1Xo4XNK4JLcDn-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/8ng1Xo4XNK4JLcDn-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/I3WCEX5DFFrmw21t-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/I3WCEX5DFFrmw21t-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-/jsOrZ1LAOwkWwbqT-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/jsOrZ1LAOwkWwbqT-image.png)

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

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

- FeltTypeID: 661
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksUndersoegelse

# SKS Diagnose

Autofilling/Dynamic lookup of SKS Diagnose

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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>

\[INSERT IMAGE\]

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/pM73P4DjRTWO85iP-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/pM73P4DjRTWO85iP-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-/SY8LYZLXxL3K3Zwp-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/SY8LYZLXxL3K3Zwp-image.png)

\[Description of configs\]

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

- FeltTypeID: 662
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksDiagnose

# SKS Operation

Dynamic lookup of values from SKS Operation

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/cvyWlwY95z2ViRrM-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/cvyWlwY95z2ViRrM-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/ursduh1exLbNdP4q-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ursduh1exLbNdP4q-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-/PoKInN8wDVPExJJD-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/PoKInN8wDVPExJJD-image.png)

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

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

- FeltTypeID: 663
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksOperation

# SKS Behandling

Dynamic lookup of values from SKS Behandling

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/4hPQIc6GbQDQ2s5Y-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/4hPQIc6GbQDQ2s5Y-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/CjdCNhvyW12MIpN6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/CjdCNhvyW12MIpN6-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-/O5lX7QQ5TtltXoNI-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/O5lX7QQ5TtltXoNI-image.png)

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

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

- FeltTypeID: 664
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksBehandling

# SKS ATC

Dynamic lookup of values from SKS ATC

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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>

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

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/JJzylrQXIWx8KHNz-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/JJzylrQXIWx8KHNz-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-/4Lk5FwDZukecTAqF-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/4Lk5FwDZukecTAqF-image.png)

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

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

- FeltTypeID: 665
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksATC

# SKS Ulykke

Dynamic lookup of values from SKS Ulykke

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/PRX1UM4GbyWy6Cyd-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/PRX1UM4GbyWy6Cyd-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/uzLpaG73oZIZlgh0-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/uzLpaG73oZIZlgh0-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: 666
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksUlykke

# SKS Afdeling

Dynamic lookup of values from SKS Afdeling

### Properties

- Type: [Lookup AJAX](https://docs.tsnocode.com/books/field-type-reference/chapter/lookup-ajax)
- 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-/ioR8XnnR0wGMaTaB-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ioR8XnnR0wGMaTaB-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/0Qr3l68VnrarVLPO-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/0Qr3l68VnrarVLPO-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-/utya5FOKKsz9loD9-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/utya5FOKKsz9loD9-image.png)

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

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

- FeltTypeID: 667
- SQL datatype: VARCHAR(20)
- Class name: FieldAjaxSksSygehusafdeling

# Files

- Package name: files

# Documents

Upload / download of files including versioning

Note that a class is added to the page while uploading ressources: **uploadInProgress**

In case you want to prevent the user presing update, the buttons can be hided with this CSS

```css
 .uploadInProgress .tsUpdateButtons { display: none; }
```

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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-/LXialV3ACOjKUFXZ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/LXialV3ACOjKUFXZ-image.png)

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

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

### Reacting to uploads

The platform sends out custom triggers on upload start, finish and failure.  
To react to these, use the following example

```javascript
$(".custom-file-input").on("TS_UploadStart", () => {
  // React
})
$(".custom-file-input").on("TS_UploadFinished", () => {
  // React
})
$(".custom-file-input").on("TS_UploadFailed", () => {
  // React
})
```

## <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: 50
- SQL datatype: INT(11)
- Class name: FieldFiles

# Pictures

Photo gallery with thumbnail index and optional lightbox to view full size images

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files "Files")
- Groupable: No
- Show in lists: Yes
- 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-03/scaled-1680-/Dnlpm4SpsiCNLNve-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/Dnlpm4SpsiCNLNve-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-03/scaled-1680-/98444iYT3giXZIPZ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/98444iYT3giXZIPZ-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-/Bhr219EWZohD29A2-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Bhr219EWZohD29A2-image.png)

Config1: Number of columns, default is 4  
Config2: Export width, default is 40%  
Config3: Enable lightbox, default is 0 (off)

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

- FeltTypeID: 51
- SQL datatype: INT(11)
- Class name: FieldFilesPictures

# Videos

Video gallery with thumbnails and player.

The video-player only works when Policy [filesystemStorageActive](https://docs.tsnocode.com/books/policy-reference).

To enable down-scaling to 720p and 1080p, the storage has to be on AWS S3, and the Encoding Lambda-function has to be enabled.

As of version 11572 the thumbnail engine was changed to FFmpeg.  
Servers updated to this version, or newer, have to manually download the appropriate [FFmpeg jar](https://repo1.maven.org/maven2/org/bytedeco/ffmpeg/7.1-1.5.11/) and place it in the tomcat-libs folder.  
The version of FFmpeg downloaded must be 7.1-1.5.11.  
Servers installed via the ts-script, after jan 23. 2026 will already have this jar file as part of the default setup.

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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-03/scaled-1680-/owqAlYfqx43cRoCS-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/owqAlYfqx43cRoCS-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-03/scaled-1680-/VhO6fv5FwQNfndGW-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-03/VhO6fv5FwQNfndGW-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-/Dj2goaRVLky0SpN9-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Dj2goaRVLky0SpN9-image.png)

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

<span class="mw-headline">Config1: Number of columns, default is 3  
Config2: Not used  
Config3: Not used</span>

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

- FeltTypeID: 52
- SQL datatype: INT(11)
- Class name: FieldFilesVideos

# Document builder

Build document based on solution file template

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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-/WL3o6oPWFC5JUFtT-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/WL3o6oPWFC5JUFtT-image.png)

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

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

- FeltTypeID: 53
- SQL datatype: INT(11)
- Class name: FieldFilesGenerate

# Filesystem files

Download of local files on the intranet

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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-/hFhQCj3o7Ofpgug1-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/hFhQCj3o7Ofpgug1-image.png)

<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-/QKHQI1e5yWilzKgD-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/QKHQI1e5yWilzKgD-image.png)

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

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

- FeltTypeID: 55
- SQL datatype: Special
- Class name: FieldFilesShared

# Documents with Signing

Upload / download of files including versioning and DocuSign integration, with upload-action and sign-status.

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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-/OysfmLmPvx3Byn2U-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/OysfmLmPvx3Byn2U-image.png)

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

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

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

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

The [DocuSign Integration](https://docs.tsnocode.com/books/standard-integrations/page/docusign-integration "DocuSign Integration") should be configured, otherwise this field is the same as [Files: Documents](https://docs.tsnocode.com/books/field-type-reference/page/documents "FieldFiles")

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

- FeltTypeID: 57
- SQL datatype: INT(11)
- Class name: FieldFilesSigning

# Value copy (files)

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 617
- SQL datatype: N/A
- Class name: FieldReplicateFiles

# Filesystem with FTP

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 56
- SQL datatype: N/A
- Class name: FieldFilesSharedFtp

# Documents to append

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 2150
- SQL datatype: INT(11)
- Class name: FieldFilesAssembler

# Build remote files reference list

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 2152
- SQL datatype: N/A
- Class name: FieldFilesReferenceListBuilder

# Build document from structure

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 2153
- SQL datatype: N/A
- Class name: FieldFilesStructureAssembler

# Append remote files

\[DESCRIPTION\]

### Properties

- Type: [Files](https://docs.tsnocode.com/books/field-type-reference/chapter/files)
- 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: 2151
- SQL datatype: N/A
- Class name: FieldLookupRecordAssembler

# Tabular data

- Package name: table

# Table

Table with a range of subfield

### Properties

- Type: [Tabular data](https://docs.tsnocode.com/books/field-type-reference/chapter/tabular-data)
- 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-/rx3nDBXjJPv4S3OP-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/rx3nDBXjJPv4S3OP-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/VUNeMlGxfnzPWnx2-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/VUNeMlGxfnzPWnx2-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-/Arxo2dRfr8fU3YWQ-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Arxo2dRfr8fU3YWQ-image.png)

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

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

- FeltTypeID: 100
- SQL datatype: INT(11)
- Class name: FieldTable

# Tasklist

Tasklist with export to vTodo

### Properties

- Type: [Tabular data](https://docs.tsnocode.com/books/field-type-reference/chapter/tabular-data)
- 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-/i6NdsnRzSgpYBz8E-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/i6NdsnRzSgpYBz8E-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/vAzbCLdEbse7vS47-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vAzbCLdEbse7vS47-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-/WmeNQTHpaIZBOzUh-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/WmeNQTHpaIZBOzUh-image.png)

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

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

- FeltTypeID: 110
- SQL datatype: INT(11)
- Class name: FieldTask

# Contact list

Contact list with export to vCard

### Properties

- Type: [Tabular data](https://docs.tsnocode.com/books/field-type-reference/chapter/tabular-data)
- 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-/IrRDAZWYGlvHwX1j-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IrRDAZWYGlvHwX1j-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/HneaykINjBQgjb2a-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/HneaykINjBQgjb2a-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-/mcCEYWCQKSae2hwO-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/mcCEYWCQKSae2hwO-image.png)

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

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

- FeltTypeID: 130
- SQL datatype: INT(11)
- Class name: FieldContact

# Mailbox

Inbox for each data item with many security options. Please refer to advanced configuration.

### Properties

- Type: [Tabular data](https://docs.tsnocode.com/books/field-type-reference/chapter/tabular-data)
- 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-/llqMS9gfGzgDXzbv-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/llqMS9gfGzgDXzbv-image.png)

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

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

- FeltTypeID: 160
- SQL datatype: DATETIME
- Class name: FieldMail

# Parent/child

- Package name: relation

# Parent reference

This field creates a reference to another record. Useful in hierarchical data structures. This field allows the parent to implement [List of Children](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild) type fields. In edit mode, this field displays as a black text box with text autocomplete, which means that the user must know at least some of the resume name of the parent they're looking for. Most times a simple drop down of options is preferred, in which case the field [Lookup: Data item](https://docs.tsnocode.com/books/field-type-reference/page/lookup-data-item) should be used. In most cases it is functionally identical to this field.

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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-/GvqwHhXFH64h0SVc-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/GvqwHhXFH64h0SVc-image.png)

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

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

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

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

<span class="mw-headline">Parent solution: Specify which entity the parent record belongs to.</span>

<span class="mw-headline">Allow changes: If this is not checked, the parent cannot be changed later.</span>

<span class="mw-headline">Enable link to master: If this is checked, a button will appear that links directly to the parent. Usually nice to have.</span>

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

- FeltTypeID: 201
- SQL datatype: INT(11)
- Class name: FieldSubformMaster

When writing javascript that reacts to changes in this field type use the following code, instead of onchange.  
This snippit wil react as soon as an option is selected instead of when the user exits the field

```javascript
$("#DATA_SELSKAB").on("autocompleteclose", () => {
    setTimeout(() => {
        // Do stuff
    }, 50)
})
```

# List of children

This displays a list of all children that refer to this via a specific field. This field can be either of type [Parent reference](https://docs.tsnocode.com/books/field-type-reference/page/parent-reference) or [Lookup: Data item](https://docs.tsnocode.com/books/field-type-reference/page/lookup-data-item)

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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-/ESxYgoMv1BzOfwto-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/ESxYgoMv1BzOfwto-image.png)

<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-/qa3DmHYZxNMdXdsS-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/qa3DmHYZxNMdXdsS-image.png)

<span class="mw-headline">Child solution key: Choose which reference field in which entity that the List of Children field should operate from.</span>

<span class="mw-headline">Parameters / sortorders: Normal TS url query. Remember to start with questionmark. Example: </span>

<span class="mw-headline">?QUERY\_FIELD\_1=StatusID&amp;QUERY\_OPERATOR\_1=1&amp;QUERY\_VALUE\_1=24&amp;QUERY\_FIELD\_2=StatusID&amp;QUERY\_OPERATOR\_2=1&amp;QUERY\_VALUE\_2=97</span>

<span class="mw-headline">Read as "Section" &gt; "Child Entity" &gt; "Child's reference field"</span>

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

- FeltTypeID: 200
- SQL datatype: INT(11)
- Class name: FieldSubformList

# List of children (status filter)

Filtered selection of subitems

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/I0fyXpi7wldJhn5o-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/I0fyXpi7wldJhn5o-image.png)

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

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

- FeltTypeID: 222
- SQL datatype: N/A
- Class name: FieldSubformListStatus

# List of children (select fields)

Filtered selection of fields including sortorder

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/e8ZTsRO4DdUj4zKs-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/e8ZTsRO4DdUj4zKs-image.png)

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

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

- FeltTypeID: 223
- SQL datatype: INT(11)
- Class name: FieldSubformListFieldSelection

# List of children (type filter)

For use with 'Children type selector'

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

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

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/kLx4aBYFZ2NLr5GK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/kLx4aBYFZ2NLr5GK-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-/vo4xIRaCc9p1lZ0H-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vo4xIRaCc9p1lZ0H-image.png)

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

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

- FeltTypeID: 220
- SQL datatype: INT(11)
- Class name: FieldSubformListVariant

# Children type selector (type filer)

For use with 'List of children (type)'

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/KwT4Mv4bH9lhfADP-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/KwT4Mv4bH9lhfADP-image.png)

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

No configuration required for this field type

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

- FeltTypeID: 221
- SQL datatype: VARCHAR(80)
- Class name: FieldSubformVariant

# Calc children: Sum

Sum of values in underplaced data

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/yDxDGOzmjFwkF6dX-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/yDxDGOzmjFwkF6dX-image.png)

Required:

- Child value expression refers to a field system name. Example "HOURS"

Options:

- Additional criterions: Additional SQL statement parameter. Example "PROJECT &lt;&gt; 10029"

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

- FeltTypeID: 210
- SQL datatype: N/A
- Class name: FieldSubformLinesSum

# Calc children: Count

Sum of elements in underplaced data

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/1l7qOs2Keb5xNCvo-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/1l7qOs2Keb5xNCvo-image.png)

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

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

- FeltTypeID: 211
- SQL datatype: N/A
- Class name: FieldSubformLinesCount

# Calc children: Unique

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/Rty296QKYlxbadwe-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Rty296QKYlxbadwe-image.png)

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

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

- FeltTypeID: 212
- SQL datatype: N/A
- Class name: FieldSubformLinesDistinct

# Calc children: Minimum

Minimum value in underplaced data

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/wUKOf1lqqHLeRwGr-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/wUKOf1lqqHLeRwGr-image.png)

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

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

- FeltTypeID: 213
- SQL datatype: N/A
- Class name: FieldSubformLinesMin

# Calc children: Average

Average value in underplaced data

### Properties

- Type: [Parent/Child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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>

<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-/y2Zx7UfRQDvSUgns-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/y2Zx7UfRQDvSUgns-image.png)

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

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

- FeltTypeID: 215
- SQL datatype: Special
- Class name: FieldSubformLinesAverage

# Calc children: Maximum

Maximum value in underplaced data

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- Groupable: \[Yes/No\]
- Show in lists: \[Yes/No\]
- Searchable: \[Yes/No\]
- 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>

<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-/Z9vkHkZlIczBVlEf-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Z9vkHkZlIczBVlEf-image.png)

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

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

- FeltTypeID: 214
- SQL datatype: N/A
- Class name: FieldSubformLinesMax

# Many to many relation

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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: 240
- SQL datatype: N/A
- Class name: FieldManyToMany

# Parent reference [shared]

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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: 250
- SQL datatype: INT(11)
- Class name: FieldSharedParentRecord

# List of children (grid-editor)

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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: 203
- SQL datatype: INT(11)
- Class name: FieldSubformListEdit

# List of children [shared]

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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: 251
- SQL datatype: INT(11)
- Class name: FieldSharedSubform

# 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

# System

- Package name: system

# Exclusive group

Selection of an Exclusive group

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/MS1UQrvskpZejZPC-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/MS1UQrvskpZejZPC-image.png)

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

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

- FeltTypeID: 1050
- SQL datatype: INT(11)
- Class name: FieldSystemExclusiveGroup

# Status

The present status of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/xwSoIW32CeJIiPAq-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/xwSoIW32CeJIiPAq-image.png)

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

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

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

<span class="mw-headline">This field does not need deployment (no extra database fields required).</span>

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

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

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

- FeltTypeID: 1004
- SQL datatype: INT(11)
- Class name: FieldSystemStatus

# Status level

\[DESCRIPTION\]

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- 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: 1007
- SQL datatype: N/A
- Class name: FieldSystemStatusLevel

# Master status

Masterstatus based on the status of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

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

- FeltTypeID: 1030
- SQL datatype: N/A
- Class name: FieldSystemStatusMaster

# Status set

The last status update of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 1013
- SQL datatype: DATETIME
- Class name: FieldSystemDatetimeStatusSet

# Status set by

User who last changed status for the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

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

- FeltTypeID: 1023
- SQL datatype: INT(11)
- Class name: FieldSystemUserStatusSet

# Created

The creation date of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 1010
- SQL datatype: DATETIME
- Class name: FieldSystemDatetimeCreated

# Created by

User who created the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/vqCJ9y20aVUKbq0x-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vqCJ9y20aVUKbq0x-image.png)

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

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

This field does not need deployment (no ekstra database fields required).

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

- FeltTypeID: 1020
- SQL datatype: INT(11)
- Class name: FieldSystemUserCreated

# Modified

The change date of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 1011
- SQL datatype: DATETIME
- Class name: FieldSystemDatetimeModified

# Modified by

User who last modified the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/bRP9egCMSHv1PlES-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/bRP9egCMSHv1PlES-image.png)

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

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

This field does not need deployment (no ekstra database fields required).

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

- FeltTypeID: 1021
- SQL datatype: INT(11)
- Class name: FieldSystemUserModified

# Completed

The termination date of the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 1012
- SQL datatype: INT(11)
- Class name: FieldSystemDatetimeCompleted

# Completed by

User who completed the case

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

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

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

This field does not need deployment (no ekstra database fields required).

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

- FeltTypeID: 1022
- SQL datatype: INT(11)
- Class name: FieldSystemUserCompleted

# Solution type

Selection of a solution type

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: Yes
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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>

No configuration required for this field type

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

- FeltTypeID: 1040
- SQL datatype: INT(11)
- Class name: FieldSystemFormType

# Member list

Users with access to the element

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- Groupable: No
- Show in lists: Yes
- Searchable: No
- Requires configuration: 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-/jp18WrgDSBns29e3-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/jp18WrgDSBns29e3-image.png)

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

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

- FeltTypeID: 1051
- SQL datatype: INT(11)
- Class name: FieldSystemMemberList

# Revision

\[DESCRIPTION\]

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- 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: 1001
- SQL datatype: INT(11)
- Class name: FieldSystemRevision

# Record role permission

\[DESCRIPTION\]

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- 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: 1052
- SQL datatype: N/A
- Class name: FieldUserPermission

# Member group list

\[DESCRIPTION\]

### Properties

- Type: [System](https://docs.tsnocode.com/books/field-type-reference/chapter/system)
- 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: 1053
- SQL datatype: INT(11)
- Class name: FieldSystemMemberGroupList

# Medico

- Package name: medico

# Age calc (date/CPR)

Estimating the age of the user based on date and CPR number

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- 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-/mav5Uz0rLsrcEoSI-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/mav5Uz0rLsrcEoSI-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-/BVWrcOlRzup9NaNi-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/BVWrcOlRzup9NaNi-image.png)

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

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

- FeltTypeID: 641
- SQL datatype: DECIMAL(10,2)
- Class name: FieldCalcAgeOnCPR

# Body Mass Index

Calculating BMI based on height and weight (from seperate inputs)

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- 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-/WXHXBysbJoZTRjt8-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/WXHXBysbJoZTRjt8-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-/Craq9JA3af84oYOY-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Craq9JA3af84oYOY-image.png)

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

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

- FeltTypeID: 642
- SQL datatype: DECIMAL(10,2)
- Class name: FieldCalcBMI

# Activity measure

Measurement of weekly activity

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- Groupable: No
- Show in lists: Yes
- Searchable: Yes
- Requires configuration: 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-/Os4BNKKJoVQH1JDA-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/Os4BNKKJoVQH1JDA-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/v54Sxc3c44fB9aNh-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/v54Sxc3c44fB9aNh-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-/9gR43TiNNGvqYq5J-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/9gR43TiNNGvqYq5J-image.png)

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

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

- FeltTypeID: 643
- SQL datatype: DECIMAL(10,4)
- Class name: FieldTrainingSurvey

# Gender (CPR)

Deduction of gender based on CPR number

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- 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-/HrbvoZeGmTA3B8g6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/HrbvoZeGmTA3B8g6-image.png)

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

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

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

- FeltTypeID: 644
- SQL datatype: TINYINT(1)
- Class name: FieldGenderOnCPR

# Checkbox counter

\[DESCRIPTION\]

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- 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: 645
- SQL datatype: VARCHAR(80)
- Class name: FieldCheckboxCollection

# MET scoreboard

Measurement of month, amount and size

### Properties

- Type: [Medico](https://docs.tsnocode.com/books/field-type-reference/chapter/medico)
- Groupable: No
- Show in lists: No
- 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-/vsWNw2f4DejNE9Pd-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/vsWNw2f4DejNE9Pd-image.png)

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

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

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

No configuration required for this field type

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

- FeltTypeID: 646
- SQL datatype: DECIMAL(10,4)
- Class name: FieldCompoundMET

# Action button

- Package name: button

# Button: Token URL builder

Building link to external users

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/hYBZ7e9xyBrQ8zAG-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/hYBZ7e9xyBrQ8zAG-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-/thLUOMOdjomndXwR-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/thLUOMOdjomndXwR-image.png)

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

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

- FeltTypeID: 710
- SQL datatype: N/A
- Class name: FieldTokenMailto

# Button: Export template

Export of data to a certain template

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/AotGKF8MeYTqdobR-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/AotGKF8MeYTqdobR-image.png)

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

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

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

- FeltTypeID: 720
- SQL datatype: N/A
- Class name: FieldExportTemplate

# Button: Script execution

Execute script when clicking the button, with option to save data first.

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/wWjY6HI8mdZ95Fmt-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/wWjY6HI8mdZ95Fmt-image.png)

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

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

<span class="mw-headline">This field requires configuration before deployment.</span>

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

<span class="mw-headline">Javascript: Here you write code to be executed when button is pressed.</span>

<span class="mw-headline">Submit after: Saves the record immediately after code has been run.</span>

<span class="mw-headline">Group filter: limit access to a single group.</span>

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

- FeltTypeID: 730
- SQL datatype: N/A
- Class name: FieldExecuteJavaScript

# Button: Parameterized URL

Button to navigate somewhere else. Can be to an external url.

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/nrDDptPrjY1YOEG6-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/nrDDptPrjY1YOEG6-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-/yoPVUOcXxNQjakxt-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/yoPVUOcXxNQjakxt-image.png)

<span class="mw-headline">URL template: Here you write the target url of the button link. You can use data from a field with the syntax \[\*DATA\*\]. DataID can likewise be used via \[DataID\]. It is also possible to use this field to point to some other location in the application by starting the url from "main?".</span>

<span class="mw-headline">Group filter: Contrary to what it says, you can only filter to a single group, not several.</span>

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

- FeltTypeID: 740
- SQL datatype: N/A
- Class name: FieldParameterLookup

# Button: Related list search

Look-up in related list with parameter

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/4hqvPoqVhpuKlbfK-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/4hqvPoqVhpuKlbfK-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-/OgpUiFRokO8Nmi94-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/OgpUiFRokO8Nmi94-image.png)

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

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

- FeltTypeID: 741
- SQL datatype: N/A
- Class name: FieldParameterListSearch

# Button: Grand child search

Look-up in related data (Grand children)

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/BscorcbKhhXdCabw-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/BscorcbKhhXdCabw-image.png)

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

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

<span class="mw-headline">Due to its nature this field has no special editing mode.</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: 742
- SQL datatype: N/A
- Class name: FieldGrandChildSearch

# Button: Codeunit execution

Execute proprietary code

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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-/5EhHWp8pBWQBS7wE-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/5EhHWp8pBWQBS7wE-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-/DVZSXjBTP8C3HG0G-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/DVZSXjBTP8C3HG0G-image.png)

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

### <span class="mw-headline" id="bkmrk-ajax-subforms-1">Ajax subforms</span>

The following code changes subform behavior to call the codeunit silently and reload the page when done

```javascript
$(function() {
  $('#VB_DATA_SUBFORM a.codeunitButton').click( function(e) { 
    e.preventDefault(); 
    $.get( $(this).attr("href") );
    //$(this).parent().parent().hide();
    location.reload();
    return false; 
  });
});
```

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

- FeltTypeID: 750
- SQL datatype: N/A
- Class name: FieldCodeunitPage

# Button: Status changer

Changes the status of the record to the selected status

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- Groupable: No
- Show in lists: Yes
- Searchable: No
- Requires configuration: 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>

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

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

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

The field does not required configuration before deployment, but does take up to 3 parameters.

Configuration 1: Mandatory StatusID to change to. Forces only that Status to chow up.  
Configuration 2: Optional field to set to NOW upon button-click  
Configuration 3: Group filter. Filter button to only be shown to users with that GroupID

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

- FeltTypeID: 751
- SQL datatype: N/A
- Class name: FieldStateChanger

# Filter selector static

Set value in user session. For example for data filters.

### Properties

- Type: [Action button](https://docs.tsnocode.com/books/field-type-reference/chapter/action-button)
- 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>

<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">\[Description of configs\]</span>

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

- FeltTypeID: 2090
- SQL datatype: N/A
- Class name: FieldSessionFilterSelector

# Button: Clone record

\[DESCRIPTION\]

### Properties

- Type: [Parent/child](https://docs.tsnocode.com/books/field-type-reference/chapter/parentchild)
- 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: 753
- SQL datatype: N/A
- Class name: FieldCloneRecord

# Visual extra

- Package name: visual

# Visual: Target gauge Total

Show lifetime performance speedometer

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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-/z5O0rHYkNVkQjwNo-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/z5O0rHYkNVkQjwNo-image.png)

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 810
- SQL datatype: N/A
- Class name: FieldGaugePerformance

# Visual: Target gauge Step

Show performance speedometer for this step

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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-/QlauF43B4W1nZ2zD-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/QlauF43B4W1nZ2zD-image.png)

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

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

This field does not need deployment (no ekstra database fields required).

No configuration required for this field type

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

- FeltTypeID: 811
- SQL datatype: N/A
- Class name: FieldGaugePerformanceStep

# Canvas: Freehand

Draw, freehand, in a canvas

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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">\[Description of configs\]</span>

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

- FeltTypeID: 812
- SQL datatype: MEDIUMTEXT
- Class name: FieldCanvasDrawing

# Canvas: Marking

Mark a spot on an image

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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">\[Description of configs\]</span>

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

- FeltTypeID: 813
- SQL datatype: TINYTEXT
- Class name: FieldCanvasMarking

# Sliderbar

Numbers with decimal comma using a sliderbar for input

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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-/TbbEeoRJRIcYABQc-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/TbbEeoRJRIcYABQc-image.png)

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/tyl9VY42gu0H5ODk-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/tyl9VY42gu0H5ODk-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-/WsqQf6VWDc01nIpG-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/WsqQf6VWDc01nIpG-image.png)

Required:

- Minimal value
- Maximum value

Options:

- Making the slider display vertically 
    - orientation: "vertical",
- Using steps i the slider 
    - step: 10,
- JSON configuration notes: [\[1\]](http://jqueryui.com/slider/)

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

- FeltTypeID: 911
- SQL datatype: DECIMAL(20,6)
- Class name: FieldSliderBarDecimal

# SQL: Diagram query

Shows an sql-query as a graph, just like the [dashboard widget](https://docs.tsnocode.com/books/dashboards/chapter/diagram-widget-configuration "Dashboard diagram widget configuration"), with the same configs as the [sql-subselect field](https://docs.tsnocode.com/books/field-type-reference/page/sql-subselect "FieldSubselect").

### Properties

- Type: [Visual extra](https://docs.tsnocode.com/books/field-type-reference/chapter/visual-extra)
- 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, when rendering a line-chart.</span>

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

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

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

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

Either, write an sql-query that fetches the exact data to be shown, as described here.

Or, write a simple sql-query that fetches the lines of data and select render-mode "Parse listed data".

Select a graph type, remember that the expected structure of the data is different for circle- and xy-graphs.

### <span class="mw-headline" id="bkmrk-parse-listed-data-1">Parse listed data</span>

This option parses the given data in the following way.

- Column 1 will be used as x-axis values.
- Column 2 will be used for datasets in the graph.
- Column 3 will be used for y-axis values.

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

This is data generated by the query: `SELECT DATE, CATEGORY, AMOUNT FROM data_demoentity ORDER BY DATE ASC`

<table class="wikitable" id="bkmrk-date-category-amount"><tbody><tr><th>Date</th><th>Category</th><th>Amount</th></tr><tr><td>01/01/2024</td><td>Category 1</td><td>10</td></tr><tr><td>01/01/2024</td><td>Category 2</td><td>0</td></tr><tr><td>01/01/2024</td><td>Category 3</td><td>15</td></tr><tr><td>01/02/2024</td><td>Category 1</td><td>20</td></tr><tr><td>01/03/2024</td><td>Category 2</td><td>20</td></tr><tr><td>01/04/2024</td><td>Category 1</td><td>30</td></tr><tr><td>01/04/2024</td><td>Category 2</td><td>10</td></tr><tr><td>01/04/2024</td><td>Category 3</td><td>15</td></tr></tbody></table>

This will be transformed to this, when rendering an xy-graph.

<table class="wikitable" id="bkmrk-title-category-1-cat"><tbody><tr><th>Title</th><th>Category 1</th><th>Category 2</th><th>Category 3</th></tr><tr><td>01/01/2024</td><td>10</td><td>0</td><td>15</td></tr><tr><td>01/02/2024</td><td>20</td><td> </td><td> </td></tr><tr><td>01/03/2024</td><td> </td><td>20</td><td> </td></tr><tr><td>01/04/2024</td><td>30</td><td>10</td><td>15</td></tr></tbody></table>

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

- FeltTypeID: 530
- SQL datatype: N/A
- Class name: FieldSubselectDiagram

# Extension

- Package name: extension

# Word heatmap index

Specialised index field only showned in reports

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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 is never shown in the interface.

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

This field does not need deployment (no extra database fields required).

No configuration required for this field type.

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

- FeltTypeID: 690
- SQL datatype: N/A
- Class name: FieldComplexQuestionIndex

# Question and answer

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2065
- SQL datatype: INT(11)
- Class name: FieldComplexQuestion

# Complex question

Complex question with recommendation, numerical score and coloring

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- Groupable: No
- Show in lists: No
- 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>

<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-/C131oxRW5Uz0Omen-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/C131oxRW5Uz0Omen-image.png)

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

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

- FeltTypeID: 2066
- SQL datatype: INT(11)
- Class name: FieldComplexQuestionWillis

# Multiline: Complex question

MULTIPLE LOCATION: Complex question

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- Groupable: No
- Show in lists: No
- Searchable: No
- 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>

<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-/kcZ2ZAVgXM9KWIrY-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/kcZ2ZAVgXM9KWIrY-image.png)

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

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

- FeltTypeID: 2067
- SQL datatype: INT(11)
- Class name: FieldComplexQuestionMultiLocation

# Multiline: Location editor

MULTIPLE LOCATION: Name of location

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- Groupable: No
- Show in lists: No
- 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>

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

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

<span class="mw-headline">For bulk imports the "|" (vertical bar or pipe) may be used as an alternative newline.</span>

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

No configuration required for this field type

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

- FeltTypeID: 2068
- SQL datatype: N/A
- Class name: FieldMultiLocation

# Year comparator

Comparing fields from previous years

### Properties

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

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

This field is not displayed as a normal field.

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

[![image.png](https://docs.tsnocode.com/uploads/images/gallery/2025-07/scaled-1680-/eyN33GOUhYCmVhCL-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/eyN33GOUhYCmVhCL-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-/pSkFqpt04e7dasgS-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/pSkFqpt04e7dasgS-image.png)

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

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

- FeltTypeID: 2070
- SQL datatype: N/A
- Class name: FieldYearRepeatCompare

# Calc: Complex question (sum)

Formula based on other fields

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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>

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-/rCtTkX1FLlJBHlDT-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/rCtTkX1FLlJBHlDT-image.png)

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

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

- FeltTypeID: 2081
- SQL datatype: DECIMAL(10,4)
- Class name: FieldCalcFormulaWillis

# Calc: Count missing fields

Number of missing fields in a form or questionaire

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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>

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-/GTr8k3l8yX3t3UqC-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/GTr8k3l8yX3t3UqC-image.png)

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

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

- FeltTypeID: 2082
- SQL datatype: INT(11)
- Class name: FieldMissingValues

# Jobnet OccupationConceptUri

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2020
- SQL datatype: VARCHAR(256)
- Class name: FieldJobnetOccupationConceptUri

# Document snippet

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2064
- SQL datatype: INT(11)
- Class name: FieldDocumentSnippetLookup

# Multiline: Index builder

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2069
- SQL datatype: N/A
- Class name: FormComplexQuestionMultiLocationIndex

# Question and answer

Complex question with recommendation, numerical score and coloring

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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-/IaJvRLGBkINfOHNl-image.png)](https://docs.tsnocode.com/uploads/images/gallery/2025-07/IaJvRLGBkINfOHNl-image.png)

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

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

- FeltTypeID: 2065
- SQL datatype: N/A
- Class name: FieldComplexQuestion

# Complex question MV

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2166
- SQL datatype: INT(11)
- Class name: FieldComplexQuestionWillisMV

# Diagram builder

\[DESCRIPTION\]

### Properties

- Type: [Extension](https://docs.tsnocode.com/books/field-type-reference/chapter/extension)
- 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: 2071
- SQL datatype: N/A
- Class name: FieldDiagramBuilder