Difference between revisions of "Field type reference"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
Line 1: | Line 1: | ||
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). | 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). | ||
Line 6: | Line 8: | ||
{| | {| | ||
|[[FieldNumberInteger|Integer]] | |[[FieldNumberInteger|Integer]] | ||
| | |Integer value | ||
|- | |- | ||
|[[FieldNumberDecimal|Decimal]] | |[[FieldNumberDecimal|Decimal]] | ||
| | |Numbers with decimal comma | ||
|- | |- | ||
|[[FieldNumberDecimalPercent|Percentage]] | |[[FieldNumberDecimalPercent|Percentage]] | ||
| | |Percentage value (decimal) | ||
|- | |- | ||
|[[FieldNumberBoolean|Yes/No]] | |[[FieldNumberBoolean|Yes/No]] | ||
| | |Check box. Yes/No. The values can be shown with other words or icons | ||
|- | |- | ||
|[[FieldSerial|Serial]] | |[[FieldSerial|Serial]] | ||
| | |Unique serial number | ||
|- | |- | ||
|[[FieldNumberIntegerResponse|Response]] | |[[FieldNumberIntegerResponse|Response]] | ||
|Interval | |Interval in questionnaire | ||
|- | |- | ||
|[[FieldNumberIntegerEnumeration|Enumeration]] | |[[FieldNumberIntegerEnumeration|Enumeration]] | ||
| | |Named numbers ex. Grades | ||
|- | |- | ||
|[[FieldNumberIntegerGlyph|Symbol]] | |[[FieldNumberIntegerGlyph|Symbol]] | ||
| | |Use icons as status flow and categories | ||
|- | |- | ||
|[[FieldTimeDate|Date]] | |[[FieldTimeDate|Date]] | ||
| | |Date with calendar look-up | ||
|- | |- | ||
|[[FieldTimeTime|Time]] | |[[FieldTimeTime|Time]] | ||
| | |Selector for point in time | ||
|- | |- | ||
|[[FieldTimeDatetime|Datetime]] | |[[FieldTimeDatetime|Datetime]] | ||
| | |Date with calendar/time look-up | ||
|- | |- | ||
|[[FieldTimePartMonth|Month]] | |[[FieldTimePartMonth|Month]] | ||
| | |Choice of month, including translation | ||
|- | |- | ||
|[[FieldTimePartYear|Year]] | |[[FieldTimePartYear|Year]] | ||
| | |Choice of year | ||
|- | |- | ||
|[[FieldText|Text]] | |[[FieldText|Text]] | ||
| | |A single line of a text (ex. Name) | ||
|- | |- | ||
|[[FieldTextMemo|Text mulitline]] | |[[FieldTextMemo|Text mulitline]] | ||
| | |Mulible line of text (ex. Adresses) | ||
|- | |- | ||
|[[FieldTextMemoEditor|Notepad]] | |[[FieldTextMemoEditor|Notepad]] | ||
| | |Editor shown in the interface | ||
|- | |- | ||
|[[FieldTextHieraki|Hierachy/tree]] | |[[FieldTextHieraki|Hierachy/tree]] | ||
| | |Hierarchy of values | ||
|- | |- | ||
|[[FieldTextEmail|Email]] | |[[FieldTextEmail|Email]] | ||
| | |User email-adress | ||
|- | |- | ||
|[[FieldTextURL|Website (URL)]] | |[[FieldTextURL|Website (URL)]] | ||
| | |Internet adress | ||
|- | |- | ||
|[[FieldUniqueIdentity|Unique key (GUID)]] | |[[FieldUniqueIdentity|Unique key (GUID)]] | ||
| | |Global Unique ID (GUID) for records, inserted automatically on record creation. | ||
|- | |- | ||
|[[FieldTextSuggest|Text with lookup]] | |[[FieldTextSuggest|Text with lookup]] | ||
| | |A single line text with look-up in exciting values | ||
|- | |- | ||
|[[FieldTextPhone|Phone]] | |[[FieldTextPhone|Phone]] | ||
| | |phone number with the possibility for look-up | ||
|- | |- | ||
|[[FieldTextCPR|CPR nummer]] | |[[FieldTextCPR|CPR nummer]] | ||
| | |validation of control digits with the personal identification number | ||
|- | |- | ||
|[[FieldTextCVR|CVR nummer]] | |[[FieldTextCVR|CVR nummer]] | ||
| | |CVR number with look-up in the CVR register | ||
|- | |- | ||
|[[FieldContentStatic|Static content]] | |[[FieldContentStatic|Static content]] | ||
| | |Read-out of various content | ||
|- | |- | ||
|[[FieldContentButton|Static button]] | |[[FieldContentButton|Static button]] | ||
| | |Buttom with functionality | ||
|- | |- | ||
|[[FieldContentMessage|Static message]] | |[[FieldContentMessage|Static message]] | ||
| | |Notification on top of the page | ||
|- | |- | ||
|[[FieldContentScript|Static script]] | |[[FieldContentScript|Static script]] | ||
| | |Execution of the code when changing other boxes | ||
|- | |- | ||
|[[FieldContentFunction|Script function]] | |[[FieldContentFunction|Script function]] | ||
| | |Execution of the code with value insertion into other fields | ||
|- | |- | ||
|} | |} | ||
Line 156: | Line 159: | ||
{| | {| | ||
|[[FieldLookupListShare|Lookup (shared)]] | |[[FieldLookupListShare|Lookup (shared)]] | ||
| | |Look-up in common list of values | ||
|- | |- | ||
|[[FieldLookupListLocal|Lookup]] | |[[FieldLookupListLocal|Lookup]] | ||
| | |Look-up in local list of values | ||
|- | |- | ||
|[[FieldLookupUser|User]] | |[[FieldLookupUser|User]] | ||
| | |Users of the system. Those who are being added, can as an option be notified | ||
|- | |- | ||
|[[FieldLookupGroup|Group]] | |[[FieldLookupGroup|Group]] | ||
| | |Groups in the system. Those who are being added, can as an option be notified | ||
|- | |- | ||
|[[FieldLookupListLocalNested|Dependent list (lokal)]] | |[[FieldLookupListLocalNested|Dependent list (lokal)]] | ||
| | |Choise based on another local list | ||
|- | |- | ||
|[[FieldCategory|Dependent category]] | |[[FieldCategory|Dependent category]] | ||
| | |Categories based on value | ||
|- | |- | ||
|[[FieldLookupListLocalReplika|List replica]] | |[[FieldLookupListLocalReplika|List replica]] | ||
| | |Copi of another list (same option) | ||
|- | |- | ||
|[[FieldLookupStaticCurrency|Lookup: Currency code]] | |[[FieldLookupStaticCurrency|Lookup: Currency code]] | ||
| | |List of currency code | ||
|- | |- | ||
|[[FieldLookupUserExclusive|User Exclusive]] | |[[FieldLookupUserExclusive|User Exclusive]] | ||
| | |User from af certain Exclusive group | ||
|- | |- | ||
|[[FieldVariant|Variant selector]] | |[[FieldVariant|Variant selector]] | ||
| | |List of types, which are controlling which other boxes are being showed | ||
|- | |- | ||
|[[FieldRemoteKey|Database: Opslag indtastning]] | |[[FieldRemoteKey|Database: Opslag indtastning]] | ||
| | |Look-up of values in foreign database | ||
|- | |- | ||
|[[FieldRemoteKeyLookup|Database: Opslag liste valg]] | |[[FieldRemoteKeyLookup|Database: Opslag liste valg]] | ||
| | |Table of values from foreign | ||
|- | |- | ||
|[[FieldSubselect|SQL: Subselect]] | |[[FieldSubselect|SQL: Subselect]] | ||
| | |Enquiry in own or foreign database | ||
|- | |- | ||
Line 231: | Line 234: | ||
|[[FieldReplicate|Value copy]] | |[[FieldReplicate|Value copy]] | ||
| | |Showing other values based on a key | ||
|- | |- | ||
|[[FieldReplicateText|Value copy (text)]] | |[[FieldReplicateText|Value copy (text)]] | ||
| | |Coping TEXT value based on key (searchable) | ||
|- | |- | ||
|[[FieldReplicateInteger|Value copy (heltal)]] | |[[FieldReplicateInteger|Value copy (heltal)]] | ||
| | |Coping INTEGER value based on key (searchable) | ||
|- | |- | ||
|[[FieldReplicateDecimal|Value copy (decimal)]] | |[[FieldReplicateDecimal|Value copy (decimal)]] | ||
| | |Coping DECIMAL value based on key (searchable) | ||
|- | |- | ||
|[[FieldReplicateBoolean|Value copy (yes/no)]] | |[[FieldReplicateBoolean|Value copy (yes/no)]] | ||
| | |Coping Yes/No values based on key (searchable) | ||
|- | |- | ||
|[[FieldReplicateDate|Value copy (date)]] | |[[FieldReplicateDate|Value copy (date)]] | ||
| | |Coping DATE values based on key (searchable) | ||
|- | |- | ||
|[[FieldReplicateCPR|Value copy (cpr)]] | |[[FieldReplicateCPR|Value copy (cpr)]] | ||
| | |Coping CPR number based on key (searchable) | ||
|- | |- | ||
|} | |} | ||
Line 271: | Line 275: | ||
{| | {| | ||
|[[FieldAjaxPostalcode|Lookup: Postnr / by]] | |[[FieldAjaxPostalcode|Lookup: Postnr / by]] | ||
| | |Autofilling of postal number and city | ||
|- | |- | ||
|[[FieldAjaxUNSPSC|Lookup: UNSPSC]] | |[[FieldAjaxUNSPSC|Lookup: UNSPSC]] | ||
| | |Autofilling of the product category system of UN | ||
|- | |- | ||
|[[FieldAjaxNACE|Lookup: NACE code]] | |[[FieldAjaxNACE|Lookup: NACE code]] | ||
| | |Autofilling of NACE business codes | ||
|- | |- | ||
|[[FieldAjaxCountry|Lookup: Country]] | |[[FieldAjaxCountry|Lookup: Country]] | ||
| | |Autofilling of land | ||
|- | |- | ||
|[[FieldAjaxDiagnose|Lookup: ICD diagnose]] | |[[FieldAjaxDiagnose|Lookup: ICD diagnose]] | ||
| | |Autofilling of ICD diagnosis code | ||
|- | |- | ||
|[[FieldAjaxSksUndersoegelse|SKS Undersøgelse]] | |[[FieldAjaxSksUndersoegelse|SKS Undersøgelse]] | ||
|SKS Undersøgelse | |Dynamic lookup of values from SKS Undersøgelse | ||
|- | |- | ||
|[[FieldAjaxSksDiagnose|SKS Diagnose]] | |[[FieldAjaxSksDiagnose|SKS Diagnose]] | ||
|SKS Diagnose | |Dynamic lookup of values from SKS Diagnose | ||
|- | |- | ||
|[[FieldAjaxSksOperation|SKS Operation]] | |[[FieldAjaxSksOperation|SKS Operation]] | ||
|SKS Operation | |Dynamic lookup of values from SKS Operation | ||
|- | |- | ||
|[[FieldAjaxSksBehandling|SKS Behandling]] | |[[FieldAjaxSksBehandling|SKS Behandling]] | ||
|SKS Behandling | |Dynamic lookup of values from SKS Behandling | ||
|- | |- | ||
|[[FieldAjaxSksATC|SKS ATC]] | |[[FieldAjaxSksATC|SKS ATC]] | ||
|SKS ATC | |Dynamic lookup of values from SKS ATC | ||
|- | |- | ||
|[[FieldAjaxSksUlykke|SKS Ulykke]] | |[[FieldAjaxSksUlykke|SKS Ulykke]] | ||
|SKS Ulykke | |Dynamic lookup of values from SKS Ulykke | ||
|- | |- | ||
|[[FieldAjaxSksSygehusafdeling|SKS Afdeling]] | |[[FieldAjaxSksSygehusafdeling|SKS Afdeling]] | ||
|SKS Afdeling | |Dynamic lookup of values from SKS Afdeling | ||
|- | |- | ||
|} | |} | ||
Line 336: | Line 341: | ||
{| | {| | ||
|[[FieldFiles|Documents]] | |[[FieldFiles|Documents]] | ||
|Upload / download | |Upload / download of files including versioning | ||
|- | |- | ||
|[[FieldFilesPictures|Pictures]] | |[[FieldFilesPictures|Pictures]] | ||
| | |Photo gallery with thumbnail index | ||
|- | |- | ||
|[[FieldFilesGenerate|Document builder]] | |[[FieldFilesGenerate|Document builder]] | ||
| | |Build document base on solution file template | ||
|- | |- | ||
|[[FieldFilesShared|Filesystem files]] | |[[FieldFilesShared|Filesystem files]] | ||
|Download | |Download of local files on the intranet | ||
|- | |- | ||
|} | |} | ||
Line 361: | Line 367: | ||
{| | {| | ||
|[[FieldTable|Table]] | |[[FieldTable|Table]] | ||
| | |Table with a range of subfield | ||
|- | |- | ||
|[[FieldTask|Tasklist]] | |[[FieldTask|Tasklist]] | ||
| | |Tasklist with export to vTodo | ||
|- | |- | ||
|[[FieldContact|Contact list]] | |[[FieldContact|Contact list]] | ||
| | |Contact list with export to vCard | ||
|- | |- | ||
Line 380: | Line 386: | ||
|} | |} | ||
Line 386: | Line 393: | ||
{| | {| | ||
|[[FieldSubformList|List of children]] | |[[FieldSubformList|List of children]] | ||
| | |List of all underplaced data | ||
|- | |- | ||
|[[FieldSubformMaster|Parent reference]] | |[[FieldSubformMaster|Parent reference]] | ||
|Link / resume | |Link/resume to above placed data | ||
|- | |- | ||
|[[FieldSubformLinesSum|Calc children: Sum]] | |[[FieldSubformLinesSum|Calc children: Sum]] | ||
|Sum | |Sum of values in underplaced data | ||
|- | |- | ||
|[[FieldSubformLinesCount|Calc children: Count]] | |[[FieldSubformLinesCount|Calc children: Count]] | ||
| | |Sum of elements in underplaced data | ||
|- | |- | ||
|[[FieldSubformLinesDistinct|Calc children: Unique]] | |[[FieldSubformLinesDistinct|Calc children: Unique]] | ||
| | |Sum of unique values in underplaced data | ||
|- | |- | ||
|[[FieldSubformLinesMin|Calc children: Minimum]] | |[[FieldSubformLinesMin|Calc children: Minimum]] | ||
| | |Minimum value in underplaced data | ||
|- | |- | ||
|[[FieldSubformLinesMax|Calc children: Maximum]] | |[[FieldSubformLinesMax|Calc children: Maximum]] | ||
|Maximum | |Maximum value in underplaced data | ||
|- | |- | ||
Line 430: | Line 437: | ||
|[[ | |[[FieldSubformListStatus|List of children (status filter)]] | ||
|Filtered selection of subitems | |Filtered selection of subitems | ||
|- | |- | ||
Line 440: | Line 447: | ||
|} | |} | ||
Line 446: | Line 454: | ||
{| | {| | ||
|[[FieldMultiSelect|Checklist lookup]] | |[[FieldMultiSelect|Checklist lookup]] | ||
| | |Number of categories | ||
|- | |- | ||
|[[FieldSignature|Signature]] | |[[FieldSignature|Signature]] | ||
|Digital | |Digital signature or approval | ||
|- | |- | ||
|[[FieldCalcTest|Calc: Test value]] | |[[FieldCalcTest|Calc: Test value]] | ||
| | |Test of the value of another field | ||
|- | |- | ||
|[[FieldCalcFormula|Calc: Formula]] | |[[FieldCalcFormula|Calc: Formula]] | ||
| | |Formula based on other fields | ||
|- | |- | ||
|[[FieldCalcConcatenate|Calc: Concatenate]] | |[[FieldCalcConcatenate|Calc: Concatenate]] | ||
| | |Making a text based on values from other fields | ||
|- | |- | ||
|[[FieldCalcAge|Calc: Time lifecycle]] | |[[FieldCalcAge|Calc: Time lifecycle]] | ||
| | |Time spent since the beginning of the case or since last correction | ||
|- | |- | ||
|[[FieldCalcMeasure|Calc: Time measured]] | |[[FieldCalcMeasure|Calc: Time measured]] | ||
| | |Total waiting time | ||
|- | |- | ||
|[[FieldCalcScore|Calc: Score interval]] | |[[FieldCalcScore|Calc: Score interval]] | ||
| | |Translation of values in intervals | ||
|- | |- | ||
|[[FieldCalcTestMany|Calc: Check fields]] | |[[FieldCalcTestMany|Calc: Check fields]] | ||
| | |Check if a list of fields has been filled out | ||
|- | |- | ||
|[[FieldComplexComment|Comments]] | |[[FieldComplexComment|Comments]] | ||
| | |Entry of a list of comments from the users of the case | ||
|- | |- | ||
Line 506: | Line 514: | ||
|[[FieldXmlData|XML data]] | |[[FieldXmlData|XML data]] | ||
|XML data | |XML data in lists, table or own output format | ||
|- | |- | ||
|[[FieldBarcodeAutomation|Barcode (status change)]] | |[[FieldBarcodeAutomation|Barcode (status change)]] | ||
| | |Barcode to change status automatically | ||
|- | |- | ||
|} | |} | ||
Line 521: | Line 530: | ||
{| | {| | ||
|[[FieldSystemStatus|Status]] | |[[FieldSystemStatus|Status]] | ||
| | |The present status of the case | ||
|- | |- | ||
|[[FieldSystemDatetimeCreated|Created]] | |[[FieldSystemDatetimeCreated|Created]] | ||
| | |The creation date of the case | ||
|- | |- | ||
|[[FieldSystemDatetimeModified|Modified]] | |[[FieldSystemDatetimeModified|Modified]] | ||
| | |The change date of the case | ||
|- | |- | ||
|[[FieldSystemDatetimeCompleted|Completed]] | |[[FieldSystemDatetimeCompleted|Completed]] | ||
| | |The termination date of the case | ||
|- | |- | ||
|[[FieldSystemDatetimeStatusSet|Status set]] | |[[FieldSystemDatetimeStatusSet|Status set]] | ||
| | |The last status update of the case | ||
|- | |- | ||
|[[FieldSystemUserCreated|Created by]] | |[[FieldSystemUserCreated|Created by]] | ||
| | |User who created the case | ||
|- | |- | ||
|[[FieldSystemUserModified|Modified by]] | |[[FieldSystemUserModified|Modified by]] | ||
| | |User who modified the case | ||
|- | |- | ||
|[[FieldSystemUserCompleted|Completed by]] | |[[FieldSystemUserCompleted|Completed by]] | ||
| | |User who completed the case | ||
|- | |- | ||
|[[FieldSystemUserStatusSet|Status set by]] | |[[FieldSystemUserStatusSet|Status set by]] | ||
| | |User who updated the case | ||
|- | |- | ||
|[[FieldSystemStatusMaster|Master status]] | |[[FieldSystemStatusMaster|Master status]] | ||
| | |Masterstatus based on the status of the case | ||
|- | |- | ||
|[[FieldSystemFormType|Solution type]] | |[[FieldSystemFormType|Solution type]] | ||
| | |Selection of a solution type | ||
|- | |- | ||
|[[FieldSystemExclusiveGroup|Exclusive group]] | |[[FieldSystemExclusiveGroup|Exclusive group]] | ||
| | |Selection of an Exclusive group | ||
|- | |- | ||
|[[FieldSystemMemberList|Member list]] | |[[FieldSystemMemberList|Member list]] | ||
| | |Users with access to the element | ||
|- | |- | ||
|} | |} | ||
Line 591: | Line 601: | ||
{| | {| | ||
|[[FieldCalcAgeOnCPR|Age calc (date/CPR)]] | |[[FieldCalcAgeOnCPR|Age calc (date/CPR)]] | ||
| | |Estimating the age of the user based on date and CPR number | ||
|- | |- | ||
|[[FieldCalcBMI|Body Mass Index]] | |[[FieldCalcBMI|Body Mass Index]] | ||
| | |Estimating BMI based on height and weight | ||
|- | |- | ||
|[[FieldTrainingSurvey|Activity measure]] | |[[FieldTrainingSurvey|Activity measure]] | ||
| | |Measurement of weekly activity | ||
|- | |- | ||
|[[FieldGenderOnCPR|Gender (CPR)]] | |[[FieldGenderOnCPR|Gender (CPR)]] | ||
| | |Deduction of gender based on CPR number | ||
|- | |- | ||
|[[FieldCheckboxCollection|Checkbox counter]] | |[[FieldCheckboxCollection|Checkbox counter]] | ||
| | |Check mark of month, days or other | ||
|- | |- | ||
|[[FieldCompoundMET|MET scoreboard]] | |[[FieldCompoundMET|MET scoreboard]] | ||
| | |Measurement of month, amount and size | ||
|- | |- | ||
|} | |} | ||
Line 626: | Line 637: | ||
{| | {| | ||
|[[FieldTokenMailto|Button: Token URL builder]] | |[[FieldTokenMailto|Button: Token URL builder]] | ||
| | |Building link to external users | ||
|- | |- | ||
|[[FieldExportTemplate|Button: Export template]] | |[[FieldExportTemplate|Button: Export template]] | ||
| | |Export of data to a certain template | ||
|- | |- | ||
|[[FieldExecuteJavaScript|Button: Script execution]] | |[[FieldExecuteJavaScript|Button: Script execution]] | ||
| | |Execute script on page and/or saving data | ||
|- | |- | ||
|[[FieldParameterLookup|Button: Parameterized URL]] | |[[FieldParameterLookup|Button: Parameterized URL]] | ||
| | |Look-up in foreign webbased system | ||
|- | |- | ||
|[[FieldParameterListSearch|Button: Related list search]] | |[[FieldParameterListSearch|Button: Related list search]] | ||
| | |Look-up in related list with parameter | ||
|- | |- | ||
|[[FieldGrandChildSearch|Button: Grand child search]] | |[[FieldGrandChildSearch|Button: Grand child search]] | ||
| | |Look-up in related data (Grand children) | ||
|- | |- | ||
|[[FieldCodeunitPage|Button: Codeunit execution]] | |[[FieldCodeunitPage|Button: Codeunit execution]] | ||
| | |Execute proprietary code | ||
|- | |- | ||
|[[FieldSessionFilterSelector|Filter selector static]] | |[[FieldSessionFilterSelector|Filter selector static]] | ||
| | |Set value in user session. For example for data filters. | ||
|- | |- | ||
|} | |} | ||
Line 671: | Line 683: | ||
{| | {| | ||
|[[FieldGaugePerformance|Visual: Target gauge Total]] | |[[FieldGaugePerformance|Visual: Target gauge Total]] | ||
| | |Show lifetime performance speedometer | ||
|- | |- | ||
|[[FieldGaugePerformanceStep|Visual: Target gauge Step]] | |[[FieldGaugePerformanceStep|Visual: Target gauge Step]] | ||
| | |Show performance speedometer for this step | ||
|- | |- | ||
|} | |} | ||
Line 686: | Line 699: | ||
{| | {| | ||
|[[FieldComplexQuestionIndex|Word heatmap index]] | |[[FieldComplexQuestionIndex|Word heatmap index]] | ||
| | |Specialised index field only showned in reports | ||
|- | |- | ||
|[[FieldComplexQuestion|Question and answer]] | |[[FieldComplexQuestion|Question and answer]] | ||
| | |Complex question with recommendation, numerical score and coloring | ||
|- | |- | ||
|[[FieldComplexQuestionWillis|Complex question]] | |[[FieldComplexQuestionWillis|Complex question]] | ||
| | |Complex question with recommendation, numerical score and coloring | ||
|- | |- | ||
|[[FieldComplexQuestionMultiLocation|Multiline: Complex question]] | |[[FieldComplexQuestionMultiLocation|Multiline: Complex question]] | ||
| | |MULTIPLE LOCATION: Complex question | ||
|- | |- | ||
|[[FieldMultiLocation|Multiline: Location editor]] | |[[FieldMultiLocation|Multiline: Location editor]] | ||
| | |MULTIPLE LOCATION: Name of location | ||
|- | |- | ||
|[[FieldYearRepeatCompare|Year comparator]] | |[[FieldYearRepeatCompare|Year comparator]] | ||
| | |Comparing fields from previous years | ||
|- | |- | ||
|[[FieldCalcFormulaWillis|Calc: Complex question (sum)]] | |[[FieldCalcFormulaWillis|Calc: Complex question (sum)]] | ||
| | |Formula based on other fields | ||
|- | |- | ||
|[[FieldMissingValues|Calc: Count missing fields]] | |[[FieldMissingValues|Calc: Count missing fields]] | ||
| | |Number of missing fields in a form or questionaire | ||
|- | |- | ||
|} | |} |
Revision as of 15:50, 13 March 2013
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 |
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 | Copi 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) |
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 |
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
List of children | List of all underplaced data |
Parent reference | Link/resume to above placed data |
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 |
List of children (type filter) | For use with 'Children type selector' |
Children type selector (type filer) | For use with 'List of children (type)' |
List of children (status filter) | Filtered selection of subitems |
List of children (select fields) | Filtered selection of fields including sortorder |
Complex
Checklist lookup | Number of categories |
Signature | Digital signature or approval |
Calc: Test value | Test of the value of another field |
Calc: Formula | Formula based on other fields |
Calc: Concatenate | Making a text based on values from other fields |
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 |
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 |
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 |
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 |
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 |