Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 16, 2022 07:24 AM
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!
Solved! Go to Solution.
Nov 16, 2022 01:26 PM
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!
Nov 16, 2022 08:03 AM
@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.
Nov 16, 2022 08:17 AM
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.
Nov 16, 2022 01:26 PM
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!
Nov 16, 2022 01:33 PM
@Sara I came up with the following solution, see screenshots.