Avoid Duplicate Values using Configuration: BCHasRows Function


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:

Output of BCHasRows function

Output of BCHasRows function

Advertisements


Categories: Siebel

2 replies

  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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: