• harish s 33
  • 5 Points
  • Member since 2017

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 2

I have the following validation rule written thus far to use a Vlookup on a custom object to verify that another record has not been created with the same name


        Name = VLOOKUP        
            $ObjectType.Finale_Asset__c.Fields.Name, Name ),
         ( $ObjectType.Finale_Asset__c.Fields.Id ,$ObjectType.Finale_Asset__c.Fields.Name, Name )))


This indexes against all other Finale Assets to confirm the name is not the same and then does a check to make sure that it is not producing an error message because it found itself.


I need to expand this to include another field, a picklist with different asset types.


Ultimately the rule should work as follows.


An individual can not create a new record with the same name and type as an existing record.  A record can have the same name and a different type.

We could have Name = Doc A  Type = Document and Name = Doc A Type = Rule but not


Name = Doc A Type = Document and Name = Doc A  Type = Document.


Can anybody provide some assistance in getting the picklist portion of the rule included in this validation rule.  Where I'm coming across trouble is becuase it is a picklist, there is a limited number of formulas to try and work around this with, since we can't do another VLOOKUP against a picklist.