nuBuilder Forum

kev1n wrote:Hi,

I'm afraid I don't undestand your question/what you are trying to do. Can you add some screenshots and maybe describe it in a different way?

kev1n wrote:Try the subformsCopyDriver() function:

Code: Select all

subformsCopyDriver('idSfSource', 'idColDriverSource', 'idNoSource', 'objSfDest', 'idColDriverDest', 'idNoDest')

Replace the parameters with the corresponding IDs of your subforms / fields, where:

Right Subform (Source):

idSfSource: Object Id of your source subform
idColDriverSource: Object Id your driver column
idNoSource: Object Id your № column

Left Subform (Destination)
objSfDest: Object Id of your destination subform
idColDriverDest: Object Id your driver column
idNoDest: Object Id your № column

Code: Select all

function subformsCopyDriver(idSfSource, idColDriverSource, idNoSource, objSfDest, idColDriverDest, idNoDest) {

    var objSource = nuSubformObject(idSfSource);
    var colDriverSource = objSource.fields.indexOf(idColDriverSource);
	var colNoSource = objSource.fields.indexOf(idNoSource);
	

    var objDest = nuSubformObject(objSfDest);
    var colDriverDest = objDest.fields.indexOf(idColDriverDest);
	var colNoDest = objDest.fields.indexOf(idNoDest);
	
    for (var s = 0; s < objSource.rows.length; s++) {
	
        if (objSource.deleted[s] == 0) {
            var valColDriverSource = objSource.rows[s][colDriverSource];
			var valColNoSource = objSource.rows[s][colNoSource];
	
		for (var d = 0; d < objDest.rows.length; d++) {
			
			if (objSource.deleted[d] == 0) {
				
				var valColDriverDest = objSource.rows[d][colDriverDest];
				var valColNoDest = objSource.rows[d][colNoDest];

				if (valColNoSource == valColNoDest) {
					
					let destObjId = objSfDest + nuPad3(d) + idColDriverDest;
					if ($('#' + destObjId).val() == '') {
						nuGetLookupId(valColDriverSource, destObjId);
					}

				}
			
			}
			
		}
	            
        }
    }

}

subformsCopyDriver('subform','sub_field02','sub_field00','subform','sub_field07','sub_field01')

function zapoln_is_ves(event) {
    
    var sour = nuSubformObject('sub_ves');

    var r = sour.rows;
    
    for (var i = 0; i <r.length-1; i ++) {
        nuAddRow('sub_hodki');

    $('#sub_hodki' + nuPad3(i) + 'hod_num').val(r[i][1]).change();
    $('#sub_hodki' + nuPad3(i) + 'hod_kol').val(r[i][2]).change();
    $('#sub_hodki' + nuPad3(i) + 'hod_avg').val(r[i][4]).change(); 
    $('#sub_hodki' + nuPad3(i) + 'hod_vod').val(r[i][7]).change();    //This is a lookup field
    }
}