Empty database table, but counting previously deleted things

bensult78 · 2025-03-19T23:22:28.792Z

Hello bubblers,

I tried to debug my issue and look on this forum + google search for more than 1 hour.

I’ll get right to the point, when I create a new invoice (thing), my workflow is supposed to generate an invoice number (ie : 000001) by counting the invoices (things) and add +1.

My issue is that the app is seeing deleted invoices. I mean, there is litteraly zero invoice (thing) in my table “Invoices”, but the app counts what has been deleted.

I can visually see, when I load the page the count of previously deleted invoices for a fraction of a second (ie : 4), then it changes back to the real amount.

So It will create the invoice number 000001 then change it to 000005. If I delete this invoice, it will do the same but write the invoice number 000006 and on and on…