AnsweredAssumed Answered

calculation field trouble with IsEmpty

Question asked by CrisLee on Nov 16, 2013
Latest reply on Nov 18, 2013 by CrisLee

Title

calculation field trouble with IsEmpty

Post

      

          Hi
           
          First time posting to the forum. Thank you in advance. 
           
          I have a calculation field named artContent. It copies data from a related table field into the calculation field however if the override field is used it replaces the related data. below is the code that works:
           
               Let ([
               override = GetField  ( GetFieldName ( Self ) & ".override" );
               source = GetField ( Portfolio::artContent )
               ];
               If ( IsEmpty ( Artwork::artContent.override ) ; source ; override )
               )
           
           
          here is the code I want to use however, the field will not recalculate properly. The qualified field name in the IsEmpty in the above code is the the same as the override variable used in the function below. I want this to work so that I do not have to open a 100 different fields and manual change the IsEmpty. 
           
          Let ([
          override = GetField  ( GetFieldName ( Self ) & ".override" );
          source = GetField ( Portfolio::artContent )
          ];
          If ( IsEmpty ( override ) ; source ; override )
          )
      

Outcomes