I’m reaching out to discuss about the better way(s) to solve this problem:
- I have a table for tasks (project management) with a duration column in days
- I display the agenda for each people by computing a “start date” column that gets incremented based on all the previous tasks’ durations (I have a hidden column that does the sum of all durations where rowID < thisRow)
–> Now, my issue is that I need to tell which task should go first, which one second etc. not based on rowID
So I was thinking an ideal way would be to have a view on the tasks, and simply order them by drag and dropping them up and down to define the relative priority between these tasks. This way everything can get computed in an orderly fashion, and that new very urgent “task 54” that just has been added can be dragged in first position so that the people whom it been assigned too will see it on top of his agenda.
Sadly, I couldn’t find anyway to do this. So now I’m slowly falling into despair by referring to “rowID” as a “priority” column, and adding 4 action columns (priority +1, -1, first, last) along with a “relative priority” column to store the needed shift based on rowID. And doing a lot of bookkeeping so that nothing messes up this relative priority. Along with cases where it actually fails (how to sort equal priority, and others).
Any thoughts would be appreciated. Perfectly working solutions even more Thanks in advance