Se rendre au contenu
Cette question a été signalée
computestudiocomputed-fieldsStudio
2 Réponses
6173 Vues
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
Ignorer
Avatar
Vincent GUILLAUME
Meilleure réponse

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
Ignorer
Avatar
Eman Abdulmalik
Meilleure réponse

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
Ignorer
Publications associées Réponses Vues Activité
Error message when clicking any item on any page in the studio editor
studio Studio
Avatar
Avatar
1
avr. 25
2267
odoo studio how to create parent and subcategory in new custom module
studio Studio
Avatar
Avatar
1
févr. 24
3680
Computed Field Using Two Different Models
computed-fields Studio
Avatar
Avatar
1
avr. 24
3701
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
févr. 24
3135
New group label like Sales in Contacts (v14)
studio Studio
Avatar
0
sept. 21
2606