Advanced Number Series

In Tabidoo, you can automatically generate sequential numbers for your records. You can even include prefixes, starting values, or reset the numbering monthly or yearly based on a selected date field (e.g. invoice date).

To generate an automatic number in Tabidoo follow these steps:

Add a new field, select field type "Number"

In the field’s Advanced settings, enable: Automatic number series (1...x)

Click on Choose fields... to define how the numbering should behave across the table.

This field will automatically increment with each new record.

Numbering Based on Date Field

You can configure your numbering to restart each month or year, based on a selected date field (e.g. InvoiceDate, ContractDate).

Setup Instructions

Add a Number field and enable the Automatic identifier option.
Click Choose fields...
Select a Date field to group by (e.g. InvoiceDate)

Choose:

Monthly → numbering resets every month
Yearly → numbering resets every year

Example: Monthly Invoice Numbers

`InvoiceDate`	`Number`	Result
2025-06-01	1	`INV-001/06/2025`
2025-06-15	2	`INV-002/06/2025`
2025-07-01	1	`INV-001/07/2025`

Formula for formatted output:

'INV-' + Number.toString().padStart(3, '0') + '/' + (InvoiceDate.getMonth() + 1).toString().padStart(2, '0') + '/' + InvoiceDate.getFullYear()

Note: +1 is needed because JavaScript months are zero-based (0 = January).

Example: Yearly Contract Numbers

'CONTRACT-' + (Number + 1000) + '/' + ContractDate.getFullYear()

This will result in:

CONTRACT-1001/2025
CONTRACT-1002/2025

… and reset to 1001/2026 in the next year.

Hide Helper Fields (Optional)

If you want to hide technical or calculated fields:

Open the field’s Advanced settings

Disable:

Show in grid
Show in edit form

Add a Starting Number (e.g. from 900001)

If you want to begin from a higher number, follow these steps:

Create the base Number field with automatic identifier.
Add a new field of type Calculated field.
In the formula editor, use:

Number + 900000
Replace Number with the actual field name – always insert from the right-hand field list, not manually typed!

Add a Prefix (e.g. `INV-900001`)

Use this formula in a Calculated field:

'INV-' + Number.toString()

'INV-' can be changed to any prefix you need. This converts the number into a formatted string.

Combine Prefix + Starting Number
In the case you want to mix these two options mentioned before, please enter the following JavaScript to the Formula editor:

'prefix' + (Number + 90000).toString();

If you want to hide these fields in the table or in the edit form, open the advanced features and click on the option "Show in grid"/ "Show in edit form". For more information, please visit the chapter - Advanced Features in Table Fields.