0
edits
Changes
m
→Builder: Word wrap on note and example
* ''Validation Script:'' Script to validate the input field (Example: ''[this]>100'' or ''[this]==[35_Total_Amount]'')
Note:
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">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.</pre>
Example:
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">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</pre>
* ''Validation Message:'' Alert when validation script is not true (Example: ''This value must be greater than 100'')
