How to filter Airtable records based on linked column relationships?

Other Questions Airtable
1

Need help with Airtable filtering

I’m working on an Airtable project and I’m stuck. My table has a ‘Name’ column and a ‘Partner’ column that links to other names. I want to create a view that shows:

  1. People with partners
  2. People who aren’t anyone’s partner
  3. People with no partners

Is this possible? I’ve tried using filters, but I can’t figure out how to combine these conditions.

Here’s what I’ve attempted:

Filter 1: Partner is not empty
Filter 2: Name is not in Partner

But this doesn’t quite work. Any ideas on how to set this up? I’m new to Airtable’s advanced features, so simple explanations would be great. Thanks!

2

hey, i think i got a solution for ya. try using a lookup field to check if someone’s a partner. then make a formula field like this:

IF(AND({Partner}, {Lookup}), ‘has and is partner’,
IF({Partner}, ‘has partner’,
IF({Lookup}, ‘is partner’, ‘no partner’)))

now u can filter or group by this new field. hope this helps!

3

I’ve been in a similar situation with Airtable and found a workaround that might help. Instead of trying to combine all conditions in one view, I created separate views for each scenario. This approach is more manageable and easier to set up.

For people with partners, use a simple filter where ‘Partner’ is not empty.

For those who aren’t anyone’s partner, create a rollup field in your table. Name it something like ‘Is Partner’. Set it to count the number of times the person’s name appears in others’ Partner field. Then filter where this new field equals 0.

Lastly, for people with no partners, just filter where ‘Partner’ is empty.

This method gives you three clear views, each addressing one of your requirements. It’s not as elegant as having everything in one view, but it’s effective and easier to maintain. Hope this helps!

4

Having worked extensively with Airtable, I can offer a solution that might simplify your task. Consider creating a formula field to consolidate your conditions. Name it ‘Partner Status’ and use this formula:

IF(NOT({Partner}), ‘No Partner’,
IF(FIND({Name}, ARRAYJOIN({Partner})), ‘Is Someone’s Partner’, ‘Has Partner’))

This creates a text field categorizing each record. You can then use this field to filter or group your records as needed. For instance, to see all categories at once, simply group by the ‘Partner Status’ field in your view.

This approach provides a more streamlined way to manage your data and offers flexibility for future sorting or filtering needs.