Real simple question:
- I am building a todo list across multiple areas of my life.
- Each table/tab is a different area (work, home, school, etc.).
- Within each area are numerous tasks grouped into various projects.
I need one single master view that shows me the latest task (record) from each group across all those tables. That view can be another table itself or a block.
Ideally, that view would show the highest-ranked task (record) within that group at that moment until marked complete, then it would be removed from my master view and replaced with the next highest incomplete task.