# Search by column
**URL:** https://community.glideapps.com/t/search-by-column/70897
**Category:** Ask for Help
**Created:** [February 16, 2024, 10:08pm UTC](https://community.glideapps.com/t/search-by-column/70897 "2024-02-16T22:08:51Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Tom\_Azaria](https://community.glideapps.com/u/Tom_Azaria)
#### Post date: [February 16, 2024, 10:08pm UTC](https://community.glideapps.com/t/search-by-column/70897/1 "2024-02-16T22:08:52Z")
Hi All,
tl;dr: I have two columns with numbers. A Long Serial number (Visitor Unique ID, 6-9 figures long)) and a short serial number (Sequential ID 1-999 figures long).
I often need to search for a Short Serial Number, but this one very often appear in the Long Serial Number making it really difficult finding the row I need containing the Short Serial Number.
This is the relevant structure.
Long Serial Number, Short Serial Number
847267639, 673
I’m new to Glide but I do have some experience with now and low-code tools.
I’m finding it hard to understand how to solve my issue, Does anyone have any suggestion on what I should do? Making a column specific search was, I thought, a basic feature.
I appreciate all your help in advance! Thank you.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 16, 2024, 10:11pm UTC](https://community.glideapps.com/t/search-by-column/70897/2 "2024-02-16T22:11:43Z")
You would have to build your own search functionality. A text entry component pointing to a user specific column, then either a query column that filters based on the entered user specific value, or a single value column in your data that retrieves that user specific value so you can use it to compare to your short serial number in a filter.
---
### Author:  [@Tom\_Azaria](https://community.glideapps.com/u/Tom_Azaria)
#### Post date: [February 16, 2024, 10:27pm UTC](https://community.glideapps.com/t/search-by-column/70897/3 "2024-02-16T22:27:09Z")
Thank you for the quick answer, Jeff!
However, I’m not sure I quite follow and understand what my next steps should be.
I’ve just tried both options you suggested but got a little lost in the logic of it.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 16, 2024, 10:46pm UTC](https://community.glideapps.com/t/search-by-column/70897/4 "2024-02-16T22:46:49Z")
What do you have so far?
---
### Author:  [@Tom\_Azaria](https://community.glideapps.com/u/Tom_Azaria)
#### Post date: [February 16, 2024, 10:56pm UTC](https://community.glideapps.com/t/search-by-column/70897/5 "2024-02-16T22:56:29Z")
I have my data in a collection and a text input named “Search Input” above it
I created a user-specific column and connected the text input to it.
I have a filter on the data collection that compares my Short Serial to the User Specific column.
But I feel like I’m missing something essetial to the process.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 16, 2024, 11:09pm UTC](https://community.glideapps.com/t/search-by-column/70897/6 "2024-02-16T23:09:24Z")
Sounds like you are close. Is it not filtering the collection properly? How is your filter configured?
---
### Author:  [@Tom\_Azaria](https://community.glideapps.com/u/Tom_Azaria)
#### Post date: [February 16, 2024, 11:15pm UTC](https://community.glideapps.com/t/search-by-column/70897/7 "2024-02-16T23:15:11Z")
I’m sure I am close.
This is the screenshot of my filter. The word “סידורי” means “Serial” in Hebrew.
I tried it from different directions and I see that the text being put in the text input isn’t really going anywhere, which is the reason I think for this not to work properly at the moment.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 16, 2024, 11:27pm UTC](https://community.glideapps.com/t/search-by-column/70897/8 "2024-02-16T23:27:55Z")
Ok. One thing I would possibly suggest doing is change the operator fro ‘equals’ to ‘includes’. Then change your second dropdown to use the Screen Value.
Assuming the that you have the user specific column in the same table as the data you are searching, you have it comparing the two columns in each row, but if you use the ‘Screen’ value, then it will compare each row in the collection to just the row your screen is attached to (most likely the first row).
---
### Author:  [@Tom\_Azaria](https://community.glideapps.com/u/Tom_Azaria)
#### Post date: [February 16, 2024, 11:32pm UTC](https://community.glideapps.com/t/search-by-column/70897/9 "2024-02-16T23:32:41Z")
Jeff,
You have helped me go to sleep quietly today. This worked beautifully.
Thank you so so very much!!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 23, 2024, 11:33pm UTC](https://community.glideapps.com/t/search-by-column/70897/10 "2024-02-23T23:33:33Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.