function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
jwright33jwright33 

Validation Rule - Lookup data in account

I have a field Support password in my account record.  I'd like to setup a Validation Rule that looks at all of the support passwords in the database when creating a new account.  If the user enters a password that matches a value that has already been used, I want to throw an error. 

 

Is that possible using validation rules?

Best Answer chosen by Admin (Salesforce Developers) 
Steve :-/Steve :-/

In the field properties you can select "No Duplicate Values" as well as Case Sensitive/Case Insensitive.  

That should take care of it without the need for a VR  

All Answers

Steve :-/Steve :-/

In the field properties you can select "No Duplicate Values" as well as Case Sensitive/Case Insensitive.  

That should take care of it without the need for a VR  

This was selected as the best answer
jwright33jwright33

Thanks Steve.  That is what I was looking for.  Not sure why I was trying to make this more complicated than I needed to.