# Glide pages: Sort data. Best experience

**URL:** <https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751>\
**Category:** Ask for Help\
**Created:** [July 1, 2022, 11:23am UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751 "2022-07-01T11:23:04Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\
**Post date:** [July 4, 2022, 2:03pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/21 "2022-07-04T14:03:37Z")

</div>

Ok, thank you. That’s what I thought about.

---

<div class="post-metadata">

**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\
**Post date:** [July 9, 2022, 1:08pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/22 "2022-07-09T13:08:29Z")

</div>

Hi, Darren.  
I do some experiments with search and try to search like users do. For example:  
**record electric guitar**  
**male singer for rap song**

As I understand an item in my table should contain exactly that combination of words. Only in this case we will find an item? May be there is some workaround to search like search engines do?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/96552_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 9, 2022, 1:30pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/23 "2022-07-09T13:30:38Z")

</div>

I don’t think you’re going to be able to get search engine type behaviour without an awful lot of complexity.

What you could do is use a split text column to split the search term into multiple words, and then a series of single value columns to pick each word from the split text array. And then compare each word individually. But you’d have to set an upper limit on the number of search terms, and you’d be adding quite a few extra columns. And I’m not sure how well it would work. You might find that it’s not worth the effort.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 9, 2022, 1:40pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/24 "2022-07-09T13:40:24Z")

</div>

There was a long discussion about building basic search functionality, which eventually led to some javascript or external code to handle it with some google like functionality to handle AND/OR situations in the search. Could probably be done with some values passed into a javascript column but still gets complicated and all depends on what kind of functionality you want from a search.

> [@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)

---

<div class="post-metadata">

**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\
**Post date:** [July 9, 2022, 2:05pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/25 "2022-07-09T14:05:01Z")

</div>

> [@Darren\_Murphy](#):
>
> What you could do is use a split text column to split the search term into multiple words…

Yeap. I think this is not a solution.

---

<div class="post-metadata">

**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\
**Post date:** [July 9, 2022, 2:06pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/26 "2022-07-09T14:06:34Z")

</div>

> [@Jeff\_Hager](#):
>
> external code to handle it with some google like functionality to handle AND/OR situations in the search

What if we use Glide API to make google like search? Is it possible?

---

<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:** [July 9, 2022, 2:15pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/27 "2022-07-09T14:15:49Z")

</div>

Can you explain more about your idea here? Glide API currently supports adding rows, setting column values and deleting rows, for your information.

---

<div class="post-metadata">

**Author:** ![Garik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/garik/32/44224_2.png) [@Garik](https://community.glideapps.com/u/Garik)\
**Post date:** [July 9, 2022, 2:30pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/28 "2022-07-09T14:30:29Z")

</div>

Thank you for information. I will discuss ideas with my team and tell you what we’ll come to.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [July 9, 2022, 2:38pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/29 "2022-07-09T14:38:38Z")

</div>

One possible thought would be to create a template column that joins all the columns that you want to search into one column. Then use a split text column to split all the words using space as a delimiter. That will give you an array of all searchable words in a row.

Then you could use a text entry component to enter your search words. Then use a similar split text column to split the search words into an array.

Then you could create a relation linking the search array to the words array in your other tables. Any table rows that have a match should show up in the relation and then you can display the results in an inline list sourced from the relation.

---

<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:** [July 10, 2022, 2:39pm UTC](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751/30 "2022-07-10T14:39:25Z")

</div>

Closed on July 10, 2022, 2:39pm UTC

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

[Previous page](https://community.glideapps.com/t/glide-pages-sort-data-best-experience/43751.md?page=1)
