auto-increment id

[jcb23]

Windows XP and Vista
Sugar 5.1.0b
Apache 2.2.4
PHP: 5.2.3-1ubuntu6.3
MySQL Server: 5.0.45-1ubuntu3.3

I need an id to show for contacts, opportunities, accounts and leads that is not the really long id that is automatically associated with the record, but is a simple integer that auto-increments as records are created. The field should be one that our users can't edit, but only see and search by - basically its a surefire way to get a particular record.

I've created the field identification_number_c and when we moved to the sugar database from our old database I plugged the old id numbers into this field and its working beautifully. The only problem is the auto increment from here on out. I can't seem to get the field to automatically increment (when a new record is created) starting from the highest number that's already in the field.

Any suggestions?

jcb23

[sugarcane]

Hello,

have you taken a look at this posting?: http://www.sugarcrm.com/forums/showt...ent+logic+hook

[kuske]

With
ALTER TABLE tabname AUTO_INCREMENT = startvalue;

you can set a start value for the auto íncrement function.

[andopes]

With
ALTER TABLE tabname AUTO_INCREMENT = startvalue;

you can set a start value for the auto íncrement function.

The Kuske suggestion works pretty fine and you can persist this alter table code into module vardefs, just create an extended vardefs for the module adding a index for that field.
Have a look in the cache/modules/Cases/Casevardefs.php

Cheers

[jcb23]

The Kuske suggestion works pretty fine and you can persist this alter table code into module vardefs, just create an extended vardefs for the module adding a index for that field.
Have a look in the cache/modules/Cases/Casevardefs.php

Cheers

Can you give me an example of that this code should look like? I tried using that Cases file as an example, but wasn't able to get it to work.