πŸ‘¨β€πŸ‘©β€πŸ‘§β€πŸ‘§ Grouping and Sorting TIPS and TRICKS

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.

7 Likes

Nice. It does feel this could be native :slight_smile:

2 Likes

Right?

Every time I need to group, I’m slightly concerned (?) about the fiddling around I am about to go through to sort correctly. :sweat_smile:

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? :see_no_evil:

Ya if you look at the end of my video you’ll see it happen.

2 Likes

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 :wink:

3 Likes

Ya…agreed. This was more conceptual (and to provide rationale to Glide as to why we need more advanced sorting natively :wink: )

3 Likes