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

Frappe Framework Customization
7

Not working -

image
image1272×458 34.6 KB

8

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

9

image

10

@Anjalijangid remove default code and just paste my code

11

image

12

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

13

image

14

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

15

Now the codes are correct but its not working

its showing zero instead of 10X0.464

image

image
image769×220 10.9 KB

16

@Anjalijangid when your form is saved its working

17

image
image717×689 21.3 KB

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

18

@Anjalijangid change to total cbm to fieldtype float

19

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

20

image (1)
image (1)1272×458 36.7 KB

:sweat_smile: :sweat_smile:

21

@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

1 Like
22

instead of item use the field name of total cbm

23

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

image

24

@Anjalijangid go to field properties set precision 3

25

I have zero knowledge of coding. :no_mouth:

26

Done, still same issue