Lookup Filter using a Lookup?

1

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.

image
image757×898 33.9 KB

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

image
image768×500 25.5 KB

But that always shows all drinks hot & cold.

Here’s the coda doc to take a look

Thanks!

2

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!

3

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

image
image1014×568 33.2 KB

4 Likes
4

Hi @Ryan_Hubbard,

I’ve got an issue similar, I know how to filter the lookup, but the problem is that the lookup is being used in lots of views of the same table. I’m probably doing something wrong, but it changes the source table and that’s the filter on all the views.

All the best,

Ivan