Maybe it's just me but this seems like an obvious validation rule, make sure two fields are not the same value (not case sensitive).

In my instance, I want to ensure two different email fields don't have the same email address i.e. a requestor cannot be the approver of the request.

Comments

svendecabooter’s picture

svendecabooter
he/him
Primary language Dutch
Location Gent
commented
Status: Active » Closed (won't fix)

There is the "Unique values on multiple fields" validation rule, which should do just that.

healthent’s picture

healthent commented

I'm sorry but I do not see that option.

Do you mean choosing "Unique values" as the rule, and selecting two seperate fields? I did just that thinking it would work but was able to enter the same email address for both fields. Is it case sensitive?

svendecabooter’s picture

svendecabooter
he/him
Primary language Dutch
Location Gent
commented
Assigned: Unassigned » svendecabooter
Status: Closed (won't fix) » Active
svendecabooter’s picture

svendecabooter
he/him
Primary language Dutch
Location Gent
commented
Assigned: svendecabooter » Unassigned
Status: Active » Fixed

You are right, it doesn't check for case.
I just committed a fix to CVS that improves the 'unique values' validation check to accommodate this.
You can download the latest dev version once that's packaged, or wait for the next release of this module.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.