Counter type column

The idea is to add counters for all rows. that will keep permanent number after the record was created. Where in the setting you can set a start value.
After the value was assigned, it cannot never be changed.

Example1: I have a board that listing all the tickets open in my company. I want that the ticket will have “up counting” column according to the order they arrived to the board.
Example2: Documenting invoices with “up counting” numbers.

hi @Elad

Welcome to the community. The app “AutoID Column” does do exactly that.

The column is now called “Item ID”. To do what you want, after adding an Item ID column, click on the menu icon for that column, go to Settings → Customize Item ID column. Then choose Custom key and set a Prefix value.

Once you use a Prefix, you can’t use it again on another board. That is because monday let’s you use the value as a unique identifier in URLs. For example, if you chose a Prefix of “TIX” for tickets and kept “Leading zeros” set as 2, your rows would be, TIX-001, TIX-002, etc. and that identifier would stay with the item even if the location of the item changes in the board. You would also be able to access the item by unique URL like this:

your-monday-site/item/T-001

1 Like

Hey!
Thanks for replying!
By changing the order of the raws the auto-id changes as well.
I want something that stay fixed.
As for my example, you not allow to change invoices numbers, even by mistake.

Hey!
Thanks for replying!
By changing the order of the raws the auto-id changes as well.
I want something that stay fixed.
As for my example, you not allow to change invoices numbers, even by mistake.

You need to use the “Item ID” like I suggested, not the “Auto Number”

ID’s generated with the AutoID Column app always stays with the item, regardless of reordering or moving items.

There is no need for a paid service when monday.com has this built in with the “Item ID” column.

Try to move an item with the Item ID column to another board and see how the Item ID changes. When you move an invoice (INV-12345) to a board “Settled Invoices” you don’t want your invoice to get a complete new ID :slight_smile:

BTW… It’s a very basic option at any database / CRM / ERP system…

That’s works. But the number it not sequential…

If you follow my instructions they are sequential, but you can only use each number once per board. If you have items TIX-001 through TIX-012 and you delete TIX-012, the next item you create will still be TIX-013.

This solution isn’t meant for moving items between boards since that was not mentioned in the initial request.