I have a repeating group which shows a list of users, and every user has a “Position” variable on them. I’m trying to sort my repeating group by hierarchy, but for some reason it wont let me sort by the same field more than once. For example, users would be listed like:
(Board Member) J. Doe
(Board Member) A. Doe
(Admin) F. Doe
(Mod) E. Doe
where I would manually define who comes first, based directly on their position variable. I would define it to put Board Members first, Admins second, Mods third, everyone else 4th+. Right now, it just defaults to alphabetical order, which doesn’t help me.
How is this possible?