Tip #1414: Enforce unique email but ignore inactive records

Large field of yellow poppies with a single red poppy in the middle

Alternate keys are great way to enforce uniqueness of the column values. For example, if you want lead emails to be truly unique, just add an alternate key and no user will be able to bypass that (unlike the duplicate detection which is a fairly timid mechanism). The challenge is when you want that uniqueness […]