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

    Marking Tasks complete




      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 !



        • 1. Re: Marking Tasks complete



          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