How to maintain a list order after an action

Ask for Help
1

I feel like there is an easy answer for this that I am missing.

Here is the use case:

The client has a list of 20 drivers who are on a list. When a significant weather event happens, they will call in a portion of that list to work. For this example, 5 of the 20 drivers.

Those drivers will open the app and designate whether they are coming to work or not. If they say they aren’t coming in, the 6th person in line gets called in.

The dilemma is that I must maintain that order regardless of whether that person answered the negative or the positive. Additionally, some drivers may be inactive due to an injury but must keep their order. Example: They need 5 drivers but the 2nd person on the list is injured and should be skipped while still maintaining their spot in the order. This would result in the 6th driver being called immediately.

The list continues to rotate and individuals maintain their specific spot.

Any ideas on how the logic of this should work?

2

Could you have a column to manually number each driver and then sort by that that numbered column?

1 Like
3

I’m probably not fully understanding. Are you recommending creating a column with values from 1 to 20 and sorting by this?

The issue is that when the first five are called out, they must move to the bottom of the list. This could be solved by adding a value to each of these, but some individuals need to be skipped while still retaining their place on the list for the future.

4

How about this… Whenever driver is called out and answers that call, write the current date time to their row. Then sort in acending order by that date column.

2 Likes