Difference between revisions of "Field type reference"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
 
(39 intermediate revisions by 4 users not shown)
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]]
|Hele tal med fortegn
|Integer value
|-
|-




|[[FieldNumberDecimal|Decimal]]
|[[FieldNumberDecimal|Decimal]]
|Komma tal
|Numbers with decimal comma
|-
|-




|[[FieldNumberDecimalPercent|Percentage]]
|[[FieldNumberDecimalPercent|Percentage]]
|Procent
|Percentage value (decimal)
|-
|-




|[[FieldNumberBoolean|Yes/No]]
|[[FieldNumberBoolean|Yes/No]]
|Afkrysningsfelt. Ja / Nej værdierne kan vises med andre ord eller ikoner
|Check box. Yes/No. The values can be shown with other words or icons
|-
|-




|[[FieldSerial|Serial]]
|[[FieldSerial|Serial]]
|Unikt serienummer
|Unique serial number
|-
|-




|[[FieldNumberIntegerResponse|Response]]
|[[FieldNumberIntegerResponse|Response]]
|Interval i spørgeskema
|Interval in questionnaire
|-
|-




|[[FieldNumberIntegerEnumeration|Enumeration]]
|[[FieldNumberIntegerEnumeration|Enumeration]]
|Navngivne tal f.eks. karakterer
|Named numbers ex. Grades
|-
|-




|[[FieldNumberIntegerGlyph|Symbol]]
|[[FieldNumberIntegerGlyph|Symbol]]
|Brug ikoner for status flow og kategorier
|Use icons as status flow and categories
|-
|-




|[[FieldTimeDate|Date]]
|[[FieldTimeDate|Date]]
|Dato med kalender opslag
|Date with calendar look-up
|-
|-




|[[FieldTimeTime|Time]]
|[[FieldTimeTime|Time]]
|Tidspunkts vælger
|Selector for point in time
|-
|-




|[[FieldTimeDatetime|Datetime]]
|[[FieldTimeDatetime|Datetime]]
|Dato med kalender / ur opslag
|Date with calendar/time look-up
|-
|-




|[[FieldTimePartMonth|Month]]
|[[FieldTimePartMonth|Month]]
|Valg af måned
|Choice of month, including translation
|-
|-




|[[FieldTimePartYear|Year]]
|[[FieldTimePartYear|Year]]
|Valg af år
|Choice of year
|-
|-




|[[FieldText|Text]]
|[[FieldText|Text]]
|En linjes tekst (f.eks. navn)
|A single line of a text (ex. Name)
|-
|-




|[[FieldTextMemo|Text mulitline]]
|[[FieldTextMemo|Text mulitline]]
|Flere tekstlinjer (f.eks. addresser)
|Mulible line of text (ex. Adresses)
|-
|-




|[[FieldTextMemoEditor|Notepad]]
|[[FieldTextMemoEditor|Notepad]]
|Skriveprogram vist i grænsefladen
|Editor shown in the interface
|-
|-




|[[FieldTextHieraki|Hierachy/tree]]
|[[FieldTextHieraki|Hierachy/tree]]
|Hieraki af værdier
|Hierarchy of values
|-
|-




|[[FieldTextEmail|Email]]
|[[FieldTextEmail|Email]]
|Email addrese på bruger
|User email-adress
|-
|-




|[[FieldTextURL|Website (URL)]]
|[[FieldTextURL|Website (URL)]]
|Addresse på internettet
|Internet adress
|-
|-




|[[FieldUniqueIdentity|Unique key (GUID)]]
|[[FieldUniqueIdentity|Unique key (GUID)]]
|Garanteret unik værdi. Benytter GUID hvis ikke andet leveres.
|Global Unique ID (GUID) for records, inserted automatically on record creation.
|-
|-




|[[FieldTextSuggest|Text with lookup]]
|[[FieldTextSuggest|Text with lookup]]
|En linje tekst med opslag i eksisterende værdier
|A single line text with look-up in exciting values
|-
|-




|[[FieldTextPhone|Phone]]
|[[FieldTextPhone|Phone]]
|Telefonnummer med mulighed for opslag
|phone number with the possibility for look-up
|-
|-




