Hello, With studio, I have added a float field. I would like in Advanced Properties ‘compute’ a calculation. The calculation is working fine. But now, I want to add a condition ‘if contains’. I have tried with if (record.taxes_id.__contains__(‘test')): if record.taxes_id == “test": The first one is not working and the second one is working if the field is for instance a char. However taxes_id is a M2M, which is the issue. - I have tried to add a [0] after taxes_id but the result is always false

All Posts คน เหรียญรางวัล

แท็ก (View all)

odoo accounting v14 pos v15

เกี่ยวกับฟอรั่มนี้

ช่วยเหลือ

Studio compute field with condition

compute studio computed-fields Studio

2 ตอบกลับ

7418 มุมมอง

Emilia Taylor

Hello,

With studio, I have added a float field. I would like in Advanced Properties ‘compute’ a calculation. The calculation is working fine. But now, I want to add a condition ‘if contains’. I have tried with

if (record.taxes_id.__contains__(‘test')):
if record.taxes_id == “test":

The first one is not working and the second one is working if the field is for instance a char. However taxes_id is a M2M, which is the issue.

- I have tried to add a [0] after taxes_id but the result is always false
- I have tried to add in a char field : for record in self: record['x_studio_test2'] = record.taxes_id, in order to see the value. It’s for instance (account.tax(1,).
- If I do the same with [0], I have still the same result.
- If I do the same with if record.taxes_id == "account.tax(1,)": I have always false.

How could I do to have my condition that research inside the table ? The goal is to say if 1 (or something else like to a value in a table of a M2M(taxes_id)) that works. Means that is not always false...

Vincent GUILLAUME

Hi, i have the same problem with a condition based on single bolean field :

ASS EXT : True

This is the calculated field :

for record in self:
if x_studio_assist_ext == TRUE:
record['x_studio_primes_ttc_12'] = record.x_studio_rc_cost + record.x_studio_mr_costs + record.x_studio_dm_cost + record.x_studio_cots_assist + record.x_studio_cond_cost + record.x_studio_pj_cost
else :
record['x_studio_primes_ttc_12'] = 0

and it do not work ...

Could you help me ?

Rimes App, Eman Abdulmalik

Hello

First set a boolean value, then loop through the many2many fields and do an OR operator like below:

Many2many field is - tax_ids
Boolean variable is - control_var


control_var = False

for i in record.tax_ids:
    control_var = control_var or i.name == 'test'

if control_var == True:
    //this will be your condition

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!

สร้างบัญชีวันนี้เพื่อเพลิดเพลินไปกับฟีเจอร์พิเศษและมีส่วนร่วมกับคอมมูนิตี้ที่ยอดเยี่ยมของเรา!

ลงชื่อ

Related Posts	ตอบกลับ	มุมมอง
Error message when clicking any item on any page in the studio editor studio Studio	1 เม.ย. 25	3500
odoo studio how to create parent and subcategory in new custom module studio Studio	1 ก.พ. 24	4613
Computed Field Using Two Different Models computed-fields Studio	1 เม.ย. 24	4981
computed field made in Odoo Studio that can be calculated on base of two other field or set by the user based on if the depending fields have a value. studio computed-fields	0 ก.พ. 24	3993
New group label like Sales in Contacts (v14) studio Studio	0 ก.ย. 21	3318

คำถามนี้ถูกตั้งค่าสถานะ

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!