Advanced input forms

Usage 

 In TS it is possible to configure very advanced and dynamic input form behavior. The goal is to minimize the effort required to enter data, and at the same time maximize data quality. 

 In case you need step-by-step questionnaires or wizards, we recommend looking at Questionaires 

 TS has implemented more than 160 fields of various types, as documented in the  Field reference 

 Validation rules 

 Validation of field values can follow one of the following 

 

 The value is required 

 Can be validated by a Regex expression 

 Have a value within a minimum and/or maximum 

 

 Value ranges will differ according to data type 

 

 Numbers: The value 

 Text: Length of text 

 Date: Allowed years 

 Files: Number of files 

 

 Note that dependencies are resolved before validation, so in case a field is not relevant the validation rule will be ignored. 

 Instructions 

 

 Click on field

 

 Check of Validation 

 Remove check in Allow empty values 

 

 

 

 Field dependencies 

 Fields can be dependent on values in other fields. Specific values, value ranges or list of values. 

 Show SUBCATEGORY if CATEGORY contains either Foo, Bar or Foobar 

 Show field NOTES if PRICE is higher than 1000 

 In case the dependency is even more complex, an expression written in JS can be defined and linked to the field 

 Workflow dependencies 

 Fields can be dependent on the records location in the workflow governing that entity. Each status is assigned a status level. 

 Fields can then refer to the workflow model with restrictions 

 

 Status level FROM 

 Status level TO 

 

 If the status restrictions are not satisfied the field will be removed and validation requirements will be ignored. 

 Note that 0 signifies that the status level restriction is disabled. 

 Instructions 

 Learn to setup  Features/Status level dependencies 

 Lookup fields 

 TS contains a lot of specialized lookup fields that have defined datasources ready 

 

 Danish postal codes 

 Danish addresses (DAWA) 

 Countries and currencies 

 NACE codes (tree searchable) 

 UNSPSC codes 

 SKS framework (7 subtypes) 

 

 The DAWA lookup can also work together with a Google Map. Entering an address will update the map with the location, and clicking on the map will find the address. 

 Duplicate prevention 

 To ensure that the same data are not duplicated by mistake, it is possible to ensure that new records are unique based on values in one or more fields. 

 Learn to set up  Features/Duplicate prevention