One of the functions of my app is to keep a list of people in a certain order (to determine who’s turn it is to do a certain shift).
When someone has done the shift, they need to move down to the bottom of the list.
So basically, have a list of names, and a number behind their name from 1 to 25 (there are 25 people). I need something like an option to move people in this list (and make it save in the database). It can be a button that moves the top person to the bottom, or a drag/drop kind of thing if that’s at all possible in the app. Does anyone have any suggestions on:
a) how to save the order of people in the database (I thought of using a column with the “number” 1-25, but if there’s a way to re-order the table rows, I could also use _RowNumber)
b) make it possible for app users to move rows around (at least it should be possible to move the top row to the bottom, making number 1 -> 25, 25 -> 24, 24 -> 23, … and number 2 -> 1) .
Any help would be greatly appreciated!
User | Count |
---|---|
15 | |
11 | |
9 | |
7 | |
3 |