nuBuilder Forum

Code: Select all

function sumFormColArray(id, fieldname) {

    var a = Array();
    var sf = nuSubformObject(id);
    var c = sf.fields.indexOf(fieldname);
    for(var i = 0; i < sf.rows.length; i++) {
        if(sf.deleted[i] == 0) {
            var rv = sf.rows[i][c];
            a.push(rv);
        }
    }
    return a;
}

function subFormHasMissingValuesInColumn(id, fieldname) {
	var arr = sumFormColArray(id, fieldname)
	return arr.findIndex(e => e === "") > -1
}

function nuBeforeSave() {
    if (nuFORM.edited === true) {

		if ($('#po_categ').val() !== "") {
			if (subFormHasMissingValuesInColumn('field04','co_actn')) {
				nuMessage(["There are missing values in column xyz."]);
				return false;
			}
		}   
    }
    return true;
}

Code: Select all

$id = 'field04';        // subform object id
$fieldname = 'co_actn';   // subform field name
    
    
if ("#po_categ#" !== "") {
    if (blankValuesInSubformField($id, $fieldname) > 0) {
        nuDisplayError('Field xyz '.nuTranslate('cannot be left blank'));       
    }
}

function blankValuesInSubformField($id, $fieldname) {

    $sf = nuSubformObject($id);
    
    $c = array_search($fieldname, $sf->fields);

    for($i = 0 ; $i < count($sf->rows) ; $i++){
             
          $value = $sf->rows[$i][$c];
          $notDeleted = $sf->deleted[$i] == 0;
   
          if ($notDeleted && $value == "") {
                $r++;
          }
    }
   
    return $r;

}