Glide’s search works fairly well, but it relies on having a collection that is displaying (on one or more pages) each of the rows you want to make available for searching. I wanted to create a way for users to search my main sheet without having to display a collection that is then filtered down by…

[image] BLA_68: The bigger challenge is how to implement some sort of fuzzy search That could be accomplished if Glide would give us a “wildcard” character in matches. Typically, “*” is used as a wildcard character in (programming languages) that I have used.

This is great advice. I wasn’t using a user-specific column because that didn’t seem necessary. But now that you said that, I’m realizing that (of course) the value last entered by a user will be the next user’s default value. Doh. Your Javascript example is cleaner and the trim, I agree, is a good…

That’s the result I want, yes. And also the reverse. If the data has Bob Smith, searching “Smith” should also yield a result. In my existing approach, since neither is an exact match of the other, the relation fails and so too the search…

I agree…is that in the offing? Would upvote a feature request if it’s out there.

[image] David_Gabler: That could be accomplished if Glide would give us a “wildcard” character in matches. Typically, “*” is used as a wildcard character in (programming languages) that I have used. You can do regex style matching with the Check Text Matches plugin.

Not familiar with Regex and have to say after testing it a bit I’m stumped. If I wanted to use it to say, for example, "when the user enters ‘Bob Smith’ ignore the Bob part and just match “smith”, what would that expression look like? Since Bob Smith would be entered into the “Search Term” field, I…

[image] BLA_68: "when the user enters ‘Bob Smith’ ignore the Bob part and just match “smith”, That use case seems a little odd. What if the user really was looking for “bob smith”? Which would be a reasonable assumption given that’s what they typed. Sure, you can craft a regular expression to…

The value in the column is just “Smith”. So since the “search” relies on a relation to that column, the term “Bob Smith” would not match anything. So being able to trim it would control for the user supplying extraneous information that makes the search not work.

Okay, but again - how does Glide know which of the two words entered is needed to form the relation? As @ThinhDinh pointed out earlier, using relations here is probably not the best approach. It occurred to me that maybe what you are looking for is essentially an OR search. That is, if a user ente…

I’m not sure if this is what you’re looking for, but anyway… Copyable demo: Multiterm Filter Demo

Alternative Search Bar Approach

Ask for Help

Darren_Murphy March 15, 2022, 9:49am 13

I’m not sure if this is what you’re looking for, but anyway…

Copyable demo:

Splitting large data entries into multiple single value columns

Topic		Replies	Views
🔎 Glide: Search Box Tips and Tricks Community Resources	34	7090	August 23, 2021
Request for a better "search bar" capability Feature Requests	18	1435	May 29, 2022
Splitting large data entries into multiple single value columns Ask for Help actions	9	840	October 28, 2023
Search with criteria Ask for Help custom-code	19	2563	March 28, 2023
Collection Component: How to Limit Search to Single Column and Word Beginnings? Ask for Help	12	138	November 10, 2024

Alternative Search Bar Approach

Related topics