# I found a Search solution, but I don't like it
**URL:** https://community.glideapps.com/t/i-found-a-search-solution-but-i-dont-like-it/36086
**Category:** Ask for Help
**Created:** [December 18, 2021, 6:02pm UTC](https://community.glideapps.com/t/i-found-a-search-solution-but-i-dont-like-it/36086 "2021-12-18T18:02:38Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@fluittsolutions](https://community.glideapps.com/u/fluittsolutions)
#### Post date: [December 18, 2021, 6:02pm UTC](https://community.glideapps.com/t/i-found-a-search-solution-but-i-dont-like-it/36086/1 "2021-12-18T18:02:38Z")
Hello,
Hoping someone can help me find a more elegant solution.
Here is my situation:
- Sheet one is a list of events with location, description, etc.
- Sheet two is calendar listing with start and end times.
- The two sheets are linked with a relation column based on event name. MANY calendar listings to ONE event listing.
My app has tabs built on the calendar sheet, but I want to allow a filter based on ANY word in the event description. The search bar doesn’t cross over to that field on the event sheet.
I have seen @Robert_Petitto great video suggesting tags for this purpose, but that solution won’t fit my scenario. (Side note…all of @Robert_Petitto videos are fantastic if you haven’t seen them. They are a true “go to” for me when I am stuck or looking for new ideas.)
The solution I have incorporated is this:
- Added Lookup column to calendar sheet that pulls in event description from event sheet.
- Created text entry field/single value column scenario allowing user to type anything.
- Created If-then-else field of IF lookup event description INCLUDES single value text entry, THEN “true.”
This is working beautifully…I just don’t like the clutter it creates on the calendar sheet. Because calendar dates to events is "many to one, " if an event is weekly, then the (lengthy) event description repeats on 52 rows of the calendar sheet.
Can anyone suggest a cleaner way to accomplish allowing a search from an event sheet field on a calendar sheet-based tab?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [December 18, 2021, 6:27pm UTC](https://community.glideapps.com/t/i-found-a-search-solution-but-i-dont-like-it/36086/2 "2021-12-18T18:27:57Z")
Does this help?
> [@mag\_right Glide: Search Box Tips and Tricks](https://community.glideapps.com/t/glide-search-box-tips-and-tricks/23959):
>
> 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] ](https://www.youtube.com/watch?v=bTJRVktvpVI)
You don’t have to use tags, but rather look up or a join list of the information you want to search and then hide it so it’s not visible on the details page.