You can use several optional parameters in your Workbook in order to realize specific functions. Please remember that all named ranges in data1.io must be defined on a sheet (and not workbook) level.
The most important
The following optional parameters can be defined to control the bottom and sum level elements:
- data1_CELLS01_DIMxxx_Key
- data1_CELLS01_DIMxxx_Attribute
- data1_CELLS01_IsSumLevel
- data1_CELLS01_DIMxxx_Type
- data1_CELLS01_DIM001_Path
The following optional parameters can be defined to control the initial sheet loading behaviour:
- data1_ReadFirstElement
The following optional parameters can be used to control the formatting of changed cells:
- data1_ChangedCellFormat
The following optional parameters can be used to control the additional information:
- data1_CurrentUserKey
How to use the bottom and sum level parameters
data1_CELLS01_DIMxxx_Key
You can use this optional parameter to get the Key of the currently selected element in the dimension tree (addtionally to the obligatory name of the element).
data1_CELLS01_DIMxxx_Attribute
With this parameter you get the name of the field ("level") of the currently selected element in the dimension tree.
This parameter is important to build dynamic element list reports (the parameter is used in the "array format" there). It was also used to build the filter statement for dynamic tables, but this parameter was replaced by the newer "data1_CELLS01_DIMxxx_Key_Path" parameter which is the better alternative for this field of application now.
data1_CELLS01_IsSumLevel
This is very simple: double clicking an element in the dimension tree will deliver a "0" or a "1":
- 0 = Sum Level
- 1 = Bottom Level
You can use this parameter for a level-specific configuration of the R/W control panel in order to realize advanced aggregation effects.
data1_CELLS01_DIMxxx_Type
Use this parameter to get the element type (UID) of the selected element in the dimension tree. Please be aware that this parameter delivers null/blank when selecting a sum level element.
data1_CELLS01_DIM001_Path
We have created a new named range “Path” in order to create a breadcrumb display of the currently selected item in your workbook.
The parameter delivers the path of the selected element. This path can be combined with the parameter data1_CELLS01_DIM001 to establish a breadcrumb display (green box):
How to use the initial sheet loading parameters
data1_ReadFirstElement
This parameter rules the behaviour when entering a sheet the first time after loading the workbook.
0 = do not read
1 = default = the first top element (from the tree) will be read on entering the sheet. Used to read directly the current aggregated sums in order to get an overview of the status of the data collection.
2 = the first bottom element (from the tree) will be read on entering the sheet. Used to jump directly to the first bottom element in order to start immediately with data entry.
3 = the predefined element from the named range "data1_CELLS01_DIM001" (from the workbook) will be read -> if this element is not found / not valid, then no READ is executed.
Please note that this parameter replaces the parameters "data1_ReadFirstTopElement" and "data1_ReadFirstBottomElement".
How to use the changed cells parameter
data1_ChangedCellFormat
With this named range you can define, how the background and text color should be changed in the Web Client, after a collector user has entered a value in a cell.
Please note that this parameter was defined as data1_CELLS01_ChangedCellFormat until November 2022.
How to use the additional information parameters
data1_CurrentUserKey
Delivers the e-mail adress of the currently logged in user. Can be used to setup a user specific security within the workbook.