How do you auto increment an "ID" field for every opportunity record?

We are trying to create a field in Opportunities that automatically assigns an auto-increment value to each new Opportunity. This is with an On-Demand instance, so we have no access to code.

Any suggestions would be greatly appreciated!

Many thanks, James.

0 Vin3 Vin3 over 9 years ago

hi James,
The first 2 options I know of are the following modules:
https://www.sugaroutfitters.com/addons/cm-sugar-sequencing-addon?tag=Vincent

http://www.sugarforge.org/projects/autoincrement/

Also, there may be a way to use calculated fields to achieve this, but not sure.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Les Papier over 9 years ago in reply to Vin3 Vin3

Here is a before_save logic hook on Opportunities that works in 6.x:

if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class Save_Opportunity
{
function newOpportunity($bean, $event, $arguments)
{
//custom field z_opportunity_id_c is an auto-increment field in Opportunities
$start = $bean->z_opportunity_id_c;
if ($start != 0)
{ return; }

//The auto-increment seed/value in this example is stored/held in the Users module
// custom field z_opportunity_id_c, for a user with some IM Name

$opp = BeanFactory::getBean('Users');
$where = "users.messenger_id='some_id_name'";
$opp_list = $opp->get_full_list("", $where);
if(! isset($opp_list))
{
   $GLOBALS['log']->fatal("IM name not found");
}
else
{
   $the_opp=$opp_list[0];
   $start =$the_opp->z_opportunity_id_c;
   $bean->z_opportunity_id_c = $start+1;
// auto-increment for next save
   $the_opp->z_opportunity_id_c = $start+1;
   $the_opp->save(FALSE);
}
}

}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Strategie di Sviluppo over 8 years ago in reply to Vin3 Vin3

400$ ??
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 cent cent over 8 years ago in reply to Vin3 Vin3

Hi James,

You can always request the sugar support to have a copy of your OD instance. They will provide you with a zip of the files and db for your instance. With these you can deploy it on your local machine. You can always use this local copy to create your customizations.
If your customization is fine you might want to package it then upload and install it to your OD instance.
With regards to your auto increment field on the opportunity. You can create an int field then add on the vardef of the field 'auto_increment' => true
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Emil Maran over 8 years ago in reply to Vin3 Vin3

Or just follow this tutorial (works for both, Sugar6 and Sugar7 ):
http://www.sugarcrmcolombia.com/produccion/wiki/?p=29
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Strategie di Sviluppo over 8 years ago in reply to Emil Maran

Hello,

I saw that I can create a custom form based on the standard cases module, where there is an id field with autoincrement. This may be another way to create a custom form with an id field with autoincrement?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Peter Hogan-De Paul over 8 years ago in reply to Emil Maran

Unfortunately this link is now broken.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Emil Maran over 8 years ago in reply to Peter Hogan-De Paul

I saved the article here as backup:
Custom AutoIncrement Field in SugarCRM · GitHub
Hope this helps
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel