What is the best why to accumulate the results from a field children records to report an overall percent complete on the parent record. Question
I would like to know what the best method to implement this would be.
Accepted AnswerPaul ThompsonOffline0I'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.
Accepted AnswerEric DiCiannoOffline