Why isn’t it easy and intuitive to access elements from other tables.

I could use a formula to show only elements of another table, that have certain attributes.

For example, when I have a table Students, and I want to generate a new table young students, I could simply type:

if(students.age<20, students, ””)

How is something like this possible right now?

Can it even be done since I really want to generate a table with elements that only fulfill certain criteria.

I think it’s really annoying that you always need to use a lookup table where the relevant information of a connected table is pulled before you can use this information in a formula. It would be much better if Airtable would adapt the writing I used above, so all rows of a table can be accessed as members of the table name from outside. tablename.row

By the way the formula field is really messy for a long, nested formula.