0
I have a parent record which is linked to child records in the same primary table. I would like to report a percent % on the parent record by evaluating the state of each child. For example, a parent has 3 children and 2 child records are completed and 1 is In-progress. I want to report the parent is 66% Complete.

I would like to know what the best method to implement this would be.

Thanks,

Eric
Responses (2)
  • Accepted Answer

    Sunday, January 19 2014, 06:23 PM - #Permalink
    0
    I'd use an AppScript that runs on children transitions. Get the parent ID from the current item, then use an AppRecordList to find all items in same table with same type where ts_parentid = the current item's parent ID. this is total # of siblings. Then same query but add " AND ts_activeinactive=1" to find # of inactive siblings. Calc % of subtasks done then read the parents %complete val & update if calculated val not the same. Last step prevents parent from being updated needlessly.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, January 20 2014, 04:59 AM - #Permalink
    0
    Thanks Paul we will give it a try and report back.
    The reply is currently minimized Show
Your Reply

Recent Tweets