crmTech/ April 26, 2013/ Siebel/ 2 comments

Scenario: Need to avoid entering duplicate Account Name.

Configuration: Use the function named BCHasRows(“BO”,”BC”,”Search Expression”,”Visibility”

1.  Create Calculated Field

Field Name: Name Calc

Field Calculated Value: BCHasRows(“Contact”,”Contact”,”[First Name]='”+[First Name]+”‘”+” ,”All”)

Create Calculated Field
Create Calculated Field

2.  Add Calculated Field in Validation Property of Field.

Field Name: Name

Validation Value: Name Calc

Validation Message: Account Name is already Exist. Please avoid duplicate and enter new value.

Add Calculated Field in Validation Property
Add Calculated Field in Validation Property


Output of BCHasRows function
Output of BCHasRows function
Share this Post

About crmTech

Sharad is working from more than 11 years in IT industry. He has giving his technical services in CRM for telecom, automobile, retail, finance industry in Sales, Service and Marketing. He has primary skill in Siebel and Salesforce Marketing Cloud. Apart from this he has worked in Google Cloud, Wordpress blogging, SEO optimization, Short film making, mobile apps creation,logo design creation for his own interest.


  1. Hi,

    I have tried this the same way as it is mentioned. But I am not getting the error message once entered duplicate values 🙁

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.