Can I set the Autonumber field to start at a different value?
We're looking to use the new Autonumber field feature on Leads to replace an existing custom field that we created to do a similar thing before this feature was available. We want the autonumber to start not at 0000001, but at where the other number left off (which now is 1026579). Hoping there's a setting somewhere I can make this change to utilize this feature.
Like
Lena Smetnenko,
While there is no yet interface that would allow the user to configure this manually, the following steps need to be performed.
Instructions:
- Determine the UId of the auto-numbered column.
- Using the script, set a new number for the column. In the examples, "4a40180c-61bf-de86-2f08-b05852a5ea6d" is the UId of the auto-numbered column, and "1" is the next value from which the auto-numbering will start.
MSSQL script:
ALTER SEQUENCE [4a40180c-61bf-de86-2f08-b05852a5ea6d] RESTART WITH 1;
PostgreSQL script: SELECT setval('4a40180c-61bf-de86-2f08-b05852a5ea6d', 1, false);
Hello Andriana!
In order to reach the goal, you need to find a system setting with the code "CaseLastNumber" and set its default value to the prefered one from which the autonumber shall start.
Kyrylo Iudin,
Hi Kyrylo, what about when we have created a new section in Freedom UI designer and used autonumbering feature there? What system setting is used for that?
Lena Smetnenko,
While there is no yet interface that would allow the user to configure this manually, the following steps need to be performed.
Instructions:
- Determine the UId of the auto-numbered column.
- Using the script, set a new number for the column. In the examples, "4a40180c-61bf-de86-2f08-b05852a5ea6d" is the UId of the auto-numbered column, and "1" is the next value from which the auto-numbering will start.
MSSQL script:
ALTER SEQUENCE [4a40180c-61bf-de86-2f08-b05852a5ea6d] RESTART WITH 1;
PostgreSQL script: SELECT setval('4a40180c-61bf-de86-2f08-b05852a5ea6d', 1, false);