Row 10 of the Wizard is reserved for Default Values. If set up, data rows below Row 10 will be populated with default values if they are blank.
Default data can be derived from either:
Any manually entered value
A formula i.e. =TODAY()
A mixture of values and formulas can be used across row 10.
· Defaulting will only occur on records that have been selected (for validation, upload, or data forms).
· Defaulting will not occur on section rows where there is no data on a specific row.
· Default Row 10 Values will not overwrite rows where data already exists.
· Default Row 10 takes precedence over defaulting set against columns.
· Where no Default row 10 value is present then defaulting is next in order of priority.
· Any values that exist in the Default Values (Row10) where the column is hidden, will default to your data entry rows.
· Standard validation will apply if the defaulted value is not valid for the field.
· The defaults will only apply if at least one column in that section already contains data.
Formulas
· Static row 10 formula references must use absolute cell references (i.e. A$10$). This means that the formula will always reference row 10.
· Dynamic row 10 formula references must use relative cell references. (i.e. A10). This means the formula will relatively reference the row it is being copied to.
User Forms
· Default values are written to the sheet on form open so the sheet can calculate formulas.
· The sheet values are cleared if an exception error occurs or the form cancel is pressed.
· Form values are written over the formulas on form save. (‘Ok’ click)
· User form ‘Cancel’ will clear previously printed default values.
· On data entry form open, the section parent must load to resolve IDs. Therefore, all rows associated with this record will have Default Row 10 values populated.
