Rows or columns in a data entry grid can be set to display a red border when data input is required. In the example below the red border disappears when the user types in a value.
Individual cell values can be automatically tested against static limits. Both error and warning ranges can be set.
Add unit conversion to your grid data entry window. Values can be entered in any unit and stored in internally in any unit (although this is usually SI). Units can be typed in directly. For example, if the user has a size value of 3 inches they can type '3 in' and this will automatically be converted to the current unit of measure (mm).
The unit of measure for a row or column can be changed temporally whilst entering data. Alternatively the values can be converted to a different unit of measure. In the following example the unit of measure is changed from millimeters (mm) to inches (in) for the entire column and the values converted.
Default values can be set for rows or columns of cells in a data entry grid. An empty cell is automatically filled with the default value and displayed with a green border.
For more complex range checking or special processing user validation functions are provided. Having converted a cell value and checked it against the static limits a user validation function is called. An error in the user validation function can be returned as a text string, which is automatically displayed. Here the sum of gas and liquid fractions are checked to ensure they don't exceed 100%.
Please contact ESSCo for further information.