1 Reply Latest reply on May 17, 2016 3:30 AM by erolst

    Marking Tasks complete

    lukeingram

      Hi,

       

      I am making a production tracking solution for my small business.

       

      I have a table ORDERS as a parent and ORDER ITEMS as a child. Each ORDER has many ORDER ITEMS. When each order item is complete it is flagged "complete". Currently I have to go through and manually check to see when all the order items for a given order are complete. I would like to find a way to automatically mark the order complete when all the order items are.

       

      Any help would be greatly appreciated !

       

      Luke

        • 1. Re: Marking Tasks complete
          erolst

          Try

           

          Count ( LineItems::primaryKey ) = Count ( LineItems::completionFlag )

           

          assuming that the field is empty until completion.

           

          If that's not the case, and you are using different text flags, try

           

          Count ( LineItems::primaryKey ) = ValueCount ( FilterValues ( List ( LineItems::status ) ; "complete" ) )

          1 of 1 people found this helpful