START:<TAG>
= mandatory in combination with another parameter
Parameter |
Mandatory/Optional |
Value (example) |
Occurrence in column A |
Comment |
|
---|---|---|---|---|---|
FORMS |
REPORT |
||||
#START:<TAG> |
N/A |
N/A |
x number of times |
Defines the start of a group in a template and a descriptive text for the group (<TAG>). Will be used when adding rows to a form. In addition, if no rows are generated in the group then all rows within START-STOP will be hidden. |
#START:<TAG> is a FORM specific parameter that can be used to filter which values should be shown when adding a new row to a specific group in the template. Several start and stop tags can be defined in column A in the template. If these tags are entered in column A, then they need to be linked to actual values, by defining the ADDROW_FILTER parameter in PARAM.
These tags always need to start with #START: and thereafter a tag name should be stated. The tag name needs to defined in the ADDROW_FILTER in the PARAM worksheet in column C. Each #START tag needs to have a #STOP tag.
In this template, four different tags are specified and each #START tag is connected to a #STOP tag. The #START and #STOP tags are always defined in column A in the template:
When the template is generated and the "New Row" button is clicked, the following dialog is opened. Since tags and ADDROW_FILTERs have been defined in the template and the marker is located within the ITEM2 tag, only new values within the interval 140 an 159 (tag ITEM2) are shown. If no ADDROW_FILTERs have been defined in this template, then all new values would have been visible in this dialog, independent on where the marker is located.