Section E and F Validation
Please note that the documented validations are inconsistent within themselves as well as inconsistent with validations we’re getting as a result of testing. If you receive a validation error message from OMB that should be added, please let us know.
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 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 Management")) && (count == 0)){need=true; msg += "The Cost and Capabilities table must have at least one row in it when Standard IT Infrastructure & Management is 'IT Management'";}