Is there a way to check if a node name matches with the description of any other node within a hierarchy? I'm trying to enforce a validation so that users can not create a new node name that already exists as a description of another node in the hierarchy. I can't find the correct formula to use or a validation class. Thank you for your help!
Thanks Richard. I actually do have that validation in place as well to validate that the description is unique among all nodes in the hierarchy. What I need now is slightly different - I want the node name to also be unique among all description.
Here are the 4 validations that I must implement. #3 is in question.
1.Check if descr matches with an existing node name (Custom Validation) - Done
2.Check if descr is unique among descr of other nodes (Unique Prop Validation) - Done
3.Check if node name matches with an existing descr - ???
4.Check if node name is duplicate (system default) - Done
You can use this validation class with Name(Abbrev) and Description as the parameters: Unique 2 properties within a version, but it checks the entire version and not just the hierarchy you are currently in. In general that's even better but it may not match your use case...
Hi Try this formula :
hiername will be name of hier from where u want to check desc ,if abbrev and description gets mattched will return node name.