Howto generate a unique (autoincrementing) number in custom modules

[dushara]

Hi all,

I just started looking at SugarCRM to see if it can help me set-up a simple system to manage simple business transactions. For the transaction record (a module I created) I need an auto incrementing (read-only) number field that I can use as a receipt number - similar to the number field in the bug tracker. So far I haven't been able to figure out how to do this.

I even tried using http://kb.sugarcrm.com/custom/studio...dule-editview/ as a guide but without much luck.

How can I get the behaviour I'm after?

Thanks in advance.

dushara

[mtvtaras]

Hi dushara!

You should write in vardefs.php

 $dictionary['module_name'] = array(
................
  'inc_field' =>
  array (
  .........
    'required' => false,
    'name' => 'inc_field',
    'vname' => 'LBL_FIELD',
    'type' => 'int',
    'len' => '20',
    'auto_increment'=>'true',
  .........
  ),
  .............
 
),
   'indices' => array (
   0 =>
   array(
      'name' =>'ind_inc_field',
      'type'=>'unique',
      'fields'=>array(0 => 'inc_field'),
    ),
),
...............