How to add a column in child table which can show the total of other column?

Frappe Framework Customization
28

share the image of your doctype properties

29

Go to the customize form of your child table doctype and select that particular that field and find the field

image
image1519×725 58.2 KB

find this field and select as per requirements

30

image
image1383×893 48.7 KB

31

@Anjalijangid done

32

Not working, its still showing 6 only

image

33

@Anjalijangid row.custom_total_cbm = (row.cbm * row.qty).toFixed(3);

34

Where to add this ???

35

@Anjalijangid try this code frappe.ui.form.on(‘Quotation’, {
validate: function(frm,cdt,cdn) {
let row = locals[cdt][cdn];
row.custom_total_cbm = (row.cbm * row.qty).toFixed(3);
frm.refresh_field(“items”);
}
})
i take wrong fieldname total_cbm instead of custom_total_cbm

2 Likes
36

image

37

@Anjalijangid remove quote with “” in frm.refresh_field("items’')

38

try currency instead of float and add precision

39

Total CBM can not be in currency !!

40

image

41

@Anjalijangid frm.refresh_field(“items”)
Please dont copy this line write itself

42 
frappe.ui.form.on("Quotation", {
validate: function(frm,cdt,cdn) {
let row = locals[cdt][cdn];
row.custom_total_cbm = (row.cbm * row.qty).toFixed(3);
frm.refresh_field("items");
}
})

please add this code in your client script

43

image

44

Copy and paste this script in direct client script box without any other place.

45

not working

46

what is the field type of cbm

47

I’m not sure why there are so many discussions on such a small topic, especially since this information is already available in “Frappe Forum.” I could have looked it up myself. There are 40+ discussions about a small client script, which is interesting :sweat_smile:

Please check your field name and set it in the script.

frappe.ui.form.on('Quotation', {
    validate: function(frm) {
        $.each(frm.doc.items || [], function(i, d) {
            frappe.model.set_value(d.doctype, d.name, 'custom_total_cbm', d.cbm * d.qty);
        });
    },
});

@Anjalijangid, Everyone here is new but they are also trying to learn, so you should be patient and try a little yourself :grinning: