# 🔀 In-App Sorting (Simple Solution)

**URL:** <https://community.glideapps.com/t/in-app-sorting-simple-solution/62401>\
**Category:** Community Resources\
**Tags:** tutorial\
**Created:** [June 3, 2023, 2:12am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401 "2023-06-03T02:12:05Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 3, 2023, 2:12am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/1 "2023-06-03T02:12:05Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/24435f8fe74af2c0fa102d1ed71e1b93da2569cc.jpeg "🎓 Glide Tutorial - In-App Sorting") ](https://www.youtube.com/watch?v=HtXVVltE9-U)

**What’s up Gliders!**

I recently came across a [post](https://community.glideapps.com/t/in-app-sort-missing-and-in-app-filtering-has-been-make-worse/62096) asking about in-app sorting.

So I thought I’d create a quick video explaining how to add In-App Sorting to a Glide app so users can sort data as they please!

This seems to be a _fairly simple_ way of getting it done, but I have no doubt there are numerous other ways to achieve the same end result (for example by using the new Query Column when working with larger sets of data)…

That’s the beauty of Glide, there’s always a way!

Cheers 🍻

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 3, 2023, 2:26am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/2 "2023-06-03T02:26:57Z")

</div>

Very nice, I like it 👍

> [@Loqode](#):
>
> This seems to be a _fairly simple_ way of getting it done, but I have no doubt there are numerous other ways to achieve the same end result (for example by using the new Query Column when working with larger sets of data)…

And of course that got me thinking… haha  
mmm, two query columns, I think. Each returning the same but just sorted in the opposite direction. Then an if-then-else column to decide which one to use as the source of a collection. And then we’d only need a single collection.

But everything else the same, I think - I do like the way you set that up.

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 3, 2023, 2:37am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/3 "2023-06-03T02:37:07Z")

</div>

Haha I bet!! 🤣

I played around with the two query columns initially (asc & desc) but it didn’t allow me to select the query column as a value in my if/then/else column (and the rest of the setup remained _fairly_ similar i.e. conditionally hiding/showing tables on the front-end) so I thought I’d leave it as is…

Interested to see what you come up with! 🧠

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 3, 2023, 2:39am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/4 "2023-06-03T02:39:26Z")

</div>

oh, that’s interesting. mmm okay, I’ll have a fiddle later and will let you know if I come up with anything.

---

<div class="post-metadata">

**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\
**Post date:** [June 3, 2023, 7:25am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/5 "2023-06-03T07:25:05Z")

</div>

I think @Robert_Petitto did mention in his tutorial that the query column seems to give out a multi relation in terms of output and maybe that why it won’t show in the if-then-else column to be used…

Great tutorial though @Loqode…  
Keep it up 👍

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [June 3, 2023, 8:07am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/6 "2023-06-03T08:07:46Z")

</div>

How elegant!

For performance purposes we would want to avoid loading 2 long collections with images for instance. So like Darren I wonder if we could push the ascending/descending logic to the Data Editor to avoid having 2 collections. Query or Sort Array might be the way to go.

How very neat. Thank you for the inspiration 🙏

---

<div class="post-metadata">

**Author:** ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)\
**Post date:** [June 3, 2023, 9:48pm UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/7 "2023-06-03T21:48:57Z")

</div>

Very clean video; explains the concept nicely!

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 3, 2023, 11:02pm UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/8 "2023-06-03T23:02:53Z")

</div>

Thanks Luther! Appreciate it.

And that’s interesting to hear about the multi-relation… If Glide allows Query columns to be used in if/then/else columns as values it would unlock a lot of power 🤔

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 3, 2023, 11:12pm UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/9 "2023-06-03T23:12:26Z")

</div>

Thank you @nathanaelb! Yeah I agree regarding the two collection tables… I feel like there’s definitely a way to do it without conditionally showing/hiding two collections on the front end.

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 3, 2023, 11:13pm UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/10 "2023-06-03T23:13:00Z")

</div>

Thanks David! Glad you enjoyed 🙏

---

<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:** [June 6, 2023, 12:22am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/12 "2023-06-06T00:22:04Z")

</div>

[https://community.glideapps.com/t/in-app-sorting-released-in-glide-apps/62477/2?u=thinhdinh](https://community.glideapps.com/t/in-app-sorting-released-in-glide-apps/62477/2)

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 6, 2023, 12:23am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/13 "2023-06-06T00:23:45Z")

</div>

My thoughts too 🤔 Got excited for a minute there! 😅

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [June 6, 2023, 12:24am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/14 "2023-06-06T00:24:50Z")

</div>

MY BAD. APOLOGIES.

I opened that app to see something and got really excited to see that. Later realized it was a classic app.

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 6, 2023, 12:26am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/15 "2023-06-06T00:26:02Z")

</div>

All good!! Hopefully they release native in-app sorting soon 🤞

---

<div class="post-metadata">

**Author:** ![fabio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabio/32/16336_2.png) [@fabio](https://community.glideapps.com/u/fabio)\
**Post date:** [June 6, 2023, 4:21pm UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/16 "2023-06-06T16:21:57Z")

</div>

Hi Guys, Hi @Loqode ,  
Followed your video, didn’t get it working with different users…I was thinking “what the hell…” then I noticed I missed the “make row owner” in users table…set it and Boom, perfect!  
Thanks!!

---

<div class="post-metadata">

**Author:** ![Loqode](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/loqode/32/50217_2.png) [@Loqode](https://community.glideapps.com/u/Loqode)\
**Post date:** [June 7, 2023, 12:02am UTC](https://community.glideapps.com/t/in-app-sorting-simple-solution/62401/17 "2023-06-07T00:02:37Z")

</div>

Awesome Fabio! Glad you sorted it out!
