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

Frappe Framework Customization
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

27

Frappe Community is here for the assistance :star_struck:

1 Like
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’')