Need a field formula that inserts a unique and sequential number?

Good to know.  Thanks for the update.

Happy Invoicing.

Tim

Related to the requests for an automatically incremented number, these people seem to make it simple:

https://support.knack.com/hc/en-us/articles/230231768-Start-an-Auto-Increment-Field-from-Any-Number

By the way, my post wasn't meant to plug that product, just to show how a simple implementation of a sequential number.

Problem is when you make use of the record ID is when you delete a record the numbers wouldn't be in a sequence annymore. So 2019+recordID is not a good idea.

Is it possible to make TFH001 sequential then TFH002, I understand the sequential scriptt but I ideally need it with the suffix TFH

I also have som problems with the Invoice numbering. I want number my invoices without the year-prefix (e.g. 120, 121, 122 etc...) and start on a specified number. 

When inserting the code mintioned here earlier 

let before := max((Table1).Invoice No.);
Invoice No. := before + 1 

To make sure there aren'r anything I've messed up I tried this with a new epty Invoice template.

When using the code above it results in 1, 11, 111, 1111, 11111 etc. 

How do I correct that and how I define a start value?

Have also a look at this thread : https://ninoxdb.de/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/create-tables-with-autonumbering-with-ease.-5d5ee82ab6ba1f2dab0664b4

Mats before must be a number     let before := number (max((Table1).Invoice No.));
Invoice No. := before + 1