How count the number of row in a table?

Hello everyone,

I use Baserow to do my business invoicing. In France, it is now mandatory to have a last invoice number without interruption between two invoices.

For example, 2023-001 and the next 2023-002 are ok.

But 2023-001 and the next 2023-003 are not accepted.

I thought about using row_id() but with this requirement it is not possible. So I would like to use the row_id counter but I can’t find it.

Do you have an idea to get the line number even if a line is deleted?

Thanks a lot for your help,


PS: Sorry for my bad english :slight_smile:

Hey @Gorki,

I think you need this feature: Field Type: Autonumber (#811) · Issues · Baserow / baserow · GitLab

I’ll start working on this very soon, and we expect to have it before the end of the year.
In the meantime, I’m afraid the only way is to do it manually: by creating a numeric field and sorting the view by that field. It will be enough to increment the value of the row by 1 for each new invoice.

I hope this helps,

1 Like

Hi @davide,

Than’ks a lot for the answer and for you work !

It’s exactly yhe feature I need.

Have a good day,