Hi, I would like to make an empty search field in appsheet and when the user tap the search field a drop down list of several categories is shown. Once I tap, for example, โcategory 1โ all activities related to โcategory 1โ is shown.
At this point when I have tried to make slices, to get a filter function of the category column, it turns out something like below instead without any filter function: โcategory 1โ โcategory 1โ โcategory 2โ โcategory 3โ "category 1 etc
Anyone who understand what I am looking for and what shall I do? Many thanks in advance!
Hi, Have you tried grouping twice by category?
What you want is a structured search mechanism (we donโ t have it at the moment).
As Lynn says, you can mimic it by using a table view with the grouping option.
Assuming yoy have an Activities table where one column is called Category,
Set up a UX view for it. Make the view type Table. One of the optional settings is to define Grouping columns. Choose Category and then choose Category again. This should now give you an approximation of what you want.
ok thanks again, I will try this and hope I get it right:)
And if you use usersettings enum for the category and show_if for the view?
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |