Is it possible to change the next Case Number value?

[neiltancock]

Hi all, I've a fairly new installation of EspoCRM and I love it. At the moment my case numbers are in the 300 range and I would like to increase that number to something higher. It's purely for optics.

Is there a way to set the next number that Case Number auto-increments on? My next case number is 379 and I'd like to be 100379.

Many thanks,

Neil

[Maximus]

Hello.
The system checks the number column in the DB and assigns the next number. If you want to force the system to store this number with the prefix '100' you can try to create a formula for the Case entity with using the string\concatenate(STRING_1, STRING_2) function.