i tried to calculate total of Work Completed from child table and make it into 100% or divided by its row… i used below code but no effect. [work] cur_frm.cscript.calculate_total = function(doc,cdt,cdn){ var val = doc.goals || []; var total =0; for(var i = 0; i<val.length; i++){ total = flt(…

[image] How to get the total qty in list item frappe.ui.form.on("Child Table Doctype Name", "field_name", function (frm, cdt, cdn) { var total = 0; $.each(frm.doc.child_table_doctype_name || [], function (i, d) { total += flt(d.field_name); }); frm…

@OmarJaber , thanks your help but this code dose not work for me. frappe.ui.form.on(“Appraisal Plan Goal”, “work_completed”, function(frm, cdt, cdn) { var total = 0; $.each(frm.doc.appraisal_plan_goal || [], function (i, d) { total += flt(d.work_completed); }); frm.set_value(“total_work_complet…

Not sure about version 7, but when we were using version 10, the refresh_field does not work for child table until version 11. How did we figure this out? Basically we used the console to output the value of the child table, from the console it reported the new value we set, but on the user’s end, …

i used below code in custom script. i can sum up but i can’t divide by numbers of row after sum up. when divide i used: total = total + ((work[i].work_completed)/work[i])) this code not working frappe.ui.form.on(“Appraisal Plan Goal”, “work_completed”, function(frm, cdt, cdn) { var work = frm.d…

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

Total calculation from child table

OmarJaber March 10, 2019, 7:06am 3