How to use Auto ID
Every new item gets the next ID automatically.
Set it up
- Add a Text column (for IDs like INV-0042) or a Numbers column (for plain numbers) to your board. Call it, for example, "Item ID".
- Open Automate, search for Auto ID, and choose "When an item is created, give the item the next ID in Item ID".
- Choose a prefix (up to 20 characters, Text columns only), how many digits to pad to (0 to 10), and the first number.
IDs continue from the highest ID already in the column, so you can add Auto ID to a board that is already in use.
Number the items you already have
Use the second action, "Number items with no ID", for example with "When a button is clicked". It fills in items that have no ID, oldest first, up to 200 per run. If more are left, the activity log says how many: run it again to continue.
Good to know
- Auto ID does not give the same number to two items, even when they are created at the same moment. A number can occasionally be skipped.
- Auto ID looks at the IDs already on the board only the first time it runs. IDs typed by hand later are not tracked, so lock the ID column (column menu, Column permissions, Restrict column edit).
- An item that already has an ID is never renumbered.
Common messages
- Use a Text or Numbers column: the chosen column is another type. Edit the automation and pick a Text or Numbers column.
- ID column not found: the column was deleted. Edit the automation and pick it again.
- More items to number: not a fault. "Number items with no ID" did 200 items; run it again to continue.