¿How to make Unique Fields?

[fernando.g]

Hi:

Im testing Sugar CE 6.0.1 and i need to make a unique field. I know how to make (or add) new fields to a module, but i need a "unique" or "not repeatable" kind of field.
For example, if this field is the "ID Number" of a person, i need that Sugar doesnt let anybody have the same "ID Number" value in that field.

My server is using MYSQL 5.0.91-community and PHP 5.2.14.

Any help will be appreciate.

Thanks!.

[davidboris]

Hello,

You can create an auto-increment by extending vardefs. It is not available in studio.

[fernando.g]

Hello,

You can create an auto-increment by extending vardefs. It is not available in studio.

thanks for your response, but thats not quite what i was looking for. auto-increment will make me a unique field, but i dont want an auto-generated value, i need a custom unique value. I mean, the user can put any value (a number or a name) and that Sugar could understand that this value must be unique.

I was thinking that changing or adding a little of code (php and sql) i could make a query that in the action of pressing "save" in a new Account, this code asked to the database if another Account has the same value in this unique field before saving the new Account.
¿Is this possible? and ¿which is the php file that i need to edit to do this?


thanks so much!.

[davidboris]

Hello,

There are two ways, you can either write a before_save logic hook, which will submit your page and shows an error message before saving the record if the condition does not match. But as it saves the form you will loose the values filled in.

Another way is AJAX way, you can write a function onBlur event of the field(file to modify custom/modules/<YOUR_MODULE>/metadata/editviewdefs.php) and call a script which will return true or false. If it returns false, remove the data filled in that field.