Value

The «Value»  component is always located as child node directly under «Patterm» node in the Form structure tree. The «Value» component provides data from source field of the Context to target cell of the Form.  

Note: target cell for «Value» should be only located inside cell range of parent «Pattern» in the Excel-template

Properties tab: 




 

Item «Area in the template»

The item is for binding the «value» with target cell (or part of cell) of Excel-template. Here are two modes of binding.

  • Binding with target cell of Excel-template

For binding, You have to perform next steps successively:

·         Select required cell in the Excel-template;


·         Press a button  in the item «Area in the template»:

  • Binding with text mark in the Excel-template

Note: Use this mode only when you really need it, because it has low performance :

·         insert text mark into Excel-template cell, or part of the cell (for example, [ADDRESS] ) , which is placed within parent Pattern :



·      press button  in the item «Area in the template» . In the next popup-screen enter text mark [ADDRESS] :



Item «Value»

The item is for binding the «value» with any field (has an elementary data type) of the context (in other words: Context binding)
For binding, You have to press a button and then in the popup window of search-help You have to choose required field of the context: 


If you want to assign the «value» component to nested table of context, in addition is needed to specify a Table Column and Table Row from which to get the value:



·        If chosen context Field has a character type, its possible to output just any part of string instead an entire string, if needed. To output any part of string, You have to press a button and then in a popup window specify a start position and number of characters that should be outputted:


·         An option  is switching on a conversion routine (if it is assigned in DDict.) to convert a source value to an external format (for example, date conversion from '20140101' to  '01.01.2014').

 


Item «Layout options»

  • Value

        If this option is enabled, the value will be inserted to the cell regular way.

  • Formula

        If this option is enabled, the value will be interpreted as formula ( See more details here ).

  • Matrics (one char per cell) 

        If the option is switched on, each letter of the value will be placed into separate cell of the specified cell range (see gray cells in the example below): 
        
        

        Herewith, in the item «Area in the template», you should assign the «Value» to cell range (rectangle area that include several cells), on which you want to distribute the text from «Value» letter by letter:

        


        Using an «Interval» option, you can to adjust the distance between the filled cells. For example, an interval = 1 in the figure below: 

        



Item «Data validation»

By default, all Data validation properties of cell (if it is specified) will be copied "as is" from template to runtime resultant file . 

If you want to dynamically redefine Data validation properties, you should use below subitems. 


  • Attributes (From template)

        By default, all attributes will be copied "as is" from template to runtime resultant file . 
If you want to dynamically redefine some attributes you should specify context table, which contain two fields: first field is for attribute name and second field is for it's value. Note: both fields must have String or Char type. For example, you able to use standard table type CKF_FIELD_VALUE_TABLE (if it is available in your system), or it's analog. 

List of attributes
available for dynamic redefinition: 


allowBlank
error
errorStyle
errorTitle
imeMode
operator
prompt
promptTitle
showDropDown
showErrorMessage
showInputMessage
type



Note: Full description of attributes see here .
All attributes correspond to fields on Data Validation popup screen:


 Example of specifying attribute values 
for dynamic redefinition:



 

  • (1) Value (Formula)

        The first formula in the Data Validation dropdown. It is used as a bounds for 'between' and 'notBetween' relational operators, and the only formula used for other relational operators (equal, notEqual, lessThan, lessThanOrEqual, greaterThan, greaterThanOrEqual), or for custom or list type data validation. The content can be a formula or a constant or a list series (comma separated values).

By default, first formula will be copied "as is" from template to runtime resultant file . 

For dynamic redefinition, you can use two ways:
  • Specify context field, which contain formula value. 

  • Choose Grid component in the form and it's Field, which should be a dataset (for list type data validation).

  • (2) Value (Formula)

        The second formula in the DataValidation dropdown. It is used as a bounds for 'between' and 'notBetween' relational operators only.

By default, second formula will be copied "as is" from template to runtime resultant file . 

For dynamic redefinition, you specify context field, which contain formula value. 



Mass creation of Values via direct selection fields from context

For convenience, there is another way of «Values» creation: mass creation via direct choice of fields from context. 

To use it, You have to do double-click on the icon  on the right-side of the corresponding row of the POPUP-screen while the new component creation:

              

As result, a new POPUP-screen will appear. The POPUP-screen displays a list of fields from the context, which relevant for «Values».
In the list, You have to choose one or more fields (via double-click). Selected fields will be marked by icon   :



After You press the button  , «Values» (according chosen fields) will be added to the form. 
The context binding is already done for added «Values» :

              

For added «Values» You only have to make template binding.