Field type reference
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
TS has more than a 150 different content types. Some are based on primitive types (eg. integers) while others deliver complex functionality (eg. document librarys).
Basic
Integer | Integer value |
Decimal | Numbers with decimal comma |
Percentage | Percentage value (decimal) |
Yes/No | Check box. Yes/No. The values can be shown with other words or icons |
Serial | Unique serial number |
Response | Interval in questionnaire |
Enumeration | Named numbers ex. Grades |
Symbol | Use icons as status flow and categories |
Date | Date with calendar look-up |
Time | Selector for point in time |
Datetime | Date with calendar/time look-up |
Month | Choice of month, including translation |
Year | Choice of year |
Text | A single line of a text (ex. Name) |
Text mulitline | Mulible line of text (ex. Adresses) |
Notepad | Editor shown in the interface |
Hierachy/tree | Hierarchy of values |
User email-adress | |
Website (URL) | Internet adress |
Unique key (GUID) | Global Unique ID (GUID) for records, inserted automatically on record creation. |
Text with lookup | A single line text with look-up in exciting values |
Phone | phone number with the possibility for look-up |
CPR nummer | validation of control digits with the personal identification number |
CVR nummer | CVR number with look-up in the CVR register |
Static content | Read-out of various content |
Static button | Buttom with functionality |
Static message | Notification on top of the page |
Static script | Execution of the code when changing other boxes |
Script function | Execution of the code with value insertion into other fields |
A line of text with lookup on existing values | A line of text with lookup on existing values |
Prioritize cases among themselves directly from lists | Prioritize cases among themselves directly from lists |
Lookup
Lookup (shared) | Look-up in common list of values |
Lookup | Look-up in local list of values |
User | Users of the system. Those who are being added, can as an option be notified |
Group | Groups in the system. Those who are being added, can as an option be notified |
Dependent list (lokal) | Choise based on another local list |
Dependent category | Categories based on value |
List replica | Copy of another list (same option) |
Lookup: Currency code | List of currency code |
User Exclusive | User from af certain Exclusive group |
Variant selector | List of types, which are controlling which other boxes are being showed |
Database: Opslag indtastning | Look-up of values in foreign database |
Database: Opslag liste valg | Table of values from foreign |
SQL: Subselect | Enquiry in own or foreign database |
Lookup: Data item | Create reference to item in another solution |
Lookup: Data item nested | For use with Lookup: Data item |
Value copy | Showing other values based on a key |
Value copy (text) | Coping TEXT value based on key (searchable) |
Value copy (heltal) | Coping INTEGER value based on key (searchable) |
Value copy (decimal) | Coping DECIMAL value based on key (searchable) |
Value copy (yes/no) | Coping Yes/No values based on key (searchable) |
Value copy (date) | Coping DATE values based on key (searchable) |
Value copy (cpr) | Coping CPR number based on key (searchable) |
Copy field lookup options for another field in this solution | Copy field lookup options for another field in this solution |
User from the case owner group or related to active user | User from the case owner group or related to active user |
Lookup AJAX
Lookup: Postnr / by | Autofilling of postal number and city |
Lookup: UNSPSC | Autofilling of the product category system of UN |
Lookup: NACE code | Autofilling of NACE business codes |
Lookup: Country | Autofilling of land |
Lookup: ICD diagnose | Autofilling of ICD diagnosis code |
SKS Undersøgelse | Dynamic lookup of values from SKS Undersøgelse |
SKS Diagnose | Dynamic lookup of values from SKS Diagnose |
SKS Operation | Dynamic lookup of values from SKS Operation |
SKS Behandling | Dynamic lookup of values from SKS Behandling |
SKS ATC | Dynamic lookup of values from SKS ATC |
SKS Ulykke | Dynamic lookup of values from SKS Ulykke |
SKS Afdeling | Dynamic lookup of values from SKS Afdeling |
Files
Documents | Upload / download of files including versioning |
Pictures | Photo gallery with thumbnail index |
Document builder | Build document base on solution file template |
Filesystem files | Download of local files on the intranet |
Documents with signing | Documents with integration to DocuSign |
Copy list of files based on key | Copy list of files based on key |
FTP / download helper for structures and large files | FTP / download helper for structures and large files |
Tabular data
Table | Table with a range of subfield |
Tasklist | Tasklist with export to vTodo |
Contact list | Contact list with export to vCard |
Mailbox | Inbox for each data item with many security options. Please refer to advanced configuration. |
Parent/child
Parent reference | Link/resume to above placed data |
List of children | List of all underplaced data |
List of children (status filter) | Filtered selection of subitems |
List of children (select fields) | Filtered selection of fields including sortorder |
List of children (type filter) | For use with 'Children type selector' |
Children type selector (type filer) | For use with 'List of children (type)' |
Calc children: Sum | Sum of values in underplaced data |
Calc children: Count | Sum of elements in underplaced data |
Calc children: Unique | Sum of unique values in underplaced data |
Calc children: Minimum | Minimum value in underplaced data |
Calc children: Maximum | Maximum value in underplaced data |
Many records pointing to many other records | Many records pointing to many other records |
Not written | Parent reference(shared) |
Complex
Checklist lookup | Number of categories |
Signature | Digital signature or approval |
Calc: Formula | Formula based on other fields |
Calc: Test value | Test of the value of another field |
Calc: Concatenate | Making a test based on values from other fields |
Calc: JavaScript | Executing Javascripts client AND serverside |
Calc: Time lifecycle | Time spent since the beginning of the case or since last correction |
Calc: Time measured | Total waiting time |
Calc: Score interval | Translation of values in intervals |
Calc: Check fields | Check if a list of fields has been filled out |
Comments | Entry of a list of comments from the users of the case |
Related form multiselect | Filter with single parameters including standard security. |
Related form multiselect SQL | Freeform definition with multiple parameters with optional security. |
XML data | XML data in lists, table or own output format |
Barcode (status change) | Barcode to change status automatically |
Display grid of values from local database table | Display grid of values from local database table |
Not written | Calc: Flag |
Output in subforms from other searches and statistics | Output in subforms from other searches and statistics |
Selective text composition (EXPERIMENTAL) | Selective text composition (EXPERIMENTAL) |
Fill multiple lines with numbers (decimals) | Fill multiple lines with numbers (decimals) |
Show token to a specific interface | Show token to a specific interface |
Run script | Run script |
System
Status | The present status of the case |
Created | The creation date of the case |
Modified | The change date of the case |
Completed | The termination date of the case |
Status set | The last status update of the case |
Created by | User who created the case |
Modified by | User who modified the case |
Completed by | User who completed the case |
Status set by | User who updated the case |
Master status | Masterstatus based on the status of the case |
Solution type | Selection of a solution type |
Exclusive group | Selection of an Exclusive group |
Member list | Users with access to the element |
Not written | FieldSystemRevision |
Not written | FieldUserPermission |
Groups with access to element | Groups with access to element |
Medico
Age calc (date/CPR) | Estimating the age of the user based on date and CPR number |
Body Mass Index | Estimating BMI based on height and weight |
Activity measure | Measurement of weekly activity |
Gender (CPR) | Deduction of gender based on CPR number |
Checkbox counter | Check mark of month, days or other |
MET scoreboard | Measurement of month, amount and size |
Action button
Button: Token URL builder | Building link to external users |
Button: Export template | Export of data to a certain template |
Button: Script execution | Execute script on page and/or saving data |
Button: Parameterized URL | Look-up in foreign webbased system |
Button: Related list search | Look-up in related list with parameter |
Button: Grand child search | Look-up in related data (Grand children) |
Button: Codeunit execution | Execute proprietary code |
Button: Status changer | Change state via button-click |
Filter selector static | Set value in user session. For example for data filters. |
Visual extra
Visual: Target gauge Total | Show lifetime performance speedometer |
Visual: Target gauge Step | Show performance speedometer for this step |
Canvas: Freehand | Draw anything in a box |
Canvas: Marking | Mark a spot on an image |
Visual: Sliderbar | Sliderbar for integer or decimal input |
Extension
Word heatmap index | Specialised index field only showned in reports |
Question and answer | Complex question with recommendation, numerical score and coloring |
Complex question | Complex question with recommendation, numerical score and coloring |
Multiline: Complex question | MULTIPLE LOCATION: Complex question |
Multiline: Location editor | MULTIPLE LOCATION: Name of location |
Year comparator | Comparing fields from previous years |
Calc: Complex question (sum) | Formula based on other fields |
Calc: Count missing fields | Number of missing fields in a form or questionaire |
Testing: Age record | Change the age of a record for testing puposes |
Required for jobnet integration | Required for jobnet integration |
Export document content based on selected value | Export document content based on selected value |
Word rapport index for multilocations | Word rapport index for multilocations |
Comparison of fields from previous years | Comparison of fields from previous years |