Glide’s in-app search box doesn’t allow for advanced searches. See how you can add tags to your content (and then hide them!) in order to improve your users’ search results. [Glide: Search Box Tips and Tricks]

[image] POWH_RPS: I’d like for a user to freely enter search terms to be looked up in the rows of the table. I cannot indicate preliminarily any “search terms” Couldn’t you use the approach with a template column and text entry component? Template column: concatenates all columns having wor…

Yeah I believe this is a good way to approach it. I used it for doing custom searches in some of my apps.

A custom search box would still kind of be an AND search and try to match the entire string, so not much different from the built in search capabilities. I wonder if your idea could be expanded and the single value column is split in a Split column to get an array of search terms. Then compare the…

Ah you’re right that the AND would be trickier to pull off. If you’re having a lot of columns then it will be much bigger of a problem.

I am thinking now, what if you can use a LOOKUP function in the linked GSheet, using a AND or OR in the argument of the function? I have seen these functions also working with wildcard (e.g. nam* will find name, naming, names, etc.). With some work arounds one can: generate the text field for the…

Hello @Jeff_Hager I haven’t seen this post, but I can adapt my script to your needs. What would be the modifications to be made?

I’m thinking something where you pass in a string of text to search, a string of search terms and an AND/OR choice. So something really really similar to what you already have, but it would take one criteria parameter (multiple search terms) instead of two, split the text on each space, then compar…

OK Well I already have that. Finds if only one criterion, each word separation is a criterion, with an And option. But I will revise my copy to do like google !!! It’s less simple but hey I’ll look for it [image]

It’s not fun if it isn’t a challenge. :wink:

🔎 Glide: Search Box Tips and Tricks

Community Resources

Jeff_Hager August 21, 2021, 1:06am 17

You might want to take a look at this post. It might not be exactly what you are looking for, but I bet that you could create some script that could be called through an Experimental Code column to perform some advanced searching capabilities.

Topic		Replies	Views
Search with criteria Ask for Help custom-code	19	2592	March 28, 2023
Request for a better "search bar" capability Feature Requests	18	1449	May 29, 2022
Custom search box in the detail tab Ask for Help	38	2843	October 7, 2022
Alternative Search Bar Approach Ask for Help	22	1197	March 18, 2022
Curious - What exactly does the search bar search? Ask for Help	39	4702	June 3, 2023

🔎 Glide: Search Box Tips and Tricks

Related topics