In a formula column, the SUBSTR () function allows you to extract a certain number of characters of your choice contained in a character string from a location that you specify.

You can for example use this formula to create an automatic numbering sequence for your invoices.

Formula

SUBSTR(Desired column, starting character, number of characters)

The first parameter is the column containing the character string.

The "0" defines from which character you want to apply the formula.

The "," is our separator here. TimeTonic uses the default separator ",".

The "3" indicates that you want to extract 3 characters.

Example

SUBSTR(Type, 0, 3)

I want to automatically create a numbering sequence for my invoices according to the type of document (a quote, an invoice or a credit in this case).

And here is the rendering, the column "Devis N°" returns the type of document and allows you to generate an automatic numbering of your quotes, invoices or credit notes: