Sorting an option set (highest number to lowest) in a repeating group

[findlaterapps]

Hi all, I’ve got a bit of an odd one which I’m hoping someone can shed some light on or point me in the right direction.

I have a data set in my DB that lets a user select the year group of a student in their class. The list is (Year) 1, 2, 3, 4…all the way to 13. He’s a image of the DB structure below -

Now I know that the sort on a repeating group only works if the field you’re trying to sort is either a text or number type but has anyone seen a way were I can sort my “Year group” dataset in order of highest number to lowest or vice versa? Thanks!

[adamhholmes]

This question comes up a LOT…

Basically there are 2 ways.

1. Add a new Number field on the Student Datatype to store the Year Group’s Number

2. User either the ListShifter or Floppy plugin that will let you sort lists by some other list.

[findlaterapps]

Thanks @adamhholmes