Unique user Names

[rmorgan]

It seems that ESPOCRM allows more than one user to have the same name, e.g. I could have two people called 'Fred Bloggs'. This will cause potential issues when running reports. Is there a way to enfore unique names? I believe it already does this with usernames.

[shalmaxb]

I did not test it, but you could try to prevent that with API Before Save Script formula, like so:

// Assuming you want to prevent duplicate username in user
if (recordExists('User', 'userName = ' + this.userName)) {
throw new Error('this Username already exists.');
}

[yuri]

Correction:

if (record\exists('User', 'userName=', userName)) {
    recordService\throwConflict("User already exists.");
}