calculated field in form

Question

hello,

trivial question came to me, but - shame on me - I was not able to provide simple answer; considering I have two fields in form:

</group>

is there a simple way to add third field, which will show sum of above? something like "x_po+x_sz"?

regards

Tomasz

Hilar Andikkadavath · Accepted Answer

Make the third field as compute field
in your script just compute the total of two fields and return the value
if you need to display the total sum you just need to give sum="thirdfield" in your tree view
@api.one
def _get_total(self):
try:
self.thirdfield = self.first + self.second
except:
raise "here add your exceptions"
thirdfield = fields.Float(compute='_get_total', string="")

Ameera PP · Answer

create a new field x_po_plus_x_sz

@api.onchange('x_po','x_sz')
def getsum_x_po_x_sz(self):
if self.x_po and self.x_sz:
self.x_po_plus_x_sz=self.x_po + self.x_sz

Faycel Gsouma · Answer

You need to make a compute field for the third one with an onchange annotationthirdfield = fields.Float(compute='_compute_sum', string="SUM")
@api.onchange('x_po','x_sz')
def _compute_sum(self):
self.thirdfield = self.x_po + self.x_sz

Axel Mendoza · Answer

Hi Tomasz
You need to add a calculated field that compute the calculation and if you wanna make it more dynamically you could add also an onchange for the source field for the sum to provide the result without the need of saving the form
Read more about it in the docs
https://www.odoo.com/documentation/10.0/reference/orm.html#fields

MONEO Tomasz Serwanski · Answer

hello,

thank you for answers; I had hope it is to be done inside form view - but I guess code as above is to be added somewhere else, am I right? if yes - sorry for asking - where to insert code as above:

---
@api.one
def _get_total(self):
try:
self.thirdfield = self.first + self.second
thirdfield = fields.Float(compute='_get_total', string="")
---
regards
Tomasz

المنشورات ذات الصلة	الردود	أدوات العرض
Calculated field not working fields field calculated	3 سبتمبر 23	3106
Project module or fields field	0 فبراير 25	2189
extra checkout step field	0 يناير 25	1903
Field service upgrade تم الحل field	1 ديسمبر 24	2420
How to set field parameters like "group_operator=False" when creating a new field from a python function? field	1 يونيو 22	6866

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!