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. P...
Integer
Capable of containing basic numbers (no decimals).Due to technical limitations the number can't b...
Decimal
Numbers with decimal comma Properties Type: Basic Groupable: No Show in lists: Yes Searcha...
Percentage
Percentage value (decimal) Properties Type: Basic Groupable: No Show in lists: Yes Searcha...
Yes/No
Check box. Yes/No. The values can be shown with other words or icons Properties Type: Basic ...
Serial
Unique serial number Properties Type: Basic Groupable: Yes Show in lists: Yes Searchable: ...
Response
Interval in questionnaire Properties Type: Basic Groupable: No Show in lists: Yes Searchab...
Enumeration
Named numbers ex. Grades Properties Type: Basic Groupable: Yes Show in lists: Yes Searchab...
Symbol
Use icons as status flow and categories Properties Type: Basic Groupable: Yes Show in lists...
Date
Date with calendar look-up Properties Type: Basic Groupable: Yes Show in lists: Yes Search...
Time
Selector for point in time Properties Type: Basic Groupable: No Show in lists: Yes Searcha...
Datetime
Date with calendar/time look-up Properties Type: Basic Groupable: Yes Show in lists: Yes S...
Month
Choice of month, including translation Properties Type: Basic Groupable: Yes Show in lists:...
Year
Choice of year Properties Type: Basic Groupable: Yes Show in lists: Yes Searchable: Yes R...
Text
A single line of a text (ex. Name).The text can't be longer than 255 characters. Properties T...
Text multiline
Multiple lines of text (ex. Adresses) Properties Type: Basic Groupable: No Show in lists: Y...
Notepad
WYSIWYG Editor shown in the interface Properties Type: Basic Groupable: No Show in lists: Y...
Hierachy/tree
Hierarchy of values Properties Type: Basic Groupable: Yes Show in lists: Yes Searchable: Y...
User email-adress Properties Type: Basic Groupable: No Show in lists: Yes Searchable: Yes ...
Website (URL)
Stores an internet address. Properties Type: Basic Groupable: No Show in lists: Yes Search...
Unique key (GUID)
Global Unique ID (GUID) for records, inserted automatically on record creation. Properties Ty...
Text with lookup
A single line text with look-up in exciting values Properties Type: Basic Groupable: No Sho...
Phone
Phone number with the possibility for look-up Properties Type: Basic Groupable: No Show in ...
CPR nummer
Validation of control digits with the personal identification number Properties Type: Basic ...
CVR nummer
CVR number with look-up in the CVR register Properties Type: Basic Groupable: No Show in li...
Static content
A static message/information, that supports translation. Properties Type: Basic Groupable: N...
Static button
Button with functionality Properties Type: Basic Groupable: No Show in lists: Yes Searchab...
Static message
Notification on top of the page Properties Type: Basic Groupable: No Show in lists: No Sea...
Static script
Execution of the code when changing other boxes Properties Type: Basic Groupable: No Show i...
Script function
Execution of the code with value insertion into other fields Properties Type: Basic Groupabl...
Priority
[DESCRIPTION] Properties Type: Basic Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Currency
UNDER DEVELOPMENT [DESCRIPTION] Properties Type: Basic Groupable: [YES/NO] Show in lists: ...
Lookup
Package name: lookup
Lookup
Look-up in local list of values Properties Type: Lookup Groupable: Yes Show in lists: Yes ...
Lookup (shared)
Look-up in common list of values Properties Type: Lookup Groupable: Yes Show in lists: Yes ...
User
Users of the system. Those who are being added, can as an option be notified Properties Type:...
User Exclusive
User from a certain Exclusive group (the one set on the record) Properties Type: Lookup Grou...
Group
Groups in the system. Those who are being added, can as an option be notified Properties Type...
Dependent list (lokal)
Choice based on another local list Properties Type: Lookup Groupable: Yes Show in lists: Ye...
Dependent category
Categories based on value Properties Type: Lookup Groupable: Yes Show in lists: Yes Search...
List replica
Copy of another list (same options) Properties Type: Lookup Groupable: No Show in lists: Ye...
Lookup: Currency code
List of currency codes Properties Type: Lookup Groupable: Yes Show in lists: Yes Searchabl...
Variant selector
List of types, which are controlling which other boxes are being showed Properties Type: Look...
Database: Opslag indtastning
Look-up of values in foreign database Properties Type: Lookup Groupable: No Show in lists: ...
Database: Opslag liste valg
Table of values from foreign database Properties Type: Lookup Groupable: No Show in lists: ...
SQL: Subselect
Enquiry in own or foreign database Properties Type: Lookup Groupable: No Show in lists: Yes...
Lookup: Data item
Create reference to item in another solution Properties Type: Lookup Groupable: No Show in ...
Lookup: Data item nested
For use with Lookup: Data item Properties Type: Lookup Groupable: No Show in lists: Yes Se...
Value copy
Showing other values based on a key Properties Type: Lookup Groupable: No Show in lists: Ye...
Value copy (text)
Coping TEXT value based on key (searchable) Properties Type: Lookup Groupable: No Show in l...
Value copy (Integer)
Coping DECIMAL value based on key (searchable) Properties Type: Lookup Groupable: No Show i...
Value copy (decimal)
Coping DECIMAL value based on key (searchable) Properties Type: Lookup Groupable: No Show i...
Value copy (yes/no)
Coping Yes/No values based on key (searchable) Properties Type: Lookup Groupable: No Show i...
Value copy (date)
Coping DATE values based on key (searchable) Properties Type: Lookup Groupable: No Show in ...
Value copy (cpr)
Coping CPR number based on key (searchable) Properties Type: Lookup Groupable: No Show in l...
Dependent list replica
[DESCRIPTION] Properties Type: Lookup Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
Lookup AJAX
Package name: ajax
Lookup: Postnr / by
Autofilling of danish postal number and city Properties Type: Lookup AJAX Groupable: Yes Sh...
Lookup: UNSPSC
Autofilling of the product category system of UN Properties Type: Lookup AJAX Groupable: Yes...
Lookup: NACE code
Autofilling of NACE business codes Properties Type: Lookup AJAX Groupable: Yes Show in list...
Lookup: Country
Autofilling of country Properties Type: Lookup AJAX Groupable: Yes Show in lists: Yes Sear...
Lookup: ICD diagnose
Autofilling of ICD diagnosis code Properties Type: Lookup AJAX Groupable: Yes Show in lists...
SKS Undersøgelse
Dynamic lookup of values from SKS Undersøgelse Properties Type: Lookup AJAX Groupable: No S...
SKS Diagnose
Autofilling/Dynamic lookup of SKS Diagnose Properties Type: Lookup AJAX Groupable: No Show ...
SKS Operation
Dynamic lookup of values from SKS Operation Properties Type: Lookup AJAX Groupable: No Show...
SKS Behandling
Dynamic lookup of values from SKS Behandling Properties Type: Lookup AJAX Groupable: No Sho...
SKS ATC
Dynamic lookup of values from SKS ATC Properties Type: Lookup AJAX Groupable: Yes Show in l...
SKS Ulykke
Dynamic lookup of values from SKS Ulykke Properties Type: Lookup AJAX Groupable: No Show in...
SKS Afdeling
Dynamic lookup of values from SKS Afdeling Properties Type: Lookup AJAX Groupable: No Show ...
Files
Package name: files
Documents
Upload / download of files including versioning Note that a class is added to the page while upl...
Pictures
Photo gallery with thumbnail index and optional lightbox to view full size images Properties ...
Videos
Video gallery with thumbnails and player. The video-player only works when Policy filesystemStor...
Document builder
Build document based on solution file template Properties Type: Files Groupable: No Show in...
Filesystem files
Download of local files on the intranet Properties Type: Files Groupable: No Show in lists:...
Documents with Signing
Upload / download of files including versioning and DocuSign integration, with upload-action and ...
Value copy (files)
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Filesystem with FTP
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Documents to append
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Build remote files reference list
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Build document from structure
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Append remote files
[DESCRIPTION] Properties Type: Files Groupable: [YES/NO] Show in lists: [YES/NO] Searchabl...
Tabular data
Package name: table
Table
Table with a range of subfield Properties Type: Tabular data Groupable: NO Show in lists: Y...
Tasklist
Tasklist with export to vTodo Properties Type: Tabular data Groupable: No Show in lists: Ye...
Contact list
Contact list with export to vCard Properties Type: Tabular data Groupable: No Show in lists...
Mailbox
Inbox for each data item with many security options. Please refer to advanced configuration. Pro...
Parent/child
Package name: relation
Parent reference
Link/resume to above placed data Properties Type: Parent/child Groupable: No Show in lists:...
List of children
List of all underplaced data Properties Type: Parent/child Groupable: No Show in lists: Yes...
List of children (status filter)
Filtered selection of subitems Properties Type: Parent/child Groupable: No Show in lists: Y...
List of children (select fields)
Filtered selection of fields including sortorder Properties Type: Parent/child Groupable: No...
List of children (type filter)
For use with 'Children type selector' Properties Type: Parent/child Groupable: No Show in l...
Children type selector (type filer)
For use with 'List of children (type)' Properties Type: Parent/child Groupable: No Show in ...
Calc children: Sum
Sum of values in underplaced data Properties Type: Parent/child Groupable: No Show in lists...
Calc children: Count
Sum of elements in underplaced data Properties Type: Parent/child Groupable: No Show in lis...
Calc children: Unique
[DESCRIPTION] Properties Type: Parent/child Groupable: No Show in lists: Yes Searchable: Y...
Calc children: Minimum
Minimum value in underplaced data Properties Type: Parent/child Groupable: No Show in lists...
Calc children: Average
Average value in underplaced data Properties Type: Parent/Child Groupable: No Show in lists...
Calc children: Maximum
Maximum value in underplaced data Properties Type: Parent/child Groupable: [Yes/No] Show in...
Many to many relation
[DESCRIPTION] Properties Type: Parent/child Groupable: [YES/NO] Show in lists: [YES/NO] Se...
Parent reference [shared]
[DESCRIPTION] Properties Type: Parent/child Groupable: [YES/NO] Show in lists: [YES/NO] Se...
List of children (grid-editor)
[DESCRIPTION] Properties Type: Parent/child Groupable: [YES/NO] Show in lists: [YES/NO] Se...
List of children [shared]
[DESCRIPTION] Properties Type: Parent/child Groupable: [YES/NO] Show in lists: [YES/NO] Se...
Complex
Package name: special
Checklist lookup
Number of categories Properties Type: Complex Groupable: Yes Show in lists: Yes Searchable...
Signature
Digital signature or approval Properties Type: Complex Groupable: No Show in lists: Yes Se...
Calc: Formula
Formula based on other fields Properties Type: Complex Groupable: No Show in lists: Yes Se...
Calc: Test value
Test of the value of another field Properties Type: Complex Groupable: No Show in lists: Ye...
Calc: Concatenate
Making a text based on values from other fields. The field supports a basic version of Complex f...
Calc: JavaScript
Executing Javascripts client AND serverside NOTE: This feature is currently BETA, and features a...
Calc: Time lifecycle
Time spent since the beginning of the case or since last correction Properties Type: Complex ...
Calc: Time measured
Total waiting time Properties Type: Complex Groupable: No Show in lists: Yes Searchable: Y...
Calc: Score interval
Translation of values in intervals Properties Type: Complex Groupable: No Show in lists: Ye...
Calc: Check fields
Check if a list of fields has been filled out Properties Type: Complex Groupable: No Show i...
Comments
Entry of a list of comments from the users of the case Properties Type: Complex Groupable: N...
Related form multiselect
Filter with single parameters including standard security. Properties Type: Complex Groupabl...
Related form multiselect SQL
Freeform definition with multiple parameters with optional security. Properties Type: Complex...
XML data
XML data in lists, table or own output format Properties Type: Complex Groupable: No Show i...
Barcode (status change)
Barcode to change status automatically Properties Type: Complex Groupable: No Show in lists...
SQL: Table query
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
Calc: Flag
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
Related entity multiline decimal
A table of lines from another table, maybe with a filter that relates them to this items DataID, ...
Token display
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
Calc: Document section
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
Geomap Coding
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
Geomap
[DESCRIPTION] Properties Type: Complex Groupable: [YES/NO] Show in lists: [YES/NO] Searcha...
System
Package name: system
Exclusive group
Selection of an Exclusive group Properties Type: System Groupable: No Show in lists: Yes S...
Status
The present status of the case Properties Type: System Groupable: No Show in lists: Yes Se...
Status level
[DESCRIPTION] Properties Type: System Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
Master status
Masterstatus based on the status of the case Properties Type: System Groupable: Yes Show in...
Status set
The last status update of the case Properties Type: System Groupable: Yes Show in lists: Ye...
Status set by
User who last changed status for the case Properties Type: System Groupable: Yes Show in li...
Created
The creation date of the case Properties Type: System Groupable: Yes Show in lists: Yes Se...
Created by
User who created the case Properties Type: System Groupable: Yes Show in lists: Yes Search...
Modified
The change date of the case Properties Type: System Groupable: Yes Show in lists: Yes Sear...
Modified by
User who last modified the case Properties Type: System Groupable: Yes Show in lists: Yes ...
Completed
The termination date of the case Properties Type: System Groupable: Yes Show in lists: Yes ...
Completed by
User who completed the case Properties Type: System Groupable: Yes Show in lists: Yes Sear...
Solution type
Selection of a solution type Properties Type: System Groupable: Yes Show in lists: Yes Sea...
Member list
Users with access to the element Properties Type: System Groupable: No Show in lists: Yes ...
Revision
[DESCRIPTION] Properties Type: System Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
Record role permission
[DESCRIPTION] Properties Type: System Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
Member group list
[DESCRIPTION] Properties Type: System Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
Medico
Package name: medico
Age calc (date/CPR)
Estimating the age of the user based on date and CPR number Properties Type: Medico Groupabl...
Body Mass Index
Calculating BMI based on height and weight (from seperate inputs) Properties Type: Medico Gr...
Activity measure
Measurement of weekly activity Properties Type: Medico Groupable: No Show in lists: Yes Se...
Gender (CPR)
Deduction of gender based on CPR number Properties Type: Medico Groupable: No Show in lists...
Checkbox counter
[DESCRIPTION] Properties Type: Medico Groupable: [YES/NO] Show in lists: [YES/NO] Searchab...
MET scoreboard
Measurement of month, amount and size Properties Type: Medico Groupable: No Show in lists: ...
Action button
Package name: button
Button: Token URL builder
Building link to external users Properties Type: Action button Groupable: No Show in lists:...
Button: Export template
Export of data to a certain template Properties Type: Action button Groupable: No Show in l...
Button: Script execution
Execute script when clicking the button, with option to save data first. Properties Type: Act...
Button: Parameterized URL
Look-up in foreign webbased system Properties Type: Action button Groupable: No Show in lis...
Button: Related list search
Look-up in related list with parameter Properties Type: Action button Groupable: No Show in...
Button: Grand child search
Look-up in related data (Grand children) Properties Type: Action button Groupable: No Show ...
Button: Codeunit execution
Execute proprietary code Properties Type: Action button Groupable: No Show in lists: No Se...
Button: Status changer
Changes the status of the record to the selected status Properties Type: Action button Group...
Filter selector static
Set value in user session. For example for data filters. Properties Type: Action button Grou...
Button: Clone record
[DESCRIPTION] Properties Type: Parent/child Groupable: [YES/NO] Show in lists: [YES/NO] Se...
Visual extra
Package name: visual
Visual: Target gauge Total
Show lifetime performance speedometer Properties Type: Visual extra Groupable: No Show in l...
Visual: Target gauge Step
Show performance speedometer for this step Properties Type: Visual extra Groupable: No Show...
Canvas: Freehand
Draw, freehand, in a canvas Properties Type: Visual extra Groupable: [YES/NO] Show in lists...
Canvas: Marking
Mark a spot on an image Properties Type: Visual extra Groupable: [YES/NO] Show in lists: [Y...
Sliderbar
Numbers with decimal comma using a sliderbar for input Properties Type: Visual extra Groupab...
SQL: Diagram query
Shows an sql-query as a graph, just like the dashboard widget, with the same configs as the sql-s...
Extension
Package name: extension
Word heatmap index
Specialised index field only showned in reports Properties Type: Extension Groupable: No Sh...
Question and answer
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...
Complex question
Complex question with recommendation, numerical score and coloring Properties Type: Extension...
Multiline: Complex question
MULTIPLE LOCATION: Complex question Properties Type: Extension Groupable: No Show in lists:...
Multiline: Location editor
MULTIPLE LOCATION: Name of location Properties Type: Extension Groupable: No Show in lists:...
Year comparator
Comparing fields from previous years Properties Type: Extension Groupable: No Show in lists...
Calc: Complex question (sum)
Formula based on other fields Properties Type: Extension Groupable: No Show in lists: No S...
Calc: Count missing fields
Number of missing fields in a form or questionaire Properties Type: Extension Groupable: No ...
Jobnet OccupationConceptUri
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...
Document snippet
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...
Multiline: Index builder
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...
Question and answer
Complex question with recommendation, numerical score and coloring Properties Type: Extension...
Complex question MV
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...
Diagram builder
[DESCRIPTION] Properties Type: Extension Groupable: [YES/NO] Show in lists: [YES/NO] Searc...