Help

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

Topic Labels: Views
Solved
Jump to Solution
1116 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Phil_Salant
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Phil_Salant

Welcome to Airtable Community! :slightly_smiling_face:

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.

See Solution in Thread

2 Replies 2
Mohamed_Swella1
13 - Mars
13 - Mars

Hi @Phil_Salant

Welcome to Airtable Community! :slightly_smiling_face:

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.

Thank you! This is exactly what I needed!