Interfaces filters problem

[Sara]

Hi, I’m trying to create an interface that shows only the status “To send” and not other status.

As you can see in “Status 2( from Report)” there is also the status “Done”, I would like to filter the data.

I tried to filter the interface in this way:

But it didn’t solve my problem.
This is my dataset:

is someone know why “Done” is still there? and how can I solve this issue? Thank you very much!

[Andrey_Kovalev]

@Sara You are looking filtered results in one table, but actually filtering records in another table. Either use a filter in Report table, or use filtered view on that table.

[Sara]

Hi Andrey, Thank you very much for your fast reply!

Even if I filter in the “Report” table, the interface result doesn’t change. The problem is that I need that the interface is based on “Table_1”, but the “Status 2 (from Report)” is a “lookup” with multiple different elements based on the table “Report,” and it includes everything.

I don’t know how to solve this problem. I don’t want to create another table just for “To send”, because this is a test for a bigger database with multiple statuses.

[Sara · Accepted solution]

At the end, I found out the problem, I should “look up” the status with a condition and select this new field in the interface, not just filter.

By the way, thank you for the help!

[Andrey_Kovalev]

@Sara I came up with the following solution, see screenshots.