Skip to Content
This question has been flagged
computestudiocomputed-fieldsStudio
2 Respostes
6316 Vistes
Avatar
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...


Avatar
Descartar
Avatar
Vincent GUILLAUME
Best Answer

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 ?

Avatar
Descartar
Avatar
Eman Abdulmalik
Best Answer

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



Avatar
Descartar
Related Posts Respostes Vistes Activitat
Error message when clicking any item on any page in the studio editor
studio Studio
Avatar
Avatar
1
d’abr. 25
2456
odoo studio how to create parent and subcategory in new custom module
studio Studio
Avatar
Avatar
1
de febr. 24
3803
Computed Field Using Two Different Models
computed-fields Studio
Avatar
Avatar
1
d’abr. 24
3878
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
Avatar
0
de febr. 24
3244
New group label like Sales in Contacts (v14)
studio Studio
Avatar
0
de set. 21
2675