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
Gerardo Rodriguez LaraGerardo Rodriguez Lara 

Validation Rule - unique text field with commas

Hello, I have a text field with values ​like: " Cats , dogs " or "banana , apple, orange ". The values ​​are texts separated by commas and can not be repeated in any order. Like I can't have two records, one with "cats, dogs" and other with "dogs, cats". how to create a validation rule for this?
Best Answer chosen by Gerardo Rodriguez Lara
veda Hebbarveda Hebbar
Hi,

You cannot archive this using validation rule.Because in validation rule you cannot check other records value. You can use trigger for this.

Thanks,
Veda

All Answers

veda Hebbarveda Hebbar
Hi,

You cannot archive this using validation rule.Because in validation rule you cannot check other records value. You can use trigger for this.

Thanks,
Veda
This was selected as the best answer
Gerardo Rodriguez LaraGerardo Rodriguez Lara
thanks!