Drag and drop records to set "order" field

[lukebranford]

Use case: I have a list of records which have an “order” field (integer). This order field represents the order in which tasks should be completed. It’d be great to have a component that allows users to drag records to change the order.

Note that I know I could somewhat achieve this with a single select, then enable drag & drop, but I somehow need to ensure that all the order numbers are unique (so if I move an item from order 1 to 2, the item at number 2 should be moved to 1!).

Not sure how useful this would be for others, maybe an edge case! Note this is related to my ask for help post found here:

Drag and drop to reorder records

Hi, I think you should to enable drag and drop reordering in Noloco consider switching the order field to a select field with predefined options (1-10). Then, use a custom script or a third party integration that supports drag and drop functionality to reorder the items visually. This way users can easily rearrange records and the order will be automatically updated in the database. You can also check if Noloco offers any built in features or plugins to facilitate this process. Thanks