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.
... View more