The good news is I vaguely remember working on this base. The bad news is I only vaguely remember doing so…
When you say “I’d really like to filter it to show just the next action,” do you mean in the {Tasks} field? {Tasks} is a linked-record field, so by definition it’s going to display all tasks associated with a project. However, there is a mechanism built into the base that would allow only the next task to be displayed. I think I can simply tell you what needs to be changed rather than passing back another modified version of your original base, since by now the one I’d be modifying is clearly out-of-date.
To enable display only of the next action for a project
- In
{Tasks::Next} (that is, in the {Next} field within the [Tasks] table), change the aggregation formula to
IF(values,IF(Index=values,1))
This corrects an oversight in the first modified version.
- In
[Tasks], create a new formula field {Next Task} with the formula
IF(Next,Name)
- In
[Projects], create a new lookup field called '{Next Action}. It should follow the link to [Tasks] and lookup the {Next Task} field.
- In your
<Projects::Next Actions> view, hide {Tasks}. Display {Next Action} instead.
Now, {Next Action} should show only the next action for each project. (I don’t recall how completed tasks were handled, but I suspect once they’re flagged as complete, I blank out their index numbers. This should result in {Projects::Minindex} being revised upward, bringing the next task in the sequence to be highlighted as the project’s next action.)
One caveat: After modifying the original modified base, with the currently defined filter the <Next Actions> view displays a number of projects that are not flagged as complete vet do not link to any tasks. If this is a valid response — that is, you are tracking open projects without a defined next step — you can tweak <Next Actions> to show only projects with a defined action by adding a second filter step to display only those records where {Next Action} is not empty.
If I’ve misinterpreted how you wish the next action to be displayed, never mind… (Let me know where I went off course, and I’ll try to return to the lane.)
