User Tools

Site Tools



en:datatyyp
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


en:datatyyp [2022/06/28 14:38] (current) – created triinp
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}}
 +
 +
  
en/datatyyp.txt · Last modified: 2022/06/28 14:38 by triinp

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki