One of the great things about helping newer members of the SugarCRM community is that they often help me remember some customization needs that are not frequently asked by others.
A good example of this came up just a few days ago on the SugarCRM Forums when a user asked if it was possible to change the starting point for the numbering sequence on Cases. By default, SugarCRM begins at the number 1 and automatically increments it by 1 whenever a new Case is added. However, many users would prefer it to start at a different number.
So, how does one change the start point?
It is actually rather simple and requires two things: access to a MySQL administrative tool such as SQLyog, phpMyAdmin, etc. and a single SQL command.
Assuming you already have access to the administrative tool, executing the following command would do the trick for you:
ALTER TABLE cases AUTO_INCREMENT = nnn;
Where nnn represents the starting number you wish to apply. For example, to set the starting point to 1000, use the following command:
ALTER TABLE cases AUTO_INCREMENT = 1000;
That is it! Quick and easy!
Welcome to cheleguanaco's blog (AKA Angel Magaña), a small corner of the blogosphere dedicated to my insights on SugarCRM which I hope you will find helpful.
good
ReplyDeletehow to create a dependet drop down in the sugarcrm comunity edition ,pls post me link
ReplyDeleteDownload and install the DevToolKit module from sugarforge.org. You can use it to create dependent drop downs. Make sure to download the manual/user guide as well.
Delete