Sorting collapsible group

[Hayley]

Hello, I am trying to sort my collapsible group from my report datapage, but i see no settings or configurations for this and by default it is sorted alphabetically.

Is there a workaround for this? Thanks in advance.

[PotatoMato]

Hi @Hayley, you may try to add an auto number field to your table and concatenate it with your label for collapsible group, then add a formula field for concatenation:

CONVERT(VARCHAR(255),(CONVERT(VARCHAR(255),[@field:AutoNumber]) +' '+ [@field:Categories]))

From here, you can now add the formula field to your report datapage and use it as a label for the collapsible group.

- PotatoMato

[Barbie]

You may also refer to this article for more information: https://howto.caspio.com/function-reference/

- Barbie