# Limit searches from the collection components to a specific column?

**URL:** <https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062>\
**Category:** Ask for Help\
**Created:** [August 15, 2023, 7:03pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062 "2023-08-15T19:03:55Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Igal\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/igal_y/32/56424_2.png) [@Igal\_Y](https://community.glideapps.com/u/Igal_Y)\
**Post date:** [August 15, 2023, 7:03pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/1 "2023-08-15T19:03:55Z")

</div>

How can the search feature in the collection component be restricted to search only within a specific column? The current search is producing multiple results from all columns.

---

<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:** [August 16, 2023, 2:01am UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/2 "2023-08-16T02:01:21Z")

</div>

It’s not possible to set it up with the native search. You would have to use a custom search (pointing a text entry to a user-specific column, then filter the list based on that value.

It would eat into your updates quota, though.

---

<div class="post-metadata">

**Author:** ![Igal\_Y](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/igal_y/32/56424_2.png) [@Igal\_Y](https://community.glideapps.com/u/Igal_Y)\
**Post date:** [August 16, 2023, 3:54pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/3 "2023-08-16T15:54:44Z")

</div>

Thank you for answering. I’ll work around it for now but hopefully the devs will create this functionality in the future.

---

<div class="post-metadata">

**Author:** ![RISHTACORNER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rishtacorner/32/56211_2.png) [@RISHTACORNER](https://community.glideapps.com/u/RISHTACORNER)\
**Post date:** [November 28, 2023, 6:17am UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/4 "2023-11-28T06:17:07Z")

</div>

This is a big problem … I have 3 filters on the collection but when a user searches, they can effectively do a search across the entire table and will see an item that contains those words. Any alternative to 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 29, 2023, 12:43am UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/5 "2023-11-29T00:43:30Z")

</div>

Do you mean you only want users to search within what your filters allow? In that case, the only way is to create your own search using a user-specific column and an if-then-else column to determine what items fit the search term.

---

<div class="post-metadata">

**Author:** ![RISHTACORNER](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rishtacorner/32/56211_2.png) [@RISHTACORNER](https://community.glideapps.com/u/RISHTACORNER)\
**Post date:** [November 29, 2023, 2:19pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/6 "2023-11-29T14:19:07Z")

</div>

Thank you for your help and your offer for a solution! I think it’s a little strange though, how you can build a collection with let’s say only a handful of fields to essentially hide columns not needed or not used in your detail view, but the search box searches across all columns. Hopefully they change this soon

---

<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 29, 2023, 11:20pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/7 "2023-11-29T23:20:01Z")

</div>

I doubt they change that behaviour. This has been discussed for a long time in the community. The best outcome is them letting us choose which columns are searchable.

---

<div class="post-metadata">

**Author:** ![Bert\_Snow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bert_snow/32/78658_2.png) [@Bert\_Snow](https://community.glideapps.com/u/Bert_Snow)\
**Post date:** [April 28, 2026, 5:22pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/8 "2026-04-28T17:22:08Z")

</div>

Years later: Is there documentation to help me attempt this approach?

---

<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:** [April 29, 2026, 3:59am UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/9 "2026-04-29T03:59:11Z")

</div>

There’s no documentation, it’s just a workaround, but the step-by-step writing would look like this:

1. Create a user-specific search column

- In the Data Editor, add a new column on the table your Collection is using
- Type: User-specific text (for example, call it “Search term (user)”)

1. Bind a Text Entry to that column

- On your screen, add a Text Entry component above your Collection
- Source: the user-specific column you just created
- This will act as your “custom search box”

1. Decide which columns are allowed to be searchable

- Add a new If-Then-Else column in the Data Editor (for example, “Matches search?”)
- Logic (simplified idea):
  - If “Search term (user)” is empty → Then “true” (show everything when there is no search)
  - Else if one of your allowed columns “contains” the search term → Then “true”. You might want to do some lowercase and trimming on both sides so it’s “normalized” for checking.
  - Else → “false”

You might end up with logic like:

- If Search term is empty → true
- Else if Name contains Search term → true
- Else if Category contains Search term → true
- Else if Description contains Search term → true
- Else → false

1. Filter your Collection by that ITE column

- On the Collection component, add a filter:
  - Where “Matches search?” is true
  - Now the Collection will only show rows where the user’s search term appears in the columns you explicitly checked for in your If-Then-Else column. It also respects any other filters you already had on the Collection.

The native search box should be disabled or removed for that Collection, otherwise users will still be able to search across all columns

---

<div class="post-metadata">

**Author:** ![Bert\_Snow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bert_snow/32/78658_2.png) [@Bert\_Snow](https://community.glideapps.com/u/Bert_Snow)\
**Post date:** [April 29, 2026, 2:10pm UTC](https://community.glideapps.com/t/limit-searches-from-the-collection-components-to-a-specific-column/65062/10 "2026-04-29T14:10:08Z")

</div>

Thanks so much! I’ve just gotten another project landed, so I won’t get back to this for a while. But what you describe sounds like what I need. I’ll post if I have more questions. THANKS!!
