Scripting - filter by "Link to another record" fie...

[kofal]

Hey everyone,

I have a question regarding second-level filtering. 

In a classic CRM setup, I have a table that holds all my opportunities. I have another table that holds all my activities (say to do items that can be linked to opportunities in airtable) that contains a status field (to do, doing, done)

My goal is to display all opportunities that do not have a planned (planned = status is not done) activity linked to the record  (every sales deal should have a next step planned. 100% stolen feature from pipedrive).

Any way to achieve that in the interface?

So far, I was able to half-achieve it by using the "when linked record field is empty" but that doesn't solve my problem since it would fail to highlight opportunities that have a linked activity marked as done, but not other activities linked.