CVAL
=mandatory in row 1 (FORMS)
=optional in row 1 (REPORTS)
Parameter | Mandatory/Optional | Value (example) | Occurrence in row 1 | Comment | |
|---|---|---|---|---|---|
FORMS | REPORT | ||||
CVAL |
|
|
| x number of times | Specifies the columns that will be updated in the database. By default, the cells in row DATA and column CVAL will be open for entry, all other cells will be locked. |
CVAL is a parameter that is mandatory in FORMS. Entries in CVAL columns (and DATA rows) will result in records saved in the database. Every value entered in a CVAL/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 CVAL in row 1 will be:
- Open for entry when the form is generated. All other cells will be locked for editing (except data attribute columns, which also will be open for entry).
- Updated in the database (those data cells with values).
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 CVAL:
Optional parameters for CVAL:
- SPGROUP - Should be defined if the CVAL column is included in a spread group where a spread value and spreadkey are used to allocate a value to several CVAL columns.
- SCALE
- VALT - If not specified in PARAM or in row 1, VALT must be defined for each CVAL column.
- CURR - If not specified in PARAM or in row 1, CURR must be defined for each CVAL column.
In the template worksheet, a CVAL column can be a "standalone" column in which the end-user manually enters a value. Or, the CVAL column can be included in a spread group in which the user selects a spreadkey and values are automatically divided between the CVAL columns within the same SPGROUP. However, even though a CVAL column is included in a spread group, the end-user has the option to enter values manually in each CVAL column.
