I seem to have access to a new feature that let’s me build a filter based on an exact linked record object. But the way I get access to it seems to be a bug.
If I try to build a filter by chosing a linked record field, I only have the options of [‘contains’, ‘does not contain’, ‘is empty’, ‘is not empty’]. However if I start my filter on a different field type, such as a formula or text field, I can chose the filter option ‘is’. Once I have selected ‘is’, if I then change my filtered field back to a linked record, I have a new option to filter my linked records with ‘is exactly’, and I am presented with a standard lookup list to choose from. Unless I have missed something, this is a huge new feature that I can put to good use. I have added some screenshots, let me know if others have the same thing.
Airtable seems to be testing this new feature behind the scenes over the last few weeks They probably didn’t mean for it to show up yet, so it looks like you’ve stumbled onto a bug on how to get it to display. I would definitely not rely on any choices that you make there to stay there, although they certainly might. In the meantime, I would report this to email@example.com.