Can I create an Airtable view containing records not present in a “linked records” column?

I have a table with columns like:

Name (Single Line Text) | Partner (Link to "Name")
----------------------- | --------------------------
John Doe                | `Jane Doe`
Jane Doe                | (Empty)
Bob Smith               | `Mary Smith` `Kevin Smith`
Mary Smith              | (Empty)
Kevin Smith             | (Empty)
Alan Stephens           | (Empty)

I’d like to create a new view for this table with filtering like:

WHERE {Partner (field)} is not empty
OR {Partner (column)} does not contain {Name}

such that the result would be:

Name (Single Line Text) | Partner (Link to "Name")
----------------------- | --------------------------
John Doe                | `Jane Doe`
Bob Smith               | `Mary Smith` `Kevin Smith`
Alan Stephens           | (Empty)

The challenge here is that on line 1 of my filter, I’m looking for “records with no records linked in their Partner column”, but on line 2 I’m looking for “records which are not found in the Partner column for any other record”.

The overall goal is to generate a list of records with no Partner(s) plus records who are not anyone else’s Partner. Is there a way to achieve this?

Hi @Phil_Salant

Welcome to Airtable Community! :slight_smile:

The filter you are trying to do is not doable in such way. What you can do is use the script block to make the connections 2 ways. Here is the script to do so.

1 Like

Thank you! This is exactly what I needed!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.