3

So, Validation rules return true when you want an error to occur UPPER(LastName) = 'TEST' is what you want, this covers, TEST, test, test, TeST, etc


2

As I said in an answer to one of your previous questions, you shouldn't mix AND() and &&. Either one is fine, but pick one and stick with it. Mixing and matching like you're doing here can lead to simple bugs that take longer to figure out and fix. The other main issue is that your concept of when/how validation rules fire appears that it might not ...


1

Please note that you need to navigate to the object the rules are on, at which point you will see Validation Rules as one of your view options, along with Details, Fields & Relationships, etc. Second important note, a Custom Setting is not best practice for this requirement. You should instead use a Custom Permission which you can add to any Profile or ...


1

Cropredy's approach is the one I'd take, but if we wanted to stay close to your original attempt, what changes would we need to make (and why do they work)? Re-wording the first bit of cropredy's answer, validation rules prevent the update of a record when the validation formula evaluates to true. AND(LastName <> "Test", LastName <> &...


Only top voted, non community-wiki answers of a minimum length are eligible