Skip to Content
This question has been flagged
pythonautomatedrecordautomatic-actionOdoo12
2 Replies
5358 Views
Avatar
Gerald

When changing the state of a project, I need to write a number to the related product. Project and product have a many2many relationship:

Project_model: product_field -> many2many <- Product_model: number_field

This should be possible by adding "Automated Actions" to project model. I tried with something like that:

for record in records:
    product = record[('x_product)]
    product[('number')] = record.calc_value

When triggering the state change, I get this error:

"Expected singleton: product.template()" while evaluating
Avatar
Discard
Avatar
Jake Robinson
Best Answer

The record['field_name']=value syntax is only used for a single record. Since 0, 1 or more products may exist, use records.write({'field_name':value})

Avatar
Discard
Gerald
Author

Thanks for the answer, that looks promising.

But it seems that I have a basic problem with the relation: Do I need to load the product with something like that before I can access it?

products = env['product.template'].search(['id', '=', record.x_product])

Or do I have direct access to the product as it is already related with a many2many relation? Then I could directly apply the action:

record['x_product'].write({'number': record.calc_value})

None of the actually works.

PS: Is there any easy method to print values (like python print) in the Automated Actions?

Related Posts Replies Views Activity
Automated Action to Python Code Solved
python automatic-action
Avatar
Avatar
Avatar
Avatar
Avatar
5
Dec 23
23904
Server Action: Automatic Check Availability
automated automatic automatic-action
Avatar
0
Mar 24
2554
How do I programatically click the Create button in my Wizard? Solved
automated automatically automatic-action
Avatar
Avatar
Avatar
3
Jan 24
9112
creating automatic scheduled job to archive tasks
python automated scheduler
Avatar
Avatar
Avatar
2
Feb 23
4980
Python expression doesnt work
python expression automatic-action
Avatar
0
Nov 22
3195