# 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