Dashboard Search

AppSheet AppSheet Q&A
1

I created a dashboard in AppSheet that contains 2 views:

  • One is a detail view with quick edit fields that are used for filtering.

  • The other is a table view that gets filtered by a slice based on the user’s filter selections.

The issue is that when the user searches from the search bar at the top, the detail view (filter page) also gets searched. Since it returns no results, the filter section disappears.

To improve the user experience, I’d like to achieve two things:

  1. When something is searched from the search bar, the filters should be ignored (though I don’t think this is possible).

  2. When something is searched from the search bar, the filters should not disappear.

Is this possible?

I thought about adding all table columns as virtual columns to the filter table and making them searchable, so that the filter view doesn’t disappear — but is there a more practical solution?

2

Nope.

1 Like
3

Perhaps you can add a field to your detail view (the filters) for a search, and add a condition to the slice expression that if the Search field (in the filter table) is not blank, then only return rows that one of the columns (I assume you’d need to include each column that you want to include in the search) contains the value of the search field.

I have never tried it, but in theory this should work.

1 Like
4

Thank you for your answer, yes I did this solution, removed search bar and it worked. do you think is it possible removing search bar from only spesific views?

5

Not that I know, but what happens if you uncheck the search option from all of the columns in the table. Would the search from the search bar return no results, or all results?

6

It is not.

7

That’s a very interesting question!