Changes

Jump to: navigation, search

XML Section Builder

722 bytes added, 15:31, 27 September 2016
no edit summary
* ''Input CSS Class:'' Add a CSS class to the input field
* ''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]'' or ''[this].length>0'' or ConvertDateStr([this],'@dateformat@') <= "@Date Field@" or [this]See section below for examples.split(' ').length<=10)
Note:
<pre style="white-space: pre-wrap;
* ''Validation Message:'' Alert when validation script is not true (Example: ''This value must be greater than 100'')
 
==XML Validation Examples==
 
===Total Amount greater than 0===
Specifically for validation of Currency formatted column totals.
<pre>ssParseNum([this])>0
 
Total must be greater than $0.00</pre>
 
===Date is at least 30 days in the future===
<pre>(datediff('@date(currentdate)@',ConvertDateStr([this],'@dateformat@'),'d')) > ('30') && [this].length>0
 
Please select a date that is at least thirty (30) days from today.</pre>
 
===Cell is not empty===
<pre>[this].length>0
 
Please provide a value.</pre>
 
===Default not selected in Combo Box===
<pre>[this]!="Default Combo Box Value"
 
Please select a value.</pre>
"Default Combo Box Value" should be substituted with the default value you have configured, ex. "Select One"
 
===Integer greater than 0===
Allow only an integer or if your field on the XML is formatted to display/use a comma.
<pre>parseInt([this])>0
 
==Template==
Smartstaff, administrator
4,478
edits

Navigation menu