Unique reference ID for Opportunities, Accounts, Etc.. with Auto Increment number

💬 General Discussion
1

Hi Techies,

I would like to have Unique reference ID for modules Accounts,Opportunities, Task, Projects. i din’t find any option for auto increment numbering can some help with this feature.

2

I would expect this to work (I need one of these too, but it is trickier because my numbers are alphanumeric and have the year embedded)

  1. Create a custom feild in Suite CRM and add in whatever views you like, but not edit view.
  2. Go into MySQL and make that field an auto increment.

Each time you save a new record, it should get the next highest integer. For my project it seems like logic hooks or MySQL triggers might work, but I haven’t gotten around to trying it.

So options to Google for more info: sugar logic hooks, mysql auto increment, mysql triggers

Sincerely,
sieberta