15
edits
Changes
→Builder: . Added an example and note for using the validation for columns which have currency formatting. In reference to ticket number - 20359
* ''Input Attributes:'' Add HTML attributes to the input field (Example: ''name, size'')
* ''Validation Script:'' Script to validate the input field (Example: ''[this]>100'' or ''[this]==[35_Total_Amount]'')
Note:
If the column on which you want to apply the validation on has a 'Currency' formatting then you will have to convert the data into a number before you perform the validation.
Example:
To check if the amount entered is always greater than 0 for a column which has a currency formatting use the built in ssParseNum function to convert the amount to a number.
ssParseNum([this])>0
* ''Validation Message:'' Alert when validation script is not true (Example: ''This value must be greater than 100'')
