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!