Generate correlative invoice number

AppSheet AppSheet Q&A
1

Hi guys

I have this table Table “InvoiceHeader”, Fields “InvoiceHeaderID”, “InvoiceNo”

In the “InvoiceNo” field I have to generate an invoice number for each sale, using this format (002-002-01-00100001)

I have used this formula, but it does not work since it does it by row, and I do not want it by row, I want it to filter the previous number and add 1 to the new record and so on

CONCATENATE(“002-002-01-” & RIGHT((“00010000” & ([_RowNumber] )), 8))

2

https://community.appsheet.com/t/serial-numbers-if-you-must/19325

3

Thank you, I already solved it in another way, that I need to control the consecutive