|[[FieldTextCPR|CPR nummer]]
|[[FieldTextCPR|CPR nummer]]
|CPR nr ved validering af kontrol ciffer
|validation of control digits with the personal identification number
|-
|-




|[[FieldTextCVR|CVR nummer]]
|[[FieldTextCVR|CVR nummer]]
|Firmanummer med opslag i CVR registeret
|CVR number with look-up in the CVR register
|-
|-




|[[FieldContentStatic|Static content]]
|[[FieldContentStatic|Static content]]
|Visning af diverse indhold
|Read-out of various content
|-
|-




|[[FieldContentButton|Static button]]
|[[FieldContentButton|Static button]]
|Knap med funktionalitet
|Buttom with functionality
|-
|-




|[[FieldContentMessage|Static message]]
|[[FieldContentMessage|Static message]]
|Besked på toppen af siden
|Notification on top of the page
|-
|-




|[[FieldContentScript|Static script]]
|[[FieldContentScript|Static script]]
|Eksekvering af kode ved ændringer af andre felter
|Execution of the code when changing other boxes
|-
|-




|[[FieldContentFunction|Script function]]
|[[FieldContentFunction|Script function]]
|Eksekvering af kode med svar til andet felt
|Execution of the code with value insertion into other fields
|-
 
 
|[[FieldTextSuggest|A line of text with lookup on existing values]]
|A line of text with lookup on existing values
|-
|-


|}
 
|[[FieldNumberIntegerPriority|Prioritize cases among themselves directly from lists]]
|Prioritize cases among themselves directly from lists
|-




|}


