Skip to Content
This question has been flagged
record_name
6 Replies
5304 Views
Avatar
Alejandro Perez Cosio

Hello, 
I'm triying to set a default record name as a combination of 2 fields: 
I have a table with 3 columns (just for the example): 

  • name
  • start_date
  • end_date


And I would want to have the name calculated with the following:

def _get_name(...):
    element = self.browse(cr, uid, ids, context=context)
    return '%s -> %s' % (element.start_date, element.end_date)

_columns = {
    'name': fields.function(_get_name, type='char'...)
    ...
}

How can I get that?

Thank you in advance

Avatar
Discard
Alejandro Perez Cosio
Author

The problem here is I wasn't iterating on the element (which should be elements). A res list should also be declared as empty and append the custom name to this list with the record id.

Avatar
Alejandro Perez Cosio
Author Best Answer

This is how I finally got my combined name:

def _get_name(self, cr, uid, ids, name, arg, context=None):
        reads = self.read(cr, uid, ids, ['start_date','end_date'], context=context)
        res = []
        for record in reads:
            name = '%s -> %s' % (record['start_date'], record['end_date'])
            res.append((record['id'], name))
        return res

And for the field:

'name': fields.function(_get_name, type='char', store=True)

Avatar
Discard
Avatar
Jeff Beidler
Best Answer

Hi Alejandro,

Here is the function I used recently to retrieve a combination of two fields as the name:

   @api.multi
    def name_get(self):
        
        retvals = []
        
        for record in self:
            if self.env.context.get('prod_form', False):
                catstring =  "[" + record.name + "] " + record.description
                retvals.append((record.id,catstring))
            else:
                retvals.append((record.id,record.name))
       
        return retvals

In this case, it returns the combination of 'name' and 'description' only when the 'prod_form' context is true.  It should steer you in the right direction, though, as it uses the new v8 API form.  Notice that the function only needs 'self' as a parameter.  All the other variables (cr, uid, ids, context, etc.) are wrapped up in the environment, which is part of 'self'. 

In this post, Marvin helped me understand what (I hope) I explained above.  My original question also contains a link to the API documentation, if you haven't found that already.

I think you also want to declare your field like this:

name = fields.Char(compute='yourFunction_name')

Avatar
Discard
Alejandro Perez Cosio
Author

Thank you Jeff, your answer helps me to understand a little more how odoo works, I'm always building modules with a dictionary for _columns but I will try this on my next module.

Jeff Beidler

That still works. You'll find that Odoo still has a mix of old and new API stuff. That tripped me up for a while, until Marvin pointed out (see linked post) that I needed the @api.multi decorator on my name_get function.

Avatar
Dr Obx
Best Answer

I was looking for something like this recently and suddenly found it but would anyone tell me, I need it for product so if possible to make some changes to make it work with product please?

I need combine 3/4 fields together so as a result the product name should contain brand, model, size,  ...

Can anyone show me exactly how should it look like for product module ?

Avatar
Discard