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

[Anjalijangid]

[Jeel]

@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”);
}
})

[Anjalijangid]

[Jeel]

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

[Anjalijangid]

Now the codes are correct but its not working

its showing zero instead of 10X0.464

[Jeel]

@Anjalijangid when your form is saved its working

[Anjalijangid]

Its saved, but not working
Also, CBM is not in currency format its just in numbers

[Jeel]

@Anjalijangid change to total cbm to fieldtype float

[mubasher-hasan]

you are making changes in the cbm field and in refresh field you have written items…??

[mubasher-hasan]

[Jeel]

@Anjalijangid try this @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;
frm.refresh_field(“items”);
}
})
i take wrong fieldname total_cbm instead of custom_total_cbm

[mubasher-hasan]

instead of item use the field name of total cbm

[Anjalijangid]

Its working now, But cant not change decimal values
I need three values after decimal

[Jeel]

@Anjalijangid go to field properties set precision 3

[Anjalijangid]

I have zero knowledge of coding.

[Anjalijangid]

Done, still same issue

[mubasher-hasan]

Frappe Community is here for the assistance

[mubasher-hasan]

share the image of your doctype properties

[Meet]

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

find this field and select as per requirements

[Anjalijangid]