Server Script / Client Script for Fetching details

ERPNext
5

Hi @falahtech,

Please try it.

frappe.ui.form.on('Products', {
    before_save: function(frm) {
        update_vals(frm);
    }
});

frappe.ui.form.on('PCode Child Table',  {
    field_one: function(frm, cdt, cdn) {
        var d = locals[cdt][cdn];
        update_vals(frm);
    },
    field_two: function(frm, cdt, cdn) {
        var d = locals[cdt][cdn];
        update_vals(frm);
    },
    field_three: function(frm, cdt, cdn) {
        var d = locals[cdt][cdn];
        update_vals(frm);
    }
});

function update_vals(frm) {
    $.each(frm.doc.pcode_table,  function(i, d) {
        frappe.db.get_value("P Code", {"field_one": d.field_one, "field_two": d.field_two, "field_three": d.field_three}, "name", function(value) {
            d.p_code = value.name;
        });
    });
}

Check the doctype, child doctype name, doctype field, and table field name your according to.

Thank You!

2 Likes