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.
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:
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.
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
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.