Changes

Jump to: navigation, search

SmartCheck Validation

157 bytes added, 18:58, 6 February 2023
no edit summary
<pre>if(ssParseNumFromCurrency(form.getStr("cf_myCADcurrency"),"@sslocale@",1,true) > 5) {
result.isPassed=false; result.addMsg('Some message here');
}
if(ssParseNumFromCurrency(form.getStr("cf_myDKKcurrency"),"da-DK",1,true) > 5) {
result.isPassed=false; result.addMsg('Some message here');
}</pre>
<pre>if(ssParseNumFromCurrency(form.getStr("cf_myCADcurrency"),"@sslocale@",1,true) > 5) {
result.isPassed=false; result.addMsg('Some message here');
}</pre>
For other currencies with format regardless of user's locale, such as DKK, it can be implemented as:<br /> ssParseNumFromCurrency(value,getLocalestrByCurrency('DKK'),1,true) OR ssParseNumFromCurrency(value,"da-DK",1,true)<br />''(getLocalestrByCurrency will get the "default" locale of the currency code)''
<pre>if(ssParseNumFromCurrency(form.getStr("cf_myDKKcurrency"),"da-DK",1,true) > 5) {
result.isPassed=false; result.addMsg('Some message here');
}</pre>
Check '''If''' the contents the of the form value (stored in the custom field named cf_Store_Value) is greater than 5,
<pre>{result.isPassed=false;
</pre>
Assign the value of the '''Result''' to '''"false"''' and print the custom message below.
<pre>result.addMsg('Some message here');
}
</pre>
<pre>if(((form.getStr("cf_Strategy").length() - form.getStr("cf_Strategy").replace(';','').length())>4)) {
result.isPassed=false; result.addMsg("cf_@Strategy.id@",'You can pick up to 4 primary strategies you use.', 1); result.addMsg("cf_@Strategy.id@",'Puedes elegir 4 estrategias principales.', 14); result.addMsg("cf_@Strategy.id@",'Vous pouvez choisir à 4 stratégies primaires', 6); result.addMsg("cf_@Strategy.id@",'Você pode escolher 4 estratégias primárias.', 16);
}</pre>
===Check an amount is greater than $100,000===
<pre>if(ssParseNum(form.getStr("cf_Amount Requested")) > 100000) {
result.isPassed=false; result.addMsg("cf_@Amount Requested.id@",'Amount Requested cannot exceed $100,000');
}</pre>
===Application Name field blank===
<pre>if(form.getStr("sf_Application Name") == "") {<br /> result.isPassed=false; result.addMsg('Application name cannot be blank'); <br />}</pre>
===Requested Amount less than X===
<pre>if(ssParseNum(form.getStr("cf_Requested Amount")) < 5000){ <br /> result.isPassed=false; <br /> result.addMsg("cf_@Requested Amount.id@",'Field test message');
}</pre>
===Number value greater than 5===
<pre>if(ssParseNum(form.getStr("cf_Store Value")) > 5) {
result.isPassed=false;
result.addMsg('Some message here');
}</pre>
===Single field upload field has no file===
<pre>if("@Single File Field.filename@" == "") {<br /> result.isPassed=false; result.addMsg('Please upload a file here'); <br />}</pre>
===Multi file upload field has no files===
<pre>if(ssParseNum("@level1.MUlti upload.numoffiles@") < 1) {<br /> result.isPassed=false; result.addMsg('Please upload at least one file'); <br />}</pre>
===Dynamic XML field has no entries===
<pre>if("@xml.fieldname.sectionnodename.rownodename.nodecount@"==0) {
result.isPassed=false;
result.addMsg("xml_@fieldname.id@",'At least one entry is required in the XML worksheet.');
}</pre>
===Comparing two custom date fields with separate custom time fields storing 24 hour time===
<pre>if(ssConvertDate(form.getStr("cf_Event Start Date"),"@dateformat@", "yyyy-mm-dd")+' '+form.getStr("cf_Event Start Time") >= ssConvertDate(form.getStr("cf_Event End Date"),"@dateformat@", "yyyy-mm-dd")+' '+form.getStr("cf_Event End Time")) { <br /> result.isPassed=false; result.addMsg("cf_@Event End Time.id@",'End Date must take place after the Start Date');
}</pre>
===Comparing a date custom field to the current date===
<pre>if ((ssConvertDate(form.getStr("cf_Individual Review Start Date"), "@dateformat@", "yyyy-mm-dd") > "@date(currentdate)@")) {
result.isPassed = false; result.addMsg("cf_@Individual Review Start Date.id@", 'Please enter a date less than or equal to today for the date.');
}</pre>
===Comparing a date custom field to a date that is six months ago (date must be at least six months ago)===
<pre>if(ssConvertDate(form.getStr("cf_Date"),"@dateformat@", "yyyy-mm-dd") > "<!--@sscalculation(DATE_ADD('@date(currentdate)@', INTERVAL -6 MONTH))-->"){
result.isPassed=false; result.addMsg("cf_@Date.id@","Date must be at least 6 months prior to today's date");
}</pre>
NOTE: When using @sscalculation, you <u>must</u> wrap the syntax in double quotes
===Ensuring an entered date is at least 3 business days away===
<pre>if(ssConvertDate(form.getStr("cf_Date EOI Revision Deadline"),"@dateformat@",'yyyy-mm-dd') < "<!--@sscalculation(SS_FUNC.addbusdays('@date(currentdate)@',3))-->") {
result.isPassed=false; result.addMsg("cf_@Date EOI Revision Deadline.id@",'Date must be at least 3 business days away');
}</pre>
NOTE: When using @sscalculation, you <u>must</u> wrap the syntax in double quotes
===Date custom field blank===
<pre>if ((ssConvertDate(form.getStr("cf_Project Start Date"), "@dateformat@", "yyyy-mm-dd") == "yyyy-mm-dd")) {
result.isPassed = false; result.addMsg("cf_@Project Start Date.id@", 'Project Start Date is a required field.');
}</pre>
===Validation on a Select Many Checkbox Field===
<pre>if(form.getStr("cf_Request Type").indexOf("General Operating")==-1 ) {
result.isPassed=false; result.addMsg('General Operating was not selected');
}</pre>
To trigger when the value is selected, use '!=-1'. This would normally be used in combination with another field for validations.
===Select Many Checkbox field has at least 5 values selected===
<pre>if(((form.getStr("cf_Check Box Field").length() - form.getStr("cf_Check Box Field").replace(';','').length())<=4)) {
result.isPassed=false; result.addMsg("cf_@Check Box Field.id@",'At least 5 items must be selected.');
}</pre>
===At least one role is selected on a contact===
<pre>if("@rolelist@" == "") {
result.isPassed=false; result.addMsg('At least one role must be selected.');
}</pre>
===Validation on an e-mail field===
<pre>if(!isEmail(form.getStr("cf_Additional Email 1"))) {
result.isPassed=false; result.addMsg("cf_@Additional Email 1.id@",'Please enter a valid e-mail address.');
}</pre>
===Validate that the status of the organization is Active===
<pre>if("@client.status@" != "Active") {
result.isPassed=false; result.addMsg('Please update your Organization Profile then return to this record and click Submit Application.');
}</pre>
<pre>if(form.getStr("cf_notefield")=="") {
result.isPassed= false; result.addMsg("cf_h@notefield.id@","You must type in a description before submitting for revisions.");
}</pre>
<pre>if(ssParseNum(form.getStr("cf_Amount Requested")) > 100000) {
result.isPassed=false; result.addMsg("cf_@Amount Requested.id@",'Amount Requested cannot exceed $100,000');
}</pre>
<pre>if("@level1.[#(?object=contact::criteria=rolename IN ('Panel Reviewer - Pending','Panel Reviewer - Accepted')::groupfunction=count)~userid~#]@" < "1") {
result.isPassed=false; result.addMsg("Please assign reviewers in the Panel Reviewer Pending or Panel Reviewer Accepted role.");
}</pre>
if(countWatch=="0") {
result.isPassed=false; result.addMsg('Please run a watchlist scan.');
}
</pre>
if(y!=-1) {
result.isPassed=false; result.addMsg("cf_@txt_StoreNumber.id@",'Test');
}</pre>
Christopher Young-Hong
Smartstaff
4
edits
Retrieved from ‘https://wiki.smartsimple.com/wiki/Special:MobileDiff/40726’

Navigation menu