VERSION

  =mandatory in PARAM sheet or in the template worksheet (FORMS)

= optional in PARAM sheet                                                                                                                        

VERSION is a FORM specific parameter, which is mandatory. When updating values in the database, the data rows need to be tagged to a specific version, in order to keep the updated data cells separated and not risk that already existing data would be updated with incorrect data. Version parameter can also be added in the actual template in column A and then specified for each STORABLE column.

However, the parameter can also be used in REPORTS if data from the data table should be retrieved to the report. Then one specific version probably need to be specified in the PARAM sheet in order to get the correct numbers.

Any VERSION value containing a - (hyphen) must be stated within { } in PARAM sheet, otherwise SQL will not treat this as a unique value and data will not be linked and saved with the version value. A hyphen is treated as a interval in SQL smart.

Access the VERSION from the right panel in Template design by selecting Parameters > Data Dimensions > Version:

In the Version field you can either directly add the version ID you want to filter the data on, or you can use the buttons to the right to either select a specific version from the Version dropdown or select a CF_GETPANEVALUE formula to retrieve the version ID directly from a selection pane.

The value you enter in the Version field in the right panel, will be written to the VERSION parameter in column C.

If the template contains several sections you can add specific versions for each section or define one for all sections. If you leave the Section dropdown empty the Version will apply for all sections.

Retrieve/Update Values - Column C and D in PARAM

In a FORM, if only a value in column C in PARAM is defined for the VERSION  parameter then that value will be used both when retrieving data to the form and when updating values to the database.

If you for some reason want to retrieve values for a different set of versions compared to the VERSION value you want to be updated, then you need to define those retrieve value(s) manually in column D in PARAM sheet. If several version values should be retrieved then these version  values need to be separated with # in column D in PARAM, i.e. VERSiON1#VERSION2

ONLY use the D column in VERSION in PARAM if:

• You want to merge multiple versions into another version (in the STORABLE columns).
• You want to retrieve data from another version for some rows in the form and save them to a new version.
• You want to retrieve data from another version for some rows in the form and then make sure that these rows are not DATA/STORABLE rows, which means they are not stored in the new version but just retrieved  for viewing (such as the example of retrieving personnel budget rows in a total cost budget).

REPORT templates only support values in column C in PARAM (column D in PARAM should not be used).