How do i cycle back through RG and update the ORDER NUMBER

[ryan8]

I am trying to make some drag drop boxes that are re-orderable… i would like to just drag the group with Order # to another group and just add 0.1 to order number so that the RG records order is correct.
This only works for a little bit until you add new records or drag too many times. Somehow they all end up at the same number sooner or later.

Record1 - 1
Recoord2 - 2
Record3 - 2.1 (Dragged on to position 2 becoming 2.1)
Record4 - 3

Then have it cycle back through as a scheduled custom WF and fix them, rolling them back to 1,2,3,4 in the same order. Is there an easy way to do this. There does not seem to be a way to get the current cells index to cycle through each record. It seems you can only call the index of the record you are updating and apply that index to ALL records in the rep group.

[renelonngren]

There are a couple of posts in the forum on this including

Drag-and-drop ordering perfection

Andrew has an great tutorial on implementing drag-and-drop functionality in repeating groups, but it’s primarily a quick start guide that swaps two items in a list with each other’s position, which is probably not ideal for most use cases. (For example, if you have 3 items, ABC, and drag A to the C position, the order becomes CBA. The desired behavior would be BCA.) As such, I’d like to ask how you all managed to solve this. I see that @Scott suggested a clever solution involving averages, tho…