I want to be able to create filtered views using the values from a multiple select linked records field in the exactly the same way that I can with a regular multiple select field, including “is any of” and “is none of” with the little drop-down of toggle switches and everything. But currently if you filter by a multiple select linked records field, the only options are “contains”, “does not contain”, etc.
I know I’m not the first to post about this, but I can’t find the other posts in the forum to see what others have done.
My imperfect solution has been to create a helper multi-select by duplicating the linked field then converting it to a regular multi-select which I can then use to create my filters. This works, but I have to update the values in the helper field manually if there are any changes, which is less than ideal.
I need to be able to create a filter view that I can easily modify on the fly just by toggling values on and off, so setting up a complex formula that would have to be modified to select/deselect would not work for me.
I’ve reached out the the CS team at Airtable, but they weren’t able to provide me with a solution and suggested that I check here. Have any of you found a way to deal with this situation?