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