The following functionality applies to Insert and Update modes.
Row 10 has been reserved to hold Default Values for the worksheet:
•You can enter defaults into the cells in row 10 and then leave the corresponding cell in the record blank. If the cell in the record is blank and there is a default, it will use the default.
•If the cell in the record has a value, this will override any default in Row 10.
•If you enter [BLANK] into the cell in the record, then the default value in Row 10 will be ignored. This syntax also means any API defaults will also be ignored.
•This functionality is also available in the ‘Edit By Sheet’ when loading columns.
Important - If the Template definition has a 'Default Value' assigned to a column, and the user has entered a value in Row10, the Row10 value will override the Template default.
