Filter on linked records (yes, i've read other posts

Hey ​@MJvD!

For sure I am missing on a lot of context here, so what I might be about to suggest might not be even close to what you are looking for.

Did you try limiting the selection of the linked field either to a view or to a specific condition? Please take a look at the screenshot below.

 

 
Otherwise, please feel free to schedule a call using this link and we can go through your specific needs together to find a solution on the go.

Mike, Consultant @ Automatic Nation

Hello Michiel,

You could do this with a Rollup field and Airtable’s filtering in the usual Grid view.

So, in your HCO table you would Rollup the specialties of the HCPs. Then, you would filter like this:

WHERE Specialty Rollup (from HCP) contains Orthopaedic
and   Specialty Rollup (from HCP) does not contain Ophthalmology

Here’s some images to see what I’m saying:

Let me know if this helps!
 

​@MJvD 

I’m not sure I fully understand either, but have you started playing around with lookup fields and rollup fields yet?

That allows you to bring in data from other tables into your current table, as long as you link records together. 

Then, you can search in one table for values that normally live in another table, if those values are tied to the records in your current table.

I created a free Airtable training course many years ago which explains linking records and lookup fields in more detail. The course is very outdated now, but the core concepts remain the same. You can take the course for free by signing up for a free 30-day trial with LinkedIn Learning.  

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

In your HCOs table, add one rollup field for each specialty. These rollup fields will show whether the hospital has any HCPs with that specialty. If the field is empty, it means the hospital doesn't have any.

Once the rollups are set up, you can create a view or apply filters in the HCOs table using conditions like: "Has Ortho is not empty" and "Has Ophthalmo is empty".

Taha, Airtable Advisor

Hi all,

Thank you so much for the feedback, been quite busy and should have replied earlier!

I’ll try the roll-up solution mentioned and will get back to you asap!

All best,

Michiel