Custom sort orders for subpanels

is there a way to set ‘sort_order’ and/or ‘sort_by’ to a custom list of your choosing?
As in, lets say I have a name field where there are 2 Apples, 3 Oranges, 2 Grapes, and I want the subpanel results containing those sorted so that it shows all Apples, then all Oranges, then all Grapes. Since my list is out of alphabetical order, a simple ‘name’ and ‘asc/desc’ won’t do.

I’m just thinking loud here: What if you create a custom field and called Category for example. That way your records can be sort based on that said field…

1 Like

that was my thought, just to make a field that = 1 if field X == Apple, 2 if field X == Orange, 3 if grape, and order that number field in ascending order. Was just wondering if there was a way to set a custom order other than ascending or descending, like if we did have category then something like sort_by->category, and sort_order-> [“Apple”, “Orange”,“Grape”]; know what i mean?