2022.2

results.css('color', 'red')
Itdoesthisforeachandeverycustomer,becauseitdoesnotdependonavaluefromtherecordthatis
beingmergedtothetemplate.
Using values from the record in a script
Toaccesstherecordthatisbeingmergedtothetemplatewhenthescriptruns,usetheobjectrecord
(see"record"onpage1199).
Supposeyouwanttodisplaynegativeamountsinredandpositiveamountsingreen.Assumingthat
thereisanAMOUNTfieldinyourcustomerdata,youcouldwritethefollowingscript(withtheselector:
td.amount,thatis:tablecellswiththeclass'amount').
var amount = record.fields.AMOUNT;
if (amount >= 0)
{results.css('color', 'green');}
else if (amount < 0) {
results.css('color', 'red');
}
Whenthisscriptexecutes,itstoresthevalueoftheAMOUNTfieldfromthecurrentrecordinavariable
andevaluatesit.Ifthevalueiszeroorhigher,thecoloroftextintheresults -thetablecellsinthiscase
-willbesettogreen;ifthevalueisbelowzero,thetextcolorwillbesettored.
Tip: Formoreexamplesofusingconditions,seethishow-to:Combiningrecord-based
conditions.
Ifanexpandedscriptcontainserrorsoriftherearewarnings,iconsappearintheoverviewruleronthe
righthandsideoftheeditingarea.Theseiconsareshownrelativetotheirpositioninthescriptanddo
notmoveasyouscrolldown.Youcanclickonanicontoquicklyjumptotheerrororwarning.Script
errorsarehighlightedbyaredicon,andwarningsinyellow.Thetopmosticonwilldisplayredifany
errorsexistinthescriptatall.
DesignerAPI
FeatureslikeresultsandrecorddonotexistinthenativeJavaScriptlibrary.Theseareadditional
JavaScriptfeatures,designedforuseinConnectscriptsonly.Allfeaturesdesignedforuseinthe
DesignerarelistedintheDesigner'sAPI,withalotofexamples;see"StandardScriptAPI"on
page1169.
Setting the scope of a script
Theselectorofascriptcanmatchmultipleelements.Bysettingthescopeofthescriptyoucandeterm-
inewhetheryouwanttorunthescriptonce,oronce for each elementthatmatchestheselector.The
secondoptionisespeciallyusefulwhenascripttargetsrowsorcellsinaDynamicTable(see"Using
scriptsinDynamicTables"onpage835).
Page 813