I have a very basic custom object in which I need to prevent duplicates(exact match).  I cannot just use a "unique" value though, because in certain circumstances duplicates should be allowed.  What I want to do is create a validation rule where if an "override" box is checked the rule will allow duplicates, but otherwise it won't.  Can someone please help me with the code?

 

Initially I tried:

 

REGEX ( field , field)  The only problem is that it checks itself and thinks every entry is a duplicate.

 

Please help!

I have a very basic custom object in which I need to prevent duplicates(exact match).  I cannot just use a "unique" value though, because in certain circumstances duplicates should be allowed.  What I want to do is create a validation rule where if an "override" box is checked the rule will allow duplicates, but otherwise it won't.  Can someone please help me with the code?

 

Initially I tried:

 

REGEX ( field , field)  The only problem is that it checks itself and thinks every entry is a duplicate.

 

Please help!