Is it possible to change the next Case Number value?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neiltancock
    Junior Member
    • Mar 2019
    • 3

    #1

    Is it possible to change the next Case Number value?

    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
    Senior Member
    • Nov 2018
    • 2731

    #2
    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.

    Comment

    • flashspalt
      Junior Member
      • Aug 2025
      • 1

      #3
      The best way I've found to do this is to set the auto-increment value on the DB itself. The table you'd modify is 'case'. For instance, for MariaDB you would do:

      Code:
      USE espocrm;
      ALTER TABLE `case` AUTO_INCREMENT = 10000;
      Then, your next case# would be 10000.

      Comment

      Working...