5 Replies Latest reply on Mar 18, 2014 1:24 PM by barriec7

    calculation based on field being completed

    barriec7

      Title

      calculation based on field being completed

      Post

           I need to populate one field if another is completed, no matter the value. i am used to scripting in filemaker where for example, if a field has content A, populate field with X and so on. i am also used to filling fields based on another field's being null or empty>>> " ".  

           i tried a wildcard, but no go. any suggestions helpful.  

           example: 

           Case(
           SHIPPING_INFO_ACTUAL_SHIP_DATE="*";UNIT_STATUS = "SHIPPED")
            
           thanks, barrie