I am still working on providing users the ability to change the order of Items I am showing them.
I have a column in my DB for the order number and sort the list by that order field.
I want to allow the user to move the item up and down in the order.
Anyone have experience in the approach here?
You can have a simple workflow, that will increment or decrement the order when an arrow is clicked, then refetch the collection which will be ordered by the new order 
Thanks Quentin, it seems like I would potentially need to update at least 3 records.
1st the record I clicked on (increase or decrease by 1)
2nd, I would need to update the record that has the same order number to be 1 higher or lower.
In the Xano request I would have to post an update to all records.
I wonder, when I first GET the records from Xanao, if I should store the record IDs and order numbers in a variable, then make the changes to the order, updating the variable before then POSTing to the DB.