Automatic Sequential Numbering

[juniovalerio]

Hi

As Operations Manager for a huge project developer, my current task is to improve the SugarCRM system and one of the most important issues is the creation of a Sugar-based Project Archive.

In the process of structuring an appropriate platform and list of entries, I find myself in the necessities of assigning to each contract input in the database, a tag, more precisely a progressive code of number to be given automatically by the system when I record the project. (0001, 0002, 0003, 0004....000N).


I wonder if this function is already available, is somebody already using it for instance?

Furthermore, how can I set the search criteria in Sugar to find a project using its numeric tag?

Thanks in advance for your time and help.

JV

[genius786]

Hi,

I think this sequential numbering is not available in sugarcrm.


Best regards,

[mvngti]

In the process of structuring an appropriate platform and list of entries, I find myself in the necessities of assigning to each contract input in the database, a tag, more precisely a progressive code of number to be given automatically by the system when I record the project. (0001, 0002, 0003, 0004....000N).

It is not 100% resilient because it is not atomic but this can quite easily be achieved with a custom field and a small bit of custom logic.

Add a custom field project_number_c type integer.
Then create a before_save logic hook that does

 if (empty($bean->project_number_c))
{
     $query "select max(project_number_c)+1 as newnum from project_cstm";
     $res = $bean->db->query($query);
     $row = $bean->db->fetchByAssoc($res);
     $bean->project_number_c = $row['newnum'];
} 
  

if you can risk (the small risk of) getting duplicates if two projects are saved in a very short time then this is your easiest solution. Otherwise you will have to declare the field project_number_c as auto increment in the database after sugar created it.

[daniel.passarini]

Also, you can try a MySQL solution, by creating an auto_increment column, so you dont need to customize sugarcrm.
here is a simple example:

 ALTER TABLE `your_table` ADD `project_number` INT NOT NULL AUTO_INCREMENT 
  

[Rudi Mentär]

I have an auto_increment, but it increments also on an update?
How can i achive, that the field only increments when adding NEW Data and not when CHANGING Data?

[andopes]

In the last post by Marnus van Niekerk

Add a code into logic_hook function to identify if this record is a new one or an old one.
This way you can conditionally increment.

Cheers

[SugarDev.net]

Do not try to alter the db via direct SQL. Sugar will still try to update the field on a save.

Tell Sugar it's a auto_increment field, explained here: http://www.sugarcrm.com/wiki/index.php?title=Int.

[Rudi Mentär]

i heard that with logic hooks it might be able to cause lost updates?

[labanjohnson]

How could we have forgotten the all important Account Number?!