My app has a table of projects and the table is sorted based on a certain field (like status or it’s score (of how easy+impactful it is)) and people can obviously update any field, like status or score.
The problem: When the table is sorted on score for example, and user updates the scores of a project, it might surpass a different project and it suddenly jumps to a different place. I don’t want this to happen, since it makes it hard to make multiple changes quickly to several projects, because they swap places all the time while you’re editing them.
How should I sort the table so that it stays in the same original order, until the user clicks on ‘refresh sorting’ again themselves?
(A regular solution is probably sufficient, but I use ListShifter KW plugin for this list generation & sorting, so if someone has that exact example, that’s even better!)