4 Replies Latest reply on Apr 7, 2011 12:07 PM by RonCates

    Occurrance of text among child records



      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.