You need to sign in to do that
Don't have an account?
Dinu
validation rule based on role is not working
Hello All,
I am writting a validation rule on a field "Company" of user object. My criteria is if user's role is begins with "Cust" then "Company" name can not be "Test1" and "test2". Below code is not working.
I am writting a validation rule on a field "Company" of user object. My criteria is if user's role is begins with "Cust" then "Company" name can not be "Test1" and "test2". Below code is not working.
NOT(AND( BEGINS($UserRole.Name, "Cust"), OR(UPPER(Company) = "Test1", UPPER(Company) = "test2") ) )
All Answers
you should delete the NOT. Raise the Message when (User Role starts with Cust) and (Company equals Test1 or Company equals Test2) is true.
If this helps, please mark as Best Answer to help others too.
Oliver