# Show Search Results when few characters entered

**URL:** https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120
**Category:** Ask for Help
**Created:** [November 26, 2021, 11:57pm UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120 "2021-11-26T23:57:15Z")
**Posts on this page:** 15
**Page:** 1

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 26, 2021, 11:57pm UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/1 "2021-11-26T23:57:15Z")

</div>

Hi!

I want the Search Results of a list to display when three or more characters are entered in the search bar. How would I do this?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 12:07am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/2 "2021-11-27T00:07:36Z")

</div>

> [@Search not working properly on Detail View](https://community.glideapps.com/t/search-not-working-properly-on-detail-view/35110):
>
> Hi! I have a tab as a list. In this list, there are customers. I only want to show one customer. You have to search for a customer to see it pop up in the list. This works fine when the tab is a list. However, when I do the same when the Detail view, the search doesn’t work. A detail tab with an inline list limits the number of results to one. I search for a customer, but it doesn’t pop up. However, sometimes it randomly does work. Is this a bug? How can I fix this?

Is this the same issue?

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 12:08am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/3 "2021-11-27T00:08:23Z")

</div>

No, this is separate from that 🙂

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 12:09am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/4 "2021-11-27T00:09:07Z")

</div>

How is it working your side? When you enter 3 or more characters then the search does not work?

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 12:11am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/5 "2021-11-27T00:11:46Z")

</div>

No, the opposite: we want the search results to start showing when a minimum of 3 characters are entered in the searchbar

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 12:25am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/6 "2021-11-27T00:25:12Z")

</div>

Ah, so only when it’s 3 characters or more will the search result show?

I think you can follow the steps below:

1/Add a text entry writing to a user-specific column to serve as your search field.

2/Add a plugin to calculate the length of that term.

3/Add an If Then Else column, if length \> 2 then returns the search term, else leave it empty.

4/In your table that you want to search, create a single value column and cast that ITE column above to all rows.

5/Add a final If Then Else column. If single value is empty then true (we don’t “filter” by the term at that point), else if single value is included in let’s say the name column then true, do that for all columns that you want users to search.

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 12:32am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/7 "2021-11-27T00:32:34Z")

</div>

Wow, thanks! Question about the second step: what do you mean by the plugin? Do you mean something like Zapier or something else?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 12:33am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/8 "2021-11-27T00:33:11Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/390205203b67bd04d27e7647d7802aa8ef559f32.png)

Here.

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 1:12am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/9 "2021-11-27T01:12:24Z")

</div>

It’s working perfectly, thank you very much!!! 😃

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 1:13am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/10 "2021-11-27T01:13:09Z")

</div>

Do you know any possibility to disable enters/returns?

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 3:35am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/11 "2021-11-27T03:35:00Z")

</div>

I think that is only possible with JS/JQuery but I haven’t seen that being implemented in Glide. What is your use case?

---

<div class="post-metadata">

### Author: ![mzsadiek](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mzsadiek/32/36021_2.png) [@mzsadiek](https://community.glideapps.com/u/mzsadiek)
#### Post date: [November 27, 2021, 4:05am UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/12 "2021-11-27T04:05:46Z")

</div>

In the text entry that I now use as a search bar, you can enter a digit or email address to search for a user. However, when you press enter, it starts a new line. It would be nice if I’m able to prevent that from happening.

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [November 27, 2021, 1:53pm UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/13 "2021-11-27T13:53:40Z")

</div>

I think you could do that with the trim white space under text plugins. When a user adds a row or sets column values you should make a trim white space column perform the action.

Then create your own search bar using a text entry component and trim the white space from it as well.

This won’t prevent the user from creating a new line by pressing enter but it should return a match regardless if the enter key/ space bar is pressed or not.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 27, 2021, 11:10pm UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/14 "2021-11-27T23:10:50Z")

</div>

Not sure if we can do the same with a template column replacing all “new line” characters by “nothing” to remove it, but yeah that’s the idea.

Would still be nice to have the ability to block the character though.

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [November 28, 2021, 11:10pm UTC](https://community.glideapps.com/t/show-search-results-when-few-characters-entered/35120/15 "2021-11-28T23:10:56Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
