# 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