Homepage | About EASA | Contact
Sidebar
Data Validation
Object The Data Validation object is a child of the Input box object. It defines what data is allowed to be entered by users into its parent Input box object. Like the Input box object, the set of available parameters is dynamic, and in the case of the Data Validation object, the visible parameters change based on the setting of both the essential Allow and optional Data parameters. The available data types for the Allow parameter and their effects on the Data Validation object are shown below.
If you set the Allow parameter to any value except for ‘List’, the optional Data parameter will appear and based on the value selected for it, further parameters will appear. The value of the Data parameter is selected from a list of data restrictions. Here is a listing of the restrictions and the additional parameters that will appear:
- between: Minimum and Maximum parameters
- not between: Minimum and Maximum parameters
- equal to: Value parameter
- not equal to: Value parameter
- greater than: Value parameter
- greater than or equal to: Value parameter
- less than: Value parameter
- less than or equal to: Value parameter
 Data Validation |
|
|---|---|
| Essential Parameters: | |
| Allow | Select criteria by which to allow Data. See list above for choices. |
| Optional Parameters: | |
| Ignore Blank | Select whether to validate blank or empty values in the input box. [Choices: TRUE, FALSE / Default = TRUE] |
| Data | Select the data restriction type. [Choices listed below] |
| Date Input Type | Select the type of date input. [Choices= Calendar, Calendar with Button, Manual] |
| Auto Resize | Controls whether the drop-down list should be resized automatically to fit the longest item on screen or appear with the fixed default length. |
| Source | Specify list of valid values when Allow parameter is set to ‘List’ [DORs allowed] |
| Delimiter | Character to act as delimiter in DORs. Replaces default of %. [e.g. ?, !] |
| Data Parameter Choices | ||
|---|---|---|
| Data Type | Effect | Optional Parameters |
| Any Value | There is no restriction to what might be entered. | Ignore Blank Delimiter |
| Date | Date data types may be entered according to the Pattern parameter of the parent Inputbox object. | Ignore Blank Delimiter Data Date Input Type |
| Decimal | Forces data entered to be a real number. | Ignore Blank Delimiter Data |
| List | Forces users to select from a list of values as defined in the Source parameter. | Ignore Blank Delimiter Source Auto Resize |
| Text Length | Restricts data entered to a specified number of characters. Data parameter will become visible. Value of Data parameter will either show the Date parameter or the Minimum and Maximum parameters. | Ignore Blank Delimiter Data |
| Whole number | Forces data entered to be an integer. | Ignore Blank Delimiter Data |
Note: To enter dates manually into the Input Box, set it’s Input Type parameter to DateTime, the Allow parameter of the child Data Validation to Date and finally the Date Input Type to Manual.