Use maxValue and minValue Validation
Use maxValue and minValue Validation
Add-In Manager > User Interface Extensions > Form Skills > Use maxValue and minValue validation
A Form save action triggers schema storage limit validations on users entering values for editable fields. A numeric field’s schema storage limit is determined by its schema size and decimals. For example, if a numeric field has a schema size of 5 and decimals of 2, its schema storage limit will be [-99.99, 99.99]. Numeric field schema storage limit validations will prevent database query exceptions.
However, some users want
narrow data range enforcement, e.g. a data range [0.00, 100.00] for a percent field, which cannot be enforced by field schema storage limit validation.
maxValue
and
minValue
provide fine data range validation on a numeric field.
To add
maxValue
and
minValue
to a numeric field in a form panel in javascript:
afterViewLoad: function(){
this.validationPanel_form.setMaxValue('wr.cost_total', 100);
this.validationPanel_form.setMinValue('wr.cost_total', 0);
}
Process : Technologies/User Interface Add-Ins/Parts for Forms
Task: Advanced Form Techniques/Max and Min Value Validation