enum filter results

[marko4522]

Hi everyone,

Is there a way to limit filter results for enum column in search, to show only results that satisfy a condition. It shows me everything, but list is to long, it takes time a lot to scroll.

I have a part list table, and I would like to only show me active parts in filter results. I have a column for ActiveParts, 1 for active, 0 for not active.

Thanks

[Arni_Kli]

@marko4522 ,
You can use filter in Valid_if field:

Select(Table[Key], [ActiveParts]=1)

Enum type should be a Ref-type to table with parts.

[marko4522]

@Arni_Kli

I tried that, expression is green, but it does not works

[Arni_Kli]

@marko4522 please try it in Suggested values field

[marko4522]

Still shows everything…

[Arni_Kli]

Check please key column name and filter column. It must works.

[Steve]

Please post a screenshot demonstrating that it doesn’t work. Please also post a screenshot of the column configuration.

[marko4522]

I have a table called “MagacinPOPIS”, column of clients called “Klijent”

Column “KNS” is 1 or 0, for active client or not.

Idea is to show in search filter only active clients

[marko4522]

Here is the configuration of the column

[Steve]

It appears you’re referring to the built-in column filtering feature:

There is no way to configure this feature directly. The best you can do is choose which columns are searchable:

[marko4522]

Is there a way to do it somehow

[Steve]

I have never attempted what you’re trying to do so I can’t speak from experience. It may be possible, but it would likely be difficult to do.

[Arni_Kli]

SOLUTION
This is a short concept, then you can customize it to your needs.

1. GoogleSheets: Create Table Sparepart:

2. GoogleSheets: Create new table SparepartQ where in cell A1 put a next QUERY:

=QUERY(Spareparts!A:C;
"select *
where C = 1
"; -1)

as a result you will receive next table with [ActiveParts]=1 only:

3. Add tables to AppSheet, set SparepartQ as read-only, set [Part Name] as Enum for good view in system filter:

4. Add Table view for SparepartQ.

5. For SparepartQ create Action (see below) with goto link to detail view of Sparepart table:

6. Open Table view that you made and select this action in the Behavior section^

That’s all. In result:

1. You will receive good filtered view in system filter.
2. The user will not even be aware that he is being redirected from the query table to the fully functional table.

RESULT SCREENS

Whole table view (Spareparts)

Query table view (SparepartsQ)

System filter view in query table view

Detail view of editable main table where you go after selecting a record in the query table

[marko4522]

@Arni_Kli

Brilliant!

Thank you!

[Arni_Kli]

@marko4522 ,