AnsweredAssumed Answered

Auto-Enter calculation woes

Question asked by alext on May 14, 2014
Latest reply on May 15, 2014 by alext

Title

Auto-Enter calculation woes

Post

     I am bewildered...

     I have 2 associated tables in a "one to many" relationship; CONTACTS and DOCUMENTS.  I am trying to auto-enter a field in CONTACTS called "ConsentForm", with a "Yes" if any related document titles contain the string "consent".

     To do this I've used the following calculation in the auto-enter calculation area for field ConsentForm:

     Case ( PatternCount( List(cntct_DOCS::Title)  ; "consent") ; "Yes" ; "")

     For whatever reason the field ConsentForm refuses to have a "Yes" auto-entered.  I've sanity checked my calculation by pasting it as the tooltip for ConsentForm and alas I get a "Yes", however nothing I seem to do will populate the actual field.  I made sure the layout is referencing the same Occurrence as the auto-calculation. I even tried unchecking "Do not replace existing values" with no luck.  What am I missing?

      

     client machine: Filemaker Pro Advanced 13.0v3 (Mac)

     accessing tables of a database on Filemaker Pro Server 13 (Windows)

      

Outcomes