I know I'm not the first person to ask this but I've read many blogs, none of them solved my problem. I have a custom object say "Invitation__c" where I have a custom Date field.
My requirement is I want the combination of Name and Date field to be unique. I already created a Unique Case Insensitive Text field (Composite_Key__c) and a Workflow rule (Everytime a record is created and edited) with Rule criteria
Invitation: Composite Key EQUALS Invitation: Name & Date and a Field Update Workflow on Composite Key field. But its not solving my problem. Its only giving the error on Duplicate Name but not on the combination of Name and Date.
I guess the Workflow rule needs to be updated but I've tried many options, none solved it.Please help.