# Choose Order of Grouping **URL:** \ **Category:** Ask for Help\ **Created:** [November 13, 2020, 9:54pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382 "2020-11-13T21:54:26Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 13, 2020, 9:54pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/1 "2020-11-13T21:54:26Z")
Hi, I am grouping a list within my app, but I would like the grouping to be in a certain order Ex: To-Go Dine-Out To-Go & Dine-Out Right now it’s: To-Go & Dine-Out To-Go Dine-Out ![dine](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c052a5fada410c3f1c77d93233e618ae5e5ae876.jpeg) Is there a way to do this? Thanks! ---
**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:** [November 13, 2020, 10:19pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/2 "2020-11-13T22:19:15Z")
What I do is I have a separate sheet with groups and other various lists that I use for choice components. In that sheet I also have a column with a list of numbers to assign order to each item. In your main sheet you can do a relation/lookup to the choice sheet and get the order number for each group. Then I would create a template that joins that lookup order number to whichever other value you want to sort by. Then use that template column for your sort order. ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [November 13, 2020, 10:20pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/3 "2020-11-13T22:20:49Z")
I use an if then else column to define numbers for categories and use that column to sort the list. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 13, 2020, 10:25pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/4 "2020-11-13T22:25:16Z")
Oh, I think I can do this! 😀 Thank you!! ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 13, 2020, 10:59pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/5 "2020-11-13T22:59:58Z")
That worked Manan. Thanks! ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 13, 2020, 11:00pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/6 "2020-11-13T23:00:09Z")
Thanks Jeff!! ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [November 14, 2020, 3:14am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/7 "2020-11-14T03:14:47Z")
That’s great idea ---
**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 14, 2020, 5:44am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/8 "2020-11-14T05:44:08Z")
Another additional idea is when I want to show the favorited items at top, after that sort by another numerical value. I had a case like that with my Fantasy App, favorited players first then sorted by projected points descendingly. I add an if then else column to add a numerical value when the player is favorited, a very big one that the projected points can never reach, like 1000. Then sum the two values and sort by that column. Kind of a multi-category sort. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 14, 2020, 10:59pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/9 "2020-11-14T22:59:41Z")
So I noticed, the in-app sorting, gives the viewer option change that order. Is there a way to sort it on my end, not in-app. ![dine3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/23286cde0ba6114d89f6243ef3c20cb8e5846ad4.jpeg) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 14, 2020, 11:01pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/10 "2020-11-14T23:01:13Z")
Ohh good to know!! thanks Thinh! ---
**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 14, 2020, 11:25pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/11 "2020-11-14T23:25:06Z")
What do you mean by “sort it of my end”? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 14, 2020, 11:37pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/12 "2020-11-14T23:37:09Z")
The type of sorting seen here, not in-app. ![dibe4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3ed2fd0c0b959773985a2de68e8a577beb5d0de5.png) ---
**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 14, 2020, 11:51pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/13 "2020-11-14T23:51:38Z")
That is an option that only you, the app owner can set. The in-app sort is there to help users sort the data based on their preference and not affecting the behind-the-scenes setup that you made. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 15, 2020, 3:39am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/15 "2020-11-15T03:39:45Z")
> [@ThinhDinh](#): > > That is an option that only you, the app owner can set. Ok so this option is not available in the ‘see more’ list? ---
**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 15, 2020, 4:37am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/16 "2020-11-15T04:37:59Z")
I think it automatically sorts based on the initial list. Can you confirm? ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 15, 2020, 5:12am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/17 "2020-11-15T05:12:53Z")
The first image is what the feature options look like, only in app sort is available. ---
**Author:** ![Travis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis/32/4339_2.png) [@Travis](https://community.glideapps.com/u/Travis)\ **Post date:** [November 15, 2020, 7:04am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/18 "2020-11-15T07:04:15Z")
You can do it, but you have to do it on the component the user selects to see more. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/916a5d3915ef98f10c09a380bcc0cdcd568a231a.png) ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 15, 2020, 5:10pm UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/19 "2020-11-15T17:10:02Z")
Oh yea, that sorts it on that first screen, I want it sorted on the screen they see once they hit ‘see more’, without having the in app-sorting available. ---
**Author:** ![Travis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/travis/32/4339_2.png) [@Travis](https://community.glideapps.com/u/Travis)\ **Post date:** [November 17, 2020, 1:43am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/20 "2020-11-17T01:43:12Z")
It will sort it on that page. You can not select any in app-sorting, then the user wont have any options to sort within the app. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [November 17, 2020, 2:15am UTC](https://community.glideapps.com/t/choose-order-of-grouping/18382/21 "2020-11-17T02:15:50Z")
I don’t want them to have the option here.