Section E and F Validation - Update 003

Javascript updated:

var capability = getSubItems("Capability ID");

var capstatus = getSubItems("Capability Status");

var infrastructure = getCell("Standard IT Infrastructure & Management Category").Value;

var count = 0;

var need = false;

var need1 = false;

var need2 = false;

var msg = "";

for(var i=0; i<capability.length; i++){

if((capability[i].SubItemType == getValueList("Dynamic List Types", "Capabilities")) && (capability[i].Value != null) && (capstatus[i].Value == getValueList("Active Status", "Active"))){count = count+1;}

}

if((infrastructure == getValueList("Standard Infrastructure & Management Category", "IT Security & Compliance")) && (count == 0)){need=true;}

var systemvalid = getSubItems("System Valid_FY18");

for (var i = 0; i < systemvalid.length; i++)

{

  if((systemvalid[i].SubItemType == getValueList("Dynamic List Types", "Legacy Systems")) && (systemvalid[i].Indicator == red)){need1=true;}