Glide currently doesnât have a way to sort an inline list by more than one field.
So what happens when you want to group your inline list, define a sort order of the grouping AND sort within each group?
Youâll need to use some ingenuity, and a combination of TEMPLATE and IF THEN ELSE columns.
Nice. It does feel this could be native 
Right?
Every time I need to group, Iâm slightly concerned (?) about the fiddling around I am about to go through to sort correctly. 
I donât know if this is still the case, but have you noticed when you group and then sort (alphabetically for instance), when you add an item to the list, the groups might bounce around to maintain the (alphabetical) sorting? 
Ya if you look at the end of my video youâll see it happen.
Another great video Bob, thanks.
For my 2c, I believe the workaround when you have a limited number of âGroupsâ is to simply keep duplicating the list as many times as you have groups. You can then arrange them in the order you prefer with the title being the group. Itâs a simple step then to filter each list based on the row containing the listâs respective group and of course sorting the contents based on the second criteria.
This works well and looks almost exactly like the single list with all the extra programing 
YaâŠagreed. This was more conceptual (and to provide rationale to Glide as to why we need more advanced sorting natively )
Just wondering if over one year on there was any improvement on grouping / sorting etc in Glide.
At first glance - there seems to be no change (Iâve been away from the app for a while)
Do we still need to do crazy workarounds?
What Bob shows in that video can now be done quite easily with the new Query column (one of the most powerful new features weâve gotten in the past couple of years).
YaâŠquery helps for sure, but (to my knowledge) it doesnât completely solve the sorting within a grouping.
Iâd need to take another look. Perhaps I could share a followup video at some point with my findings.
I guess it depends on the use case, but it does handle the example thatâs shown in your video.
What you would do is sort the query column by Athlete name, then group and sort the collection by College Status.
Thanks both!
Just watched @Robert_Petitto excellent video on this. Really helpful.
Iâve been wondering if I can have something similar to a saved view in Airtable and I think I can do this with Query columns.
Iâll have a separate table called âviewsâ then a column for each column in the main table I want to filter on - then I can add a row for each view I want and have a query column that dynamically gets the right data (using this row in the query)
Great stuff!!
âone of the most powerful new featuresâ ??? What else is even close 
Having only been a Glider for 15 months - I canât see anything that remotely comes close to the power of Query! Pages (e.g. Glide) was a must-have to keep up with the other builders (and is a nice implementation) but Query is so simple and powerful.
@Mark @david - It is game changer for actually using the data gathered with Glide.
IMHOâŠ
Would love to see an implementation of this when you have one ready to showcase
@Robert_Petitto You inspired me to set one up!
Here you go : http://filter-test.flair.london
I have this working just as I need it (almost) - it is set to open access with email - happy to make it wide open if need be. Just a test.
The only thing I am REALLY struggling with - is getting the Query column to return multiple options.
For example -
I have tried using a âSplit Textâ column - then using that in the Query - but I am not sure why, but the Query column does not allow me to choose a âSpot Textâ column from This Row to use in the query.
The other issue I had, which I got round with a simple âIF Then Elseâ - was that if the Location in the views table column is empty - the Query returns all rows from the schedule table that are blank. So my If column just fills in some arbitrary text so that no columns are blank to get round that (but it makes me wonder if I have it set up wrong)
I am using âincludesâ in my query.
Would love some help getting my query to work on multiple options if possible - am rather stuck and so close!
Thanks loads,
Andrew
Views table
The query
You probably should be using:
Location âis included inâ Location-computed.
You should be checking if your single value is included in a list of values. Not checking if a list of values are included in a single value.
Thanks Jeff
I think that was it! Plus - I needed to change the condition in the Query to AND - not OR
Still testing it - but I think I am there. Just need to work out how to make it show âAll entriesâ - but am fairly sure I can get there.
Thanks loads - hope his helps someone else. Thanks to @Robert_Petitto too - your videos really helped.
Andrew
Sorry - knew I was typing too soon.
I do need to use OR in the Query. Idea is that the âViewâ for Supplier 1 for example, shows everything for Supplier 1 - regardless of venue. Now I have changed it to AND - of course it only shows Supplier 1 - IF the venue also matches (AND - not OR)
Would you mind expanding on your comment on âSingle Valueâ - I know thatâs a column type - but donât see how I could use it here.
I wasnât referring to the Single Value column type. I was referring to the literal sense. For example, an Apple is a single item. A basket contains multiple items (ie basket of apples). You can check if an apple is included in a basket of apples, but you canât check if a basket of apples are included in a single apple.
