How to add a Autoincrement field for Account and Contacts

💬 General Discussion
2

Hi there,

To do this, don’t add the field via Studio, add a new file in custom/Extension/modules/yourmodule/Ext/Vardefs e.g. autoincrement.php with the following :


<?php
	 $dictionary['YOUR_MODULE']['fields']['NAME_OF_AUTO_INC_FIELD'] =  array(
            'name' => 'NAME_OF_AUTO_INC_FIELD',
            'vname' => 'LBL_LABEL_OF_AUTO_INC_FIELD',
            'type' => 'int',
            'readonly' => true,
            'len' => 11,
            'auto_increment' => true,
           'disable_num_format' => true,
        );
?>

and also add unique index for the field in that file


<?php
	 $dictionary['YOUR_MODULE']['indices']['NAME_FOR_INDEX'] = array(
            'name' => 'NAME_FOR_INDEX',
            'type' => 'unique',
            'fields' => array('NAME_OF_AUTO_INC_FIELD'),
        );
?>

Run a Quick Rebuild and Repair in Admin -> Repair and execute the changes.

Thanks,

Will.

2 Likes