Math Functions Child Table

Florea_Andrei · December 11, 2017, 7:52pm

Hello,
I have 2 filds in a Child table ( “cantitate” and “pret”) and the field " total" in custom doctype , Necesar Materiale"

What I am trying to do is to have the following formula cantitate x pret= total. But the total needs to contain the multiply of all the rows added.

I have the following script but is not working

frappe.ui.form.on(‘Necesar Materiale’, {
onload: function(frm) {
//This will make sure they are are updated whenever the form reloads
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},
cantitate: function(frm) {
//This will make sure the calculation happens whenever cantitate is updated
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},
pret_2: function(frm) {
//This will make sure the calculation happens whenever pret is updated
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},
});

priya_s · December 12, 2017, 5:34am

Try with this -

frappe.ui.form.on(‘Child Table Name’, {
cantitate: function(frm, cdt, cdn){
    // Calculate when change Cantitate value
    var d = locals[cdt][cdn];
    if(d.pret_2){
         cur_frm.set_value(“total”, d.cantitate * d.pret_2);
         refresh_field("total");
    }
},
pret_2:  function(frm, cdt, cdn){
    // Calculate when change Pert value
    var d = locals[cdt][cdn];
    if(d.cantitate){
        cur_frm.set_value(“total”, d.cantitate * d.pret_2);
        refresh_field("total");
    }
}
});

Florea_Andrei · December 12, 2017, 9:18am

@priya_s

I receive this erorr

Florea_Andrei · December 12, 2017, 9:18am

and the value of ,total" is not updated.

priya_s · December 12, 2017, 10:29am

Can you please share your code ?

Florea_Andrei · December 12, 2017, 8:05pm

frappe.ui.form.on(‘Necesar Materiale’, {
onload: function(frm) {
//This will make sure they are are updated whenever the form reloads
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},
cantitate: function(frm) {
//This will make sure the calculation happens whenever cantitate is updated
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},
pret_2: function(frm) {
//This will make sure the calculation happens whenever pret is updated
frm.set_value(“total”, cur_frm.doc.cantitate * cur_frm.doc.pret_2);
},

@priya_s

Mohammed_Redha · December 12, 2017, 11:54pm

@Florea_Andrei try this:

frappe.ui.form.on(‘Necesar Materiale’, {
onload: function(frm) {
//This will make sure they are are updated whenever the form reloads
frm.set_value(“total”, frm.doc.cantitate * frm.doc.pret_2);
frm.refresh_field("total");
},
cantitate: function(frm) {
//This will make sure the calculation happens whenever cantitate is updated
frm.set_value(“total”, frm.doc.cantitate * frm.doc.pret_2);
frm.refresh_field("total");
},
pret_2: function(frm) {
//This will make sure the calculation happens whenever pret is updated
frm.set_value(“total”, frm.doc.cantitate * frm.doc.pret_2);
frm.refresh_field("total");
}
});

priya_s · December 13, 2017, 5:00am

@Florea_Andrei,

I think you wrote a trigger on your main form. So you need to write it on you Child Table trigger instead of main form.
Please refer my previous reply…

Florea_Andrei · December 13, 2017, 7:56am

Hi @priya_s still not working:(

Total remains 0.

SOLOSOFT · December 13, 2017, 9:24pm

Hi
Between the two functions u need a semi-colon ( to seperate.

Regards