==Lookup==
==Lookup==
{|
{|
|[[FieldLookupListShare|Lookup (shared)]]
|[[FieldLookupListShare|Lookup (shared)]]
|Opslag i fælles værdiliste
|Look-up in common list of values
|-
|-




|[[FieldLookupListLocal|Lookup]]
|[[FieldLookupListLocal|Lookup]]
|Opslag i lokal værdiliste
|Look-up in local list of values
|-
|-




|[[FieldLookupUser|User]]
|[[FieldLookupUser|User]]
|Bruger af systemet. Som option kan dem der tilføjes notificeres.
|Users of the system. Those who are being added, can as an option be notified
|-
|-




|[[FieldLookupGroup|Group]]
|[[FieldLookupGroup|Group]]
|Gruppe i systemet. Som option kan dem der tilføjes notificeres.
|Groups in the system. Those who are being added, can as an option be notified
|-
|-




|[[FieldLookupListLocalNested|Dependent list (lokal)]]
|[[FieldLookupListLocalNested|Dependent list (lokal)]]
|Valg baseret på anden LOKAL liste
|Choise based on another local list
|-
|-




|[[FieldCategory|Dependent category]]
|[[FieldCategory|Dependent category]]
|Kategori på baggrund af værdi
|Categories based on value
|-
|-




|[[FieldLookupListLocalReplika|List replica]]
|[[FieldLookupListLocalReplika|List replica]]
|Kopi af anden liste (samme svarmuligheder)
|Copy of another list (same option)
|-
|-




|[[FieldLookupStaticCurrency|Lookup: Currency code]]
|[[FieldLookupStaticCurrency|Lookup: Currency code]]
|Liste af valuta koder
|List of currency code
|-
|-




|[[FieldLookupUserExclusive|User Exclusive]]
|[[FieldLookupUserExclusive|User Exclusive]]
|Bruger fra sagens ejergruppe eller beslægtet med aktiv bruger
|User from af certain Exclusive group
|-
|-




|[[FieldVariant|Variant selector]]
|[[FieldVariant|Variant selector]]
|Liste af varianter der styrer hvilke andre felter der vises
|List of types, which are controlling which other boxes are being showed
|-
|-




|[[FieldRemoteKey|Database: Opslag indtastning]]
|[[FieldRemoteKey|Database: Opslag indtastning]]
|Opslag af værdi i fremmed database
|Look-up of values in foreign database
|-
|-




|[[FieldRemoteKeyLookup|Database: Opslag liste valg]]
|[[FieldRemoteKeyLookup|Database: Opslag liste valg]]
|Tabel af værdier fra fremmed database
|Table of values from foreign
|-
|-




|[[FieldSubselect|SQL: Subselect]]
|[[FieldSubselect|SQL: Subselect]]
|Forespørgsel i egen eller fremmed database
|Enquiry in own or foreign database
|-
|-


Line 231: Line 242:


|[[FieldReplicate|Value copy]]
|[[FieldReplicate|Value copy]]
|Viser andre værdier baseret på en nøgle
|Showing other values based on a key
|-
|-




|[[FieldReplicateText|Value copy (text)]]
|[[FieldReplicateText|Value copy (text)]]
|Kopier TEXT værdi baseret på nøgle (søgbar)
|Coping TEXT value based on key (searchable)
|-
|-




|[[FieldReplicateInteger|Value copy (heltal)]]
|[[FieldReplicateInteger|Value copy (heltal)]]
|Kopier HELTAL værdi baseret på nøgle (søgbar)
|Coping INTEGER value based on key (searchable)
|-
|-




|[[FieldReplicateDecimal|Value copy (decimal)]]
|[[FieldReplicateDecimal|Value copy (decimal)]]
|Kopier DECIMAL værdi baseret på nøgle (søgbar)
|Coping DECIMAL value based on key (searchable)
|-
|-




|[[FieldReplicateBoolean|Value copy (yes/no)]]
|[[FieldReplicateBoolean|Value copy (yes/no)]]
|Kopier Ja/Nej værdi baseret på nøgle (søgbar)
|Coping Yes/No values based on key (searchable)
|-
|-




|[[FieldReplicateDate|Value copy (date)]]
|[[FieldReplicateDate|Value copy (date)]]
|Kopier DATO værdi baseret på nøgle (søgbar)
|Coping DATE values based on key (searchable)
|-
|-




|[[FieldReplicateCPR|Value copy (cpr)]]
|[[FieldReplicateCPR|Value copy (cpr)]]
|Kopier CPR nummer baseret på nøgle (søgbar)
|Coping CPR number based on key (searchable)
|-
 
 
|[[FieldLookupListLocalNestedReplika|Copy field lookup options for another field in this solution]]
|Copy field lookup options for another field in this solution
|-
|-


|}
 
|[[FieldLookupUserExclusive|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 AJAX==
{|
{|
|[[FieldAjaxPostalcode|Lookup: Postnr / by]]
|[[FieldAjaxPostalcode|Lookup: Postnr / by]]
|Autoudfyldning af postnummer og by
|Autofilling of postal number and city
|-
|-




|[[FieldAjaxUNSPSC|Lookup: UNSPSC]]
|[[FieldAjaxUNSPSC|Lookup: UNSPSC]]
|Autoudfyldning af FN's produkt kategori system
|Autofilling of the product category system of UN
|-
|-




|[[FieldAjaxNACE|Lookup: NACE code]]
|[[FieldAjaxNACE|Lookup: NACE code]]
|Autoudfyldning af NACE branche koder
|Autofilling of NACE business codes
|-
|-




|[[FieldAjaxCountry|Lookup: Country]]
|[[FieldAjaxCountry|Lookup: Country]]
|Autoudfyldning af land
|Autofilling of land
|-
|-




|[[FieldAjaxDiagnose|Lookup: ICD diagnose]]
|[[FieldAjaxDiagnose|Lookup: ICD diagnose]]
|Autoudfyldniung af ICD diagnose kode
|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 357:
{|
{|
|[[FieldFiles|Documents]]
|[[FieldFiles|Documents]]
|Upload / download af filer
|Upload / download of files including versioning
|-
|-




|[[FieldFilesPictures|Pictures]]
|[[FieldFilesPictures|Pictures]]
|Visning af billeder i album
|Photo gallery with thumbnail index
|-
|-




|[[FieldFilesGenerate|Document builder]]
|[[FieldFilesGenerate|Document builder]]
|Generer dokument baseret sagen øvrige oplysninger og gemmer på sagen
|Build document base on solution file template
|-
|-




|[[FieldFilesShared|Filesystem files]]
|[[FieldFilesShared|Filesystem files]]
|Download af lokale filer på intranet
|Download of local files on the intranet
|-
 
 
|[[FieldFilesSigning|Documents with signing]]
|Documents with integration to DocuSign
|-
 
 
|[[FieldReplicateFiles|Copy list of files based on key]]
|Copy list of files based on key
|-
|-


|}
 
|[[FieldFilesSharedFtp|FTP / download helper for structures and large files]]
|FTP / download helper for structures and large files
|-




|}


==Tabular data==
==Tabular data==
{|
{|
|[[FieldTable|Table]]
|[[FieldTable|Table]]
|Tabel med en række underfelter
|Table with a range of subfield
|-
|-




|[[FieldTask|Tasklist]]
|[[FieldTask|Tasklist]]
|Liste med opgaver med eksport til vTodo
|Tasklist with export to vTodo
|-
|-




|[[FieldContact|Contact list]]
|[[FieldContact|Contact list]]
|Liste af kontaktoplysninger med export til vCard
|Contact list with export to vCard
|-
|-


Line 380: Line 415:


|}
|}




Line 385: Line 421:
==Parent/child==
==Parent/child==
{|
{|
|[[FieldSubformMaster|Parent reference]]
|Link/resume to above placed data
|-
|[[FieldSubformList|List of children]]
|[[FieldSubformList|List of children]]
|Liste af alle understillede data
|List of all underplaced data
|-
 
|[[FieldSubformListStatus|List of children (status filter)]]
|Filtered selection of subitems
|-
|-




|[[FieldSubformMaster|Parent reference]]
|[[FieldSubformListFieldSelection|List of children (select fields)]]
|Link / resume til overstillede data
|Filtered selection of fields including sortorder
|-
 
|[[FieldSubformListVariant|List of children (type filter)]]
|For use with 'Children type selector'
|-
|-


|[[FieldSubformVariant|Children type selector (type filer)]]
|For use with 'List of children (type)'
|-


|[[FieldSubformLinesSum|Calc children: Sum]]
|[[FieldSubformLinesSum|Calc children: Sum]]
|Sum af værdier i underformularer
|Sum of values in underplaced data
|-
|-




|[[FieldSubformLinesCount|Calc children: Count]]
|[[FieldSubformLinesCount|Calc children: Count]]
|Antal elementer i underformular
|Sum of elements in underplaced data
|-
|-




|[[FieldSubformLinesDistinct|Calc children: Unique]]
|[[FieldSubformLinesDistinct|Calc children: Unique]]
|Antal unikke værdier i underformular
|Sum of unique values in underplaced data
|-
|-




|[[FieldSubformLinesMin|Calc children: Minimum]]
|[[FieldSubformLinesMin|Calc children: Minimum]]
|Mimimum værdi i underformular
|Minimum value in underplaced data
|-
|-




|[[FieldSubformLinesMax|Calc children: Maximum]]
|[[FieldSubformLinesMax|Calc children: Maximum]]
|Maximum værdi i underformular
|Maximum value in underplaced data
|-
|-




|[[FieldSubformListVariant|List of children (type filter)]]
|[[FieldManyToMany|Many records pointing to many other records]]
|For use with 'Children type selector'
|Many records pointing to many other records
|-
 
 
|[[FieldSubformVariant|Children type selector (type filer)]]
|For use with 'List of children (type)'
|-
|-




|[[with link to list representation.|List of children (status filter)]]
|[[FieldSharedParentRecord|Not written]]
|Filtered selection of subitems
|Parent reference(shared)
|-
|-


|[[FieldSubformListFieldSelection|List of children (select fields)]]
|Filtered selection of fields including sortorder
|-


|}
|}


==Complex==
==Complex==
{|
{|
|[[FieldMultiSelect|Checklist lookup]]
|[[FieldMultiSelect|Checklist lookup]]
|Antal af kategorier
|Number of categories
|-
|-




|[[FieldSignature|Signature]]
|[[FieldSignature|Signature]]
|Digital underskrivning eller godkendelse
|Digital signature or approval
|-
|-




|[[FieldCalcTest|Calc: Test value]]
|[[FieldCalcFormula|Calc: Formula]]
|Tester af værdien af et andet felt
|Formula based on other fields
|-
|-


 
|[[FieldCalcTest|Calc: Test value]]
|[[FieldCalcFormula|Calc: Formula]]
|Test of the value of another field
|Formel baseret på andre felter
|-
|-


|[[FieldCalcConcatenate|Calc: Concatenate]]
|[[FieldCalcConcatenate|Calc: Concatenate]]
|Laver en tekst udfra værdier i andre felter
|Making a test based on values from other fields
|-
|-


|[[FieldJavaScripting|Calc: JavaScript]]
|Executing Javascripts client AND serverside
|-


|[[FieldCalcAge|Calc: Time lifecycle]]
|[[FieldCalcAge|Calc: Time lifecycle]]
|Medgået tid siden sagens sidste oprettelse eller ændring
|Time spent since the beginning of the case or since last correction
|-
|-




|[[FieldCalcMeasure|Calc: Time measured]]
|[[FieldCalcMeasure|Calc: Time measured]]
|Samlet ventetid på sagen
|Total waiting time
|-
|-




|[[FieldCalcScore|Calc: Score interval]]
|[[FieldCalcScore|Calc: Score interval]]
|Oversættelse af værdier i intervaller
|Translation of values in intervals
|-
|-




|[[FieldCalcTestMany|Calc: Check fields]]
|[[FieldCalcTestMany|Calc: Check fields]]
|Tester om en liste af felter har udfyldte værdier
|Check if a list of fields has been filled out
|-
|-




|[[FieldComplexComment|Comments]]
|[[FieldComplexComment|Comments]]
|Indtastning af en liste af kommentarer fra sagens behandlere
|Entry of a list of comments from the users of the case
|-
|-


Line 506: Line 549:


|[[FieldXmlData|XML data]]
|[[FieldXmlData|XML data]]
|XML data i lister tabeller eller eget output format
|XML data in lists, table or own output format
|-
|-




|[[FieldBarcodeAutomation|Barcode (status change)]]
|[[FieldBarcodeAutomation|Barcode (status change)]]
|Stregkode til at skifte status automatisk
|Barcode to change status automatically
|-
 
|[[FieldSqlData|Display grid of values from local database table]]
|Display grid of values from local database table
|-
 
 
|[[FieldCalcTestFlag|Not written]]
|Calc: Flag
|-
 
|[[FieldPageRequest|Output in subforms from other searches and statistics]]
|Output in subforms from other searches and statistics
|-
 
 
|[[FieldCalcMessage|Selective text composition (EXPERIMENTAL)]]
|Selective text composition (EXPERIMENTAL)
|-
|-


|}
 
|[[FieldMultiInputSubformListSQL|Fill multiple lines with numbers (decimals)]]
|Fill multiple lines with numbers (decimals)
|-
 
 
|[[FieldTokenShow|Show token to a specific interface]]
|Show token to a specific interface
|-
 
 
|[[FieldDatabaseScript|Run script]]
|Run script
|-
 
 




|}


==System==
==System==
{|
{|
|[[FieldSystemStatus|Status]]
|[[FieldSystemStatus|Status]]
|Sagens nuværende status
|The present status of the case
|-
|-




|[[FieldSystemDatetimeCreated|Created]]
|[[FieldSystemDatetimeCreated|Created]]
|Sagens oprettelsesdato (udfyldes automatisk)
|The creation date of the case
|-
|-




|[[FieldSystemDatetimeModified|Modified]]
|[[FieldSystemDatetimeModified|Modified]]
|Sagens sidste ændringsdato (udfyldes automatisk)
|The change date of the case
|-
|-




|[[FieldSystemDatetimeCompleted|Completed]]
|[[FieldSystemDatetimeCompleted|Completed]]
|Sagens afslutningsdato (udfyldes automatisk)
|The termination date of the case
|-
|-




|[[FieldSystemDatetimeStatusSet|Status set]]
|[[FieldSystemDatetimeStatusSet|Status set]]
|Sagens sidste status opdatering
|The last status update of the case
|-
|-




|[[FieldSystemUserCreated|Created by]]
|[[FieldSystemUserCreated|Created by]]
|Bruger der oprettede sagen (udfyldes automatisk)
|User who created the case
|-
|-




|[[FieldSystemUserModified|Modified by]]
|[[FieldSystemUserModified|Modified by]]
|Bruger der rettede sagen sidst (udfyldes automatisk)
|User who modified the case
|-
|-




|[[FieldSystemUserCompleted|Completed by]]
|[[FieldSystemUserCompleted|Completed by]]
|Bruger der lukkede sagen (udfyldes automatisk)
|User who completed the case
|-
|-




|[[FieldSystemUserStatusSet|Status set by]]
|[[FieldSystemUserStatusSet|Status set by]]
|Bruger der opdaterede status
|User who updated the case
|-
|-




|[[FieldSystemStatusMaster|Master status]]
|[[FieldSystemStatusMaster|Master status]]
|Metastatus baseret på sagen 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]]
|Vælg af gensidigt udelukkende gruppe for sagen
|Selection of an Exclusive group
|-
|-




|[[FieldSystemMemberList|Member list]]
|[[FieldSystemMemberList|Member list]]
|Brugere med adgang til element
|Users with access to the element
|-
 
 
|[[FieldSystemRevision|Not written]]
|FieldSystemRevision
|-
 
 
|[[FieldUserPermission|Not written]]
|FieldUserPermission
|-
|-


|}




|[[FieldSystemMemberGroupList|Groups with access to element]]
|Groups with access to element
|-
|}


==Medico==
==Medico==
{|
{|
|[[FieldCalcAgeOnCPR|Age calc (date/CPR)]]
|[[FieldCalcAgeOnCPR|Age calc (date/CPR)]]
|Beregner brugerens alder baseret på dato og CPR nummer
|Estimating the age of the user based on date and CPR number
|-
|-




|[[FieldCalcBMI|Body Mass Index]]
|[[FieldCalcBMI|Body Mass Index]]
|Beregner BMI udfra højde og vægt
|Estimating BMI based on height and weight
|-
|-




|[[FieldTrainingSurvey|Activity measure]]
|[[FieldTrainingSurvey|Activity measure]]
|Måling af ugentlig aktivitet
|Measurement of weekly activity
|-
|-




|[[FieldGenderOnCPR|Gender (CPR)]]
|[[FieldGenderOnCPR|Gender (CPR)]]
|Udledning af køn fra CPR cifre
|Deduction of gender based on CPR number
|-
|-




|[[FieldCheckboxCollection|Checkbox counter]]
|[[FieldCheckboxCollection|Checkbox counter]]
|Afkrydsning af måneder dage eller andet
|Check mark of month, days or other
|-
|-




|[[FieldCompoundMET|MET scoreboard]]
|[[FieldCompoundMET|MET scoreboard]]
|Måling af måneder antal og omfang
|Measurement of month, amount and size
|-
|-


|}
|}




Line 626: Line 718:
{|
{|
|[[FieldTokenMailto|Button: Token URL builder]]
|[[FieldTokenMailto|Button: Token URL builder]]
|Opbygger link til eksterne brugere
|Building link to external users
|-
|-




|[[FieldExportTemplate|Button: Export template]]
|[[FieldExportTemplate|Button: Export template]]
|Eksporterer data til en bestemt template
|Export of data to a certain template
|-
|-




|[[FieldExecuteJavaScript|Button: Script execution]]
|[[FieldExecuteJavaScript|Button: Script execution]]
|Eksekverer script på siden og/eller gemmer data
|Execute script on page and/or saving data
|-
|-




|[[FieldParameterLookup|Button: Parameterized URL]]
|[[FieldParameterLookup|Button: Parameterized URL]]
|Opslag i fremmed webaseret system
|Look-up in foreign webbased system
|-
|-




|[[FieldParameterListSearch|Button: Related list search]]
|[[FieldParameterListSearch|Button: Related list search]]
|Opslag i relateret lsite med parametre
|Look-up in related list with parameter
|-
|-




|[[FieldGrandChildSearch|Button: Grand child search]]
|[[FieldGrandChildSearch|Button: Grand child search]]
|Opslag i relaterede data (børnebørn)
|Look-up in related data (Grand children)
|-
|-




|[[FieldCodeunitPage|Button: Codeunit execution]]
|[[FieldCodeunitPage|Button: Codeunit execution]]
|Ekskvering af egenudviklet kode
|Execute proprietary code
|-
|[[FieldStateChanger|Button: Status changer]]
|Change state via button-click
|-
|-




|[[FieldSessionFilterSelector|Filter selector static]]
|[[FieldSessionFilterSelector|Filter selector static]]
|
|Set value in user session. For example for data filters.
|-
|-


|}
|}




Line 671: Line 767:
{|
{|
|[[FieldGaugePerformance|Visual: Target gauge Total]]
|[[FieldGaugePerformance|Visual: Target gauge Total]]
|Vis performance speedometer for levetid
|Show lifetime performance speedometer
|-
|-




|[[FieldGaugePerformanceStep|Visual: Target gauge Step]]
|[[FieldGaugePerformanceStep|Visual: Target gauge Step]]
|Vis performance speedometer for dette trin
|Show performance speedometer for this step
|-
 
|[[FieldCanvasDrawing|Canvas: Freehand]]
|Draw anything in a box
|-
|-


|}
|[[FieldCanvasMarking|Canvas: Marking]]
|Mark a spot on an image
|-


|[[FieldSliderBarDecimal|Visual: Sliderbar]]
|Sliderbar for integer or decimal input
|-
|[[FieldSubselectDiagram|SQL: Diagram query]]
|Show the result of an SQL-query as a graph
|-


|}


==Extension==
==Extension==
{|
{|
|[[FieldComplexQuestionIndex|Word heatmap index]]
|[[FieldComplexQuestionIndex|Word heatmap index]]
|Specialiseret index felt der kun vises i rapporter
|Specialised index field only showned in reports
|-
|-




|[[FieldComplexQuestion|Question and answer]]
|[[FieldComplexQuestion|Question and answer]]
|Kompleks spørgsmål med anbefaling numerisk score og farvelægning
|Complex question with recommendation, numerical score and coloring
|-
|-




|[[FieldComplexQuestionWillis|Complex question]]
|[[FieldComplexQuestionWillis|Complex question]]
|Kompleks spørgsmål med anbefaling numerisk score og farvelægning
|Complex question with recommendation, numerical score and coloring
|-
|-




|[[FieldComplexQuestionMultiLocation|Multiline: Complex question]]
|[[FieldComplexQuestionMultiLocation|Multiline: Complex question]]
|Som kompleks med mange locationer
|MULTIPLE LOCATION: Complex question
|-
|-




|[[FieldMultiLocation|Multiline: Location editor]]
|[[FieldMultiLocation|Multiline: Location editor]]
|Indtastning af lokationer
|MULTIPLE LOCATION: Name of location
|-
|-




|[[FieldYearRepeatCompare|Year comparator]]
|[[FieldYearRepeatCompare|Year comparator]]
|Sammenligning af felter fra forrige år
|Comparing fields from previous years
|-
|-




|[[FieldCalcFormulaWillis|Calc: Complex question (sum)]]
|[[FieldCalcFormulaWillis|Calc: Complex question (sum)]]
|Formel baseret på andre felter
|Formula based on other fields
|-
|-




|[[FieldMissingValues|Calc: Count missing fields]]
|[[FieldMissingValues|Calc: Count missing fields]]
|Antal af ikke udfyldte felter
|Number of missing fields in a form or questionaire
|-
|-
|[[FieldTestingAgeItem|Testing: Age record]]
|Change the age of a record for testing puposes
|-
|[[FieldJobnetOccupationConceptUri|Required for jobnet integration]]
|Required for jobnet integration
|-
|[[FieldDocumentSnippetLookup|Export document content based on selected value]]
|Export document content based on selected value
|-
|[[FormComplexQuestionMultiLocationIndex|Word rapport index for multilocations]]
|Word rapport index for multilocations
|-
|[[FieldYearRepeatCompare|Comparison of fields from previous years]]
|Comparison of fields from previous years
|-


|}
|}

Latest revision as of 08:43, 2 April 2024

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
Email 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
SQL: Diagram query Show the result of an SQL-query as a graph

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
Retrieved from "https://wiki.tempusserva.dk/index.php?title=Field_type_reference&oldid=6790"