Jul 10, 2021 03:19 PM
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:
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?
Jul 10, 2021 04:15 PM
Welcome to the community, @Andrew_Shapira!
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 email@example.com 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.
Jul 10, 2021 04:22 PM
Thank you! Do you know if any other online database products offer this feature?
Jul 10, 2021 04:29 PM
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.
And if you end up leaving Airtable, be sure to email firstname.lastname@example.org to let them know why.