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.