How to sum data from a child table in real time?

[Deybi_Tabora_Paz]

I’m trying to sum totals for the rows in a child table, but I want to get this calculation to run in real time and summed up in the parent field.

total_references:function(frm, cdt, cdn){
	var d = locals[cdt][cdn];
	var total = 0;
	frm.doc.references.forEach(function(d) { total += d.total_amount; });
	frm.set_value("total_references", total);
	refresh_field("total_references");
},

[Suresh_Thakor]

See here is example matches your post Hope this helps

Sum column in child table and show total in parent field

Please help I tried to run the following custom script but it is not work: frappe.ui.form.on(“Project test invoice”, “validate”, function(frm) { set_total_01(frm); }) frappe.ui.form.on(“sum test table”, “qty_11”, function(frm, cdt, cdn) { set_total_01(frm); }) var set_total_01 = function(frm) { var total_01 = 0.0; $.each(frm.doc.table_2, function(i, row) { total_01 += flt(row.qty_11); }) frm.set.value(“total_01”, total_01); frm.refresh(); } parent doctype name is:Project test invo…

[Deybi_Tabora_Paz]

@Deybi_Tabora_Paz

I was following the example but it does not update the result in real time.

I was following the example but it does not update the result in real time.

[Mohammed_Redha]

@Deybi_Tabora_Paz You have to change last line to This:

frm.refresh_field(“total_references”);

[Deybi_Tabora_Paz]

Ready, but for some reason when I add a record to the secondary table, the function that makes the calculation does not run.