STORABLE
In older version only CVAL and data attributes were stored to the database.
In template version one to store in the database, enter a new parameter in column A labeled ‘STORABLE’. Any column in the template that has TRUE or "1" in the column will be stored in the data table. If the column don't exists in the store table it will be ignored, no error will occur.
Parameter in Column A
= mandatory in row 1 (FORMS)
= optional in row 1 (REPORTS)
Parameter |
Mandatory/Optional |
Value (example) |
Occurrence in row 1 |
Comment |
|
|---|---|---|---|---|---|
FORMS |
REPORT |
||||
STORABLE |
1 |
Columns with the Storable parameter set to True will be updated in the database. By default, cells in row DATA and columns designated as storable will be open for entry, while all other cells will remain locked. |
|||
STORABLE parameter in COL A is mandatory in FORMS. Entries in columns marked TRUE for STORABLE (and DATA rows) will result in records saved in the database. Every value entered in a STORABLE/DATA cell will be updated in the database and it is only these cells that will be open for entry for the end-user.
All cells with DATA in column A and columns marked TRUE or 1 for STORABLE parameter in column A will be:
Open for entry when the form is generated. All other cells will be locked for editing. Also for having data attribute columns must be also marked for TRUE or 1 for STORABLE parameter which will then be open for entry.
Updated in the database (those data cells with values).
If the STORABLE value for columns is set to FALSE or 0, the record will not be updated in the database.
The defined cell comments #ENTRY or #NOENTRY can be used to override the default state of open and locked cells for any particular cell.
Note: The above statements are only applicable to template type FORM. In REPORTS, all cells will be locked and you can not update any values in the database.
Mandatory parameters for STORABLE:
- SOURCE (=DATAVIEW)
Optional parameters for STORABLE:
- SPGROUP - Should be defined if the STORABLE column is included in a spread group where a spread value and spreadkey are used to allocate a value to several STORABLE columns.
- SCALE
- VALT - If not specified in PARAM or in row 1, VALT must be defined for each STORABLE column.
- CURR - If not specified in PARAM or in row 1, CURR must be defined for each STORABLE column.
In the template worksheet, a STORABLE column can be a "standalone" column in which the end-user manually enters a value. Or, the STORABLE column can be included in a spread group in which the user selects a spreadkey and values are automatically divided between the STORABLE columns within the same SPGROUP. However, even though a STORABLE column is included in a spread group, the end-user has the option to enter values manually in each STORABLE column.