Skip to Content
This question has been flagged
linetablerowsv14
2 Replies
5846 Zobrazenia
Avatar
Nikita

Hello!

I have a table like this:

row_numbersome_data_1some_data_2
1

2


And I want the row_number to be automatically set to values ​​starting from 1


How can I do it?

What code can I write in "Advanced Properties - Compute" on the row_number field?


I tried to do like this:

increment = 1
for record in self:
  record['row_number'] = increment
  increment = increment + 1

But when trying to add new lines - new lines start at 1 again


Help, please!

Avatar
Zrušiť
Avatar
Osman Alrasheed
Best Answer 
Using Odoo Sequence you can implement your idea 
firs create the sequence using xml code 
then in py file call you sequence like following cod:
 
@api.model
def create(self, vals):
    vals['row_number'] = self.env['model.model'].next_by_code('cod.cod')
    return super(ClassName, self).create(vals)


Avatar
Zrušiť
Avatar
Fabio Barbero (faba)
Best Answer

Hi!

Why don't you just retrieve the id of the record :)? When a new record is created, Odoo will automatically give it as an ID the next number in the list (so that it's always unique). You can retrieve it with record.id.

You may also have a look at the Getting Started tutorial in Odoo Docs if you haven't already ;) :https://www.odoo.com/documentation/15.0/developer/howtos/rdtraining/04_basicmodel.html

Hope this helps!

Best,

Fabio

Avatar
Zrušiť
Nikita
Autor

I had an attempt to do it with code like this, however it throws an error because record.id is not "int" at this point:
id_on_start = record.id
for record in self:
record ['row_number'] = int (record.id) - int (id_on_start) + 1

If you know the code with which I was able to get the id of the created record of type "int" I will be very grateful. Or if you can suggest another way - I will be very happy

Related Posts Replies Zobrazenia Aktivita
Additional Form table rows
table rows
Avatar
0
okt 15
4888
How do you add new rows to a web site table? Solved
table rows website_builder
Avatar
2
nov 22
7849
Change the default number of row in a tree view Solved
treeview default table rows
Avatar
Avatar
2
dec 23
5453
How to override css from this table lines? Solved
line css override table
Avatar
Avatar
3
feb 17
7357
Odoo14 alternative for Automated Translations through Gengo API module
v14
Avatar
Avatar
Avatar
Avatar
3
sep 25
3573