How to sort the group by in the table collection?

[CuriousGeorge]

I’ve already seen and tried this post, but it only works in List Collection and not in Table Collection. Is there a solution for Table Collection?

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. [Glide: Grouping and Sorting TIPS and TRICKS]

[Lewis_Parker]

Im not sure if there is a better way than what I do, but the below is my take on this.

I just have x amount of table components and filter the table to the group required and give each table a relevant group title

Of course, you can apply more filtering or in-table sorting then individually on each table. And organise them in the builder to order them how you wish

[ThinhDinh]

My way to do this (assuming what you want is exactly grouping the inline list, and sort within each list by multiple columns), is to convert all relevant info into a number.

Something like numeric value of column one * 10^2 + numeric value of sorting column two * 10 would be a good point to start (difference between 10^2 and 10 is to make sure the final value respect the order of sorting it should have).

Works the same way if you need to sort the groups as well (put them inside the logic as the highest level).