Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Display 1 row from Tables B, C, D on Table A

Topic Labels: Base design
966 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

2 Replies 2

Hi @DPeezy,

Welcome to Airtable Community ! :grinning_face_with_big_eyes:

That doesn’t seem like the best setup in my opinion. I think you will be better off if you have all those tasks in one table, with a Field (lets say it is a Single Select field) with options like Work, Home, School, etc. that you will use to Group By. You can then sort the fields as you wish.



I’m looking for technical advisement as to Airtable’s capability to do precisely what I requested.

If it cannot do that, it’s fine. Just need to know.