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

    Occurrance of text among child records

    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.