Can I change the order of the rows in my source table (Google Sheets)

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!

0 3 1,540
3 REPLIES 3
Top Labels in this Space