Essentially yes, you need to create a field that will hold the sort number. Then you create a series of actions to +1/-1 to entries.
But there’s all sorts of extra complicatedness you need to consider
- What happens when you delete something?
- What happens when you add?
- When you change one number up, you then need to change the one below it as well.
There’s just all this… extra stuff you’re not thinking about until you use it. Then you’re like, “Oh crap! I completely forgot about XYZ”. And when you get into the solution you’re like… HOLY CRAP! This is WAY more complicated than I thought. (^_^)
I think there was something like 10 actions I made last time to make this work smoothly.
You’ve also got to consider groups in there too. You just can’t give “item number 1 in group1” the same sorting number as “item number 1 in group 2” - that being 1.
- If you ever tried to sort by that, with something that didn’t have the grouping, things would be all messed up.
So you’ve got to take group sorting into consideration as well.