ValueError: ValueError singleton

Question

Hello,
In below code, product_id is my Many2many field of product1 table and price is a field of that table When i select more than one product in Many2many field, I get this error :  ValueError: Expected singleton:
product1.product1(2, 4)   . can anyone help me.
Thanks in advance.

Code:

total = fields.Float( "Total" , readonly = True , compute = "count" )
product_id = fields.Many2many( 'product1.product1' , string = "Products" )
@api.onchange ( 'product_id' )    def  count ( self ):      for

Mitul Shingala · Accepted Answer

Hello,
in your code product_id is many2many field. and into method line: i.product_id.price, you get the multiple product ids. that's why you get singleton error.make below change into your code:

@api.onchange('product_id')
def count(self):
for i in self:
total = 0
*for prod in i.product_id:**
**            total += prod.price**
*        i.total = total

Dhaval Desai · Answer

Hi Ruturaj,
ValueError: Expected singleton:  product1.product1(2, 4)  it means  product_id  return multiple records you can not directly assign values.
*Example:*
@api.onchange('product_id')
def count(self):
for i in self:
total = 0
for p in i.product_id:
total += p.price
i.total = total
Thank You.

Ruturaj Chavda · Answer

Related Posts	Replies	Views
Error with singleton value valueerror singleton	4 Mar 24	299
Odoo 11.0 ValueError: Expected singleton on create operation Solved create valueerror singleton	4 Dec 19	4305
Wrong value for crm.lead.service: <odoo.fields.Selection> valueerror	2 Jul 23	1226
ValueError: Expected singleton (odoo 14) Solved expected valueerror singleton v14	1 Dec 20	12734
ValueError: Wrong value for medical.teeth.treatment.state: 'termin\xe3\xa9 valueerror	5 Feb 20	8021

This question has been flagged

Enjoying the discussion? Don't just read, join in!