AnsweredAssumed Answered

Occurrance of text among child records

Question asked by RonCates on Apr 7, 2011
Latest reply on Apr 7, 2011 by RonCates

Title

Occurrance of text among child records

Post

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.

Outcomes