Search without showing results to start with

Is it possible to link the search to a DB and only show results when the user searches?

i can easily add a search to card components that are linked to a DB but I want to show no results until someone searches for something then only I want to populate.

is this currently possible in glide?

Yes you’d have to create your own custom search. Typically you have a text entry component write to a user specific column…

Next take a single value column and cast the text entry value over all the rows.

Next use an If Then Else to compare your text entry with a search column. If text entry → is included in → search column → then true → else blank

Finally set a filter on your list when ITE column is true.

I think that should do it. If you need to widen your search… template a few search columns together first.

3 Likes

do you have a working copy i can look at. unclear about a lot of these instructions.

You can turn off the old search. You are going to create your own custom search with a text entry component.

Add a text entry component to your screen.

The text entry component should write to a user specific column.

Add a single value column to your table that you want to search and target the user specific column.

Next is an If Then Else column. Add this in the same table you want to search.

Set the If then else column up like this. If single value that is copying text entry → is included in → search column → then true → else blank

Finally set a filter on your list when ITE column is true.

Let me know if you get stuck

2 Likes