Lookup Filter using a Lookup?

I’d like to filter [Order.Drink Name] so it only shows Hot or Cold drinks based on whether [Order.Drink Type] is set to Hot or Cold. Both of those columns are lookups to other tables.

Here’s the custom formula filter on [Order.Drink Name]

But that always shows all drinks hot & cold.

Here’s the coda doc to take a look

Thanks!

Hi @Ryan_Hubbard ,
almost there… (but I admit it’s not super intuitive).

In the filter, you just have to provide the filter condition as it is already contextual.
therefore:
Type=thisRow.Drink Type

(I changed it already on your doc)

I hope it helps.
Cheers!

Thanks! That was stumping me. Here’s a pic for reference in case others need the visual

3 Likes