2022.2

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744).
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715.
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395).
Tosetthescopeofascript,clickonOptionsatthebottomoftheScriptEditorwindow.Theoptionsare:
Page 373