FILTER my table using the LOOKUP control?

1

I created a LOOKUP control to allow the user to select the row to be shown in the view below it.

Then I tried to add a FILTER to that view that used the LOOKUP control – and – I cant select it!
It only allows me to select TEXTBOX controls for use in filters !!

Perhaps I am missing something here… it seems to me to be the most straight-forward way to define which row of a table to work on !

CODA OOP · OBJECTS 27_08_2021 14_19_50
CODA OOP · OBJECTS 27_08_2021 14_19_501097×313 29.9 KB

thanks for any help with this
max

1 Like
2

Hey there!

Try to just write the formula instead of selecting a control. Those usually work out something like this:
name.matches(control) or control.isBlank()

2 Likes
3

ah! hadnt noticed the little (f) symbol in the corner that allows me to enter a formula
i thought the drop-down list were my only options!

so i am using Name=lookup1.Name and it works perfectly
and
now i can use this approach where the lookup control selects from a parent table (yay)

many thanks @Scott_Collier-Weir

max

1 Like