Unique / Customer ID's

[viadesk]

We are trying to find our way around within SugarCRM.

Because we want to identify customers easily we would like to assign a unique ID to them. Preferrably an increasing number.

I have been looking around but could find such functionality. Ofcourse i can add a custom field called Customer ID but then the id woud have te be entered manually, leaving room for mistakes..

Is there such functionality or else does anyone have suggestions how to adapt unique id's into SugarCRM.

TIA,
Viadesk

[mikesolomon]

We are trying to find our way around within SugarCRM.

Because we want to identify customers easily we would like to assign a unique ID to them. Preferrably an increasing number.

I have been looking around but could find such functionality. Ofcourse i can add a custom field called Customer ID but then the id woud have te be entered manually, leaving room for mistakes..

Is there such functionality or else does anyone have suggestions how to adapt unique id's into SugarCRM.

TIA,
Viadesk

you can add an autoincrement field

Go to studio and add a new integer field

Add the new field to display view

Then in your database change the new field in the accounts_cstm table to be an autoincrement field

That will give you a unique id for your accounts

[viadesk]

Thanks for the info,

you can add an autoincrement field

Go to studio and add a new integer field

Add the new field to display view

Then in your database change the new field in the accounts_cstm table to be an autoincrement field

That will give you a unique id for your accounts

So I tried this, i added the field and tried to change it's value. When i try to update the field in mysql i get an error, 'There can only be one autocolumn and it must be defined as a key' So i can't add an extra field and set it to autoincrement since id_c is present and appearantly has autoincrement set already.

But when i add his (id_c) field (to create accounts form for instance) it is shown but not filled. Only when i open the created account there's no number present in the field, i expected it to be filled automatically and it seems it needs to be filled manually. The opposite of what we need in SugarCRM.

This leaves me with some questions
- Why can't i create the field needed according to your info
- Is the id_c field intended to carry a customer id ?
- For which purpose would i use the id_c field ?
- What is the need of an extra field if id_c could do the job

I don't expect all my questions to be answered but it would be nice to have this field in place ;-)

Thanks so far!
Viadesk

[mahichhabra]

Hello, it works well......... thanks