13 Replies Latest reply on Oct 15, 2014 12:59 PM by philmodjunk

    Updating Calculated Field

    PatriciaAngelini

      Title

      Updating Calculated Field

      Post

      Hello, I have put together a calculation for the donor/vendor field but it does not automatically update. I found the post below but have not been able to fix it based on the instructions. Any advice?

      The z_fullname is an auto enter calculation and that works fine and will update. The problem is when I try to update the Company Name.. either change it or remove it. When I do that, the donor/vendor name does not update. The calculated field is called "preferred name"  The calculation for that is Case (IsEmpty(TotalCompanyName);z_FullName; TotalCompanyName) and that calculation works as long as I don't try to update the TotalCompanyName

      I have attached a screenshot.

      http://forums.filemaker.com/posts/4d785bc013

      Screen_Shot_2014-10-15_at_9.23.08_AM.png