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

Anjalijangid · July 30, 2024, 7:24am

In my quotation child table a have a column of CBM, I want another column named as Total CBM (CBM X quantity).

Just like there a column of rate and amount.

Kindly assist!

Jeel · July 30, 2024, 7:29am

@Anjalijangid
go to customization of quotation item table and add new field total bdm
frappe.ui.form.on(‘Quotation Item’, { // Replace ‘Quotation Item’ with your child table Doctype name
cbm: function (frm, cdt, cdn) {
let row = locals[cdt][cdn];
row.total_cbm = row.cbm * row.qty; // Calculate Total CBM
frm.refresh_field(“items”); // Replace ‘items’ with the name of your child table field
},
qty: function (frm, cdt, cdn) {
let row = locals[cdt][cdn];
row.total_cbm = row.cbm * row.qty; // Calculate Total CBM
frm.refresh_field(“items”); // Replace ‘items’ with the name of your child table field
}
});
create client script

Anjalijangid · July 30, 2024, 7:33am

Thanks for the reply @Jeel
But i dont have any knowledge of code.
Is there any other way?

Like I have seen, for total they have used Float field-type here, is this information useful ?

Meet · July 30, 2024, 7:37am

@Anjalijangid Please First Add the custom field on your child table then add the client script in quotation doctype and the write this code and test your testcase

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

Anjalijangid · July 30, 2024, 7:39am

What field type shall i select for Total CBM custom field?

This is want i want -

Jeel · July 30, 2024, 8:06am

@Anjalijangid Fieldtype should ne Currency

Anjalijangid · July 30, 2024, 8:11am

Not working -

Jeel · July 30, 2024, 8:16am

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

Anjalijangid · July 30, 2024, 8:18am

Jeel · July 30, 2024, 8:31am

@Anjalijangid remove default code and just paste my code

Anjalijangid · July 30, 2024, 8:34am

Jeel · July 30, 2024, 8:35am

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