Collection Group By Setting

[SageCat]

So I’m using the Collection component and I’ve advised it to group by Status, but is there a way I can change the order that the Status shows? It isn’t in alphabetical order so I’m not sure how it is getting the order, but essentially I want to define the order. Is this possible and, if so, how? Thanks in advance.

EDIT: It is currently showing in this order: Neonate, Adopted, Deceased, Available, Other. But I would rather it show Available, Neonate, Adopted, Deceased, Other.

[MaximeBaker]

This is due to the sorting option. It sort by the value you settled. Group aren’t sortable out of the box. But here is how to do it.

Create an if then else column with the order you want for each group. Example:
If status = Available then 1
If status = Neonate then 2
If status = Adopted then 3
If status = Deceased then 4
If status = Other then 5
Else 999999

Then, create a template column and set it to “ab”.
Replace “a” with the if then else column and replace the “b” with the item name column (the one you would use to sort).

Finally, change the sort option to that new Template column.

There you go! Groups and elements are sorted.

[ThinhDinh]

Here’s an alternative with JavaScript, converting all info into a number.

const statusOrder = {
    'Available': 1,
    'Neonate': 2,
    'Adopted': 3,
    'Deceased': 4,
    'Other': 5
};

// Convert the first letter of the cat name to its alphabetical position

const letterCode = p2[0].toLowerCase().charCodeAt(0) - 96;

// Combine the status number and letter code using the formula

return statusOrder[p1] * 100 + letterCode;

[SageCat]

Hi. I understood (I think) the if then else part, but you lost me with the template column paragraph. Are you able to please maybe do a screenshot of the setting so I clearly understand what I’m putting where?

EDIT: I got it! I thought I would paste the example here so others know in future. Thank you so much!

[MaximeBaker]

My pleasure! Anytime!

[SageCat]

Hi, could I please ask one more follow-up question in regards to this? So it is all sorting nicely now into the required status order, thank you very much, but how would I then order the cat names within each status order into alphabetical order? We have just realised that it is in the order that the cats are entered into the database which happened to be alphabetic to start with but subsequently, with use, is no longer so they are listing in the order they happen to have been added.

[MaximeBaker]

Found the error.

Change the “b” replaced value to the name of the cats.

I did not see your errors in the first place sorry about that!

[SageCat]

Oh that is purrfect! Thank you. Screen shot should anyone be trying similar at home…

[MaximeBaker]

Glad it worked!