1 Reply Latest reply on Aug 8, 2013 6:38 PM by philmodjunk

    Is Null

    johnw54

      Title

      Is Null

      Post

           How would I write..... If AdditionalPhoto:Note is null then use Product:StyleName otherwise use AdditionalPhoto:Note

            

           Thanks

        • 1. Re: Is Null
          philmodjunk

               The context in which you want to do this is missing. This could be a calculation in a calculaiton field, a text field with an auto-enter calculation or a script step.

               The calculation field version might be:

               If ( IsEmpty ( AdditionalPhoto::Note ) ; Product::StyleName ; AdditionalPhoto::Note )

               But note that you have fields from two table occurrences. THe above calculation will only work if there are valid relationships linking the two occurrences.