when creating a new thing, i need its order number to be calculated through its chronological time order relative to other things in the list.
I have a bus app and users need to be able to create many ‘stops’ under a single ‘route’. When creating stops they will do it for each client; so a pickup and drop-off for each client. When this is added to the database at the workflow level i need each respective stop (drop off and pickup) to calculate its ‘order number’ relative to the existing stops. It needs to be calculated chronologically on the existing stops’s times. So if I have a stop at 9am and 10am, and add 2 stops of 9:15 and 9:30, their order number would be 2 and 3 respectively. So far Im looking into the ranked by but im stuck. Any help would be much appreciated. Thanks
What is your existing UI like for the user to create these schedules? Are you using drag and drop feature at all?
Im actually replacing an existing system, and its an admin tool for the owner of the business, so they already have perfectly laid out time slots for each route, I just need the data entry person to be able to add in each person and their existing stops and times, which need to then have an order number attached so it can fir where it is supposed too. the order number is important as sometimes the routes change a bit.
I am using drag and drop for the reordering for specific changes to the existing routes.
When they drag and drop, change the order numbers, and do not rely on the time, since your user will be dragging and dropping according to time.
Yes thats what im doing. As described There are existing lists of stops with the correct times from the previous system that need to be uploaded, so they firstly need to be ordered on time, but then also have order numbers so when the drag and drop feature is later used I have order numbers
