You can use the WRITE and READ Validation parameters in your Workbook to secure valid values after READ and before WRITE. Please remember that all named ranges in data1.io must be defined on a sheet (and not workbook) level.
The following optional parameters can be used to secure valid values after READ:
- data1_Read_Validation (_1, _2, etc.)
- data1_Read_ValidationMessage (_1, _2, etc.=)
The following optional parameters can be used to secure valid values before WRITE:
- data1_Write_Validation (_1, _2, etc.)
- data1_Write_ValidationMessage (_1, _2, etc.=)
How to use the validation parameters
data1_Read_Validation
Use this parameter to define warnings in your workbook after the READ process.
- data1_Read_Validation
0 = default = read values ok
1 = Validation Message will be shown - data1_Read_ValidationMessage
Use this parameter to define the message for the user, which is displayed if the first parameter has value "1" after the READ process. - Multi Messages with _1, _2, etc.
Use named ranges couples like these to define as many validation rules within the same sheet as needed:
data1_Read_Validation_1
data1_Read_ValidationMessage_1
data1_Read_Validation_2
data1_Read_ValidationMessage_2
etc.
data1_Write_Validation
Use this parameter to define mandatory entries in your workbook.
- data1_Write_Validation
0 = default = Writeback is open
1 = Writeback is blocked & Validation Message will be shown - data1_Write_ValidationMessage
Use this parameter to define the message for the user, who has pressed the Write button and if the first parameter has got value "1". - Multi Messages with _1, _2, etc.
Use named ranges couples like these to define as many validation rules within the same sheet as needed:
data1_Write_Validation_1
data1_Write_ValidationMessage_1
data1_Write_Validation_2
data1_Write_ValidationMessage_2
etc.
Validation and Automatization
READ Validation | WRITE Validation | |
Iterate Sheet | <to be documented> | <to be documented> |
Download XLSX | Warning is shown and stops the Download process. | --- |