Calculate the fields

Frappe Framework Custom Script
1

How to get the sum of the two fields in the same form using custom script? Can you explain me the code on how to do it? I’m new in erpnext.

2 
frappe.ui.form.on("doctype_name", "validate", function(frm) {
  frm.set_value("field3", frm.doc.field1 + frm.doc.field2);
})

The above code will set sum of field1 and field2 in field3 on saving of the form.

1 Like
3

Hi THANK YOU VERY MUCH ! it’s a big help. Still, can I auto-calculate it without saving the form?

4

Following code will calculate field3, on change of field1 / field2:

frappe.ui.form.on("doctype_name", "field1", function(frm) {
  frm.set_value("field3", flt(frm.doc.field1) + flt(frm.doc.field2));
})

frappe.ui.form.on("doctype_name", "field2", function(frm) {
  frm.set_value("field3", flt(frm.doc.field1) + flt(frm.doc.field2));
})
4 Likes
5

Wow … Thank you very much … however, there is a logical error, the field3 displays wrong output, like i input on the field1 “1” and the field2 “1”, it displays “11” on the field3.

6

Its working now! Thank you so much sir!

1 Like
7

Fieldtype of of all the fields should be Int / Currency / Float. Seems like you have set it as Data.