Occurrance of text among child records
Two tables in question. Leads to calls. One to many relationship. In the calls table there is a field called response. From a calc field in the leads table I would like to be able to show weather any of the responses for a given lead are "Call Back". I would like to use this field for a conditional format to indicate in a list of leads which ones need to be called back.
I tried something like this:
PatternCount ( "Call Back" ; List (Call Log::response) )
It only returns 1 if "Call Back" is the response to the first call.