I’m new to Airtable and databases in general. I’m trying to develop a system to match students and tutors, based on availability and other factors. For example:
Student A: available Wednesday and Friday
Tutor A: available Tuesday and Thursday
Tutor B: available Thursday and Friday
I want to be able to easily see that both Student A and Tutor B are available on Friday. I know how to create a “Multiple select” field for availability and set up a filter on each of my tables (“Students” and “Tutors”), but is there a way to filter both simultaneously?
The long answer is: Airtable is a platform of many (many) limitations, which places it at the very low end of database platforms.
Unfortunately, what you want — dynamic filtering of linked records — is unavailable natively in Airtable, even though people have been requesting this feature for 5+ years,
I would highly recommend emailing firstname.lastname@example.org about adding this feature to their product, but sadly, Airtable also has a history (or perhaps an internal policy?) of ignoring user requests. It makes Airtable one of the more frustrating products to work with. But at the very least, I think you should let them know that this is an important feature to you.
I’m only familiar with Airtable and Apple’s FileMaker, which definitely offers this feature, but you would likely need a Certified FileMaker Developer to help you setup FileMaker since it is its own advanced programming language. If you go down that path, feel free to contact me at scottworld.com and I’ll connect you with my colleagues:
I’ve never used Google Tables before, but they might offer this feature. Not sure. If you try Google Tables, be sure to report back here with your findings.