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?
