This shows you the differences between two versions of the page.
— |
en:datatyyp [2022/06/28 14:38] (current) triinp created |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Datafield types ====== | ||
+ | |||
+ | ===== 1. Settings ===== | ||
+ | |||
+ | Datafields are located ''Settings -> Common settings -> Datafield types''. By pressing „F2-ADD NEW“ can create a new datafield. | ||
+ | |||
+ | {{:et:triinp20220509-101643.png}} | ||
+ | |||
+ | An empty datafield card opens: | ||
+ | |||
+ | **Code** - datafield code | ||
+ | |||
+ | {{:et:triinp20220628-134223.png}} | ||
+ | |||
+ | **Name** - datafield name, it also goes to the document as the name of the datafield. | ||
+ | |||
+ | **Class** - indicates on which document this datafield goes to. If you select "Common", this datafield can be used for all documents in the list. | ||
+ | {{:et:triinp20220510-093238.png}} | ||
+ | |||
+ | **Visible by default** - can be set whether this datafield is immediately visible on the document or should be added from the drop-down menu. | ||
+ | {{:et:triinp20220510-093120.png}} | ||
+ | |||
+ | **Warn if not filled** - can be set whether a warning is displayed, a warning is not displayed or a warning is displayed and document cant be saved if this field is left blank. | ||
+ | {{:et:triinp20220510-093350.png}} | ||
+ | |||
+ | **Order** - can be set in which order datafields are placed on document. For example, if 1 is marked in this datafield cell, it would always be the first datafield. \\ :!: Different levels datafields must be sorted from smaller to larger and must be set to visible by default when datafields are related. | ||
+ | |||
+ | **Type** - sets datafield type. If the Type cell is left blank, any content can be written in the datafield. If Type: Text is selected, different text can also be written to this datafield, but this type creates placeholder from the tabel ''Settings -> Common settings -> Auto text''. If Type: Item is selected, you can select an item from item browser by double-clicking in the the document datafield cell. Other options work by the same logic. | ||
+ | {{:et:triinp20220509-123126.png}} | ||
+ | * **Date**: date/time type datafield, right click on datafield opens calendar \\ | ||
+ | * **Item**, **Supplier**, **User**, **Customer asset**, **Customer**, **Contact**, **Object**, **Project**, **Text** are text type datafield, which opens corresponding placeholder with double-click or right-click. \\ | ||
+ | * **Number**: number type datafield, gives warning when entering text \\ | ||
+ | * **Related**: several datafields can be related and the contents depend on each other's choices. Defined in the module [[et:yld_lisavaljad_seosed|Lisaväljade Seosed]] and configured using the **Limitation** field. \\ | ||
+ | * **Pulldown**: datafield with predefined options \\ | ||
+ | |||
+ | |||
+ | **Limitation** - according to the type **Related** and **Pulldown** type datafield can be defined here. \\ | ||
+ | * Related - the related code is defined here and the format of the multi-level datafield is CODE: level, for example CARS:1 \\ | ||
+ | * Pulldown - option list separated with commas \\ :!: If an empty selection is required, the content should start with a comma. For example ,Dog, Cat, Pig \\ | ||
+ | |||
+ | **Unique** - the contents may appear only once in the register or whether one datafield can be used twice in a single document or not - otherwise a warning. | ||
+ | {{:et:triinp20220509-140138.png}} | ||
+ | |||
+ | **Colour** - possible to choose what colour the datafield is on the document. | ||
+ | {{:et:triinp20220628-134958.png}} | ||
+ | |||
+ | **Mandatory format** | ||
+ | {{:et:triinp20220628-135050.png}} | ||
+ | * **Format**: [[http://www.w3schools.com/jsref/jsref_obj_regexp.asp|JavaScript RegExp]] format description of the allowed format. For example only number is allowed to enter: number<code>^[0-9]+[:][0-9]+$</code> | ||
+ | * **Format guide/example**: A human language guide that is displayed when content is entered in the wrong format<code>xxxx:yyyy</code> | ||
+ | |||
+ | The datafield made in the example would look like this on the document: | ||
+ | {{:et:anita20200617-142218.png}} | ||
+ | |||
+ | |||
+ | ===== 2. Examples of using datafields ===== | ||
+ | |||
+ | ==== 2.1. Filled/Empty datafield - type PULLDOWN ==== | ||
+ | |||
+ | {{:et:triinp20220510-105237.png}} | ||
+ | |||
+ | **For datafield pulldowns** | ||
+ | * Empty fields are searched by selecting Empty. | ||
+ | * All filled fields at once can get with the Filled option | ||
+ | |||
+ | **Excluding multiple options from datafield pulldown** | ||
+ | |||
+ | Example: if you want to see datafields and exclude a few options from the pulldown | ||
+ | {{:et:triinp20220510-105346.png}} | ||
+ | |||
+ | |||
+ | |||
+ | |||
+ | ==== 2.2. Filled/Empty datafield - type TEXT ==== | ||
+ | |||
+ | **Option EMPTY - type text** | ||
+ | |||
+ | If a datafield is written as text, an empty field is excluded with the empty field exclusion character described in the system settings | ||
+ | |||
+ | {{:et:triinp20220509-150713.png}} | ||
+ | {{:et:triinp20220509-150831.png}} | ||
+ | |||
+ | |||
+ | **Option FILLED- type text** | ||
+ | |||
+ | {{:et:triinp20220509-151143.png}} | ||
+ | |||
+ | |||