To check/search in child Bus comp field values for some validation without scripting.
For Example:
When the Specified Account has any "Active" child Activity, the Activity flag should be true
Implementation without scripting:
Create a calculated field: Check Activity
- Calc Expression: BCHasRows("Account", "Action", '[Account Id] ="' + [Id] +'" AND [Type] = "Active"',"All")
- Returns Y, if any child activity found.
- Create a User property “On Field Update Set” to set the Activity Flag ; Value : “Check Activity”, “Activity Flag”
Syntax: BCHasRows ( BO , BC , search_expr, visibility)