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.

Parents

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

Reply

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

Children

No Data