My use cases is I have a master task for example: “Build Marketing Program” and this has a bunch of sub-tasks related to different actions and teams.
At the task level, the team regularly provides updates and then logs them into a “Log Status” column. So based on this structure, each task has on on-going update to the logs.
It works well but I want to create a place where every log related to “Build Marketing Program” can be consolidated. So I created: ProgramDB.filter([Program Name]=LogSelectButton).[Log Status]
It works and shows the correct data but the problem is that every time I add a row (when I add a new sub-task, it outputs the consolidate Log Status again.
So if I select “Build Marketing Program” and I have 4 sub-task it will output the correct consolidated log 4 times.
I understand why it outputs the consolidated log (all rows) at once but I don’t know how to get it to give me the output one time. Or to stop after seeing the program name once.
Grateful if anyone can point me in the right direction of what I am missing.
Thanks