I’m modeling a process in a table. Each record is a step in the process, there’s a field “Group” for steps done sequentially as a unit, and a field “Phase” that collects groups done in a particular order. Since it’s a process, it’s important to show the steps in the order in which they must be done in the group and the groups in the order in which they must be done in the phase.
I’m adding step records to a grid view and want to show them stacked by group in a kanban view. It seems like by default, the items in a stack are shown in creation order in the table. That means if I figure out a step I forgot in a group, I add it to the grid and manually reorder it to be at the right spot in the grid view. It’s still at the end of the group in the kanban view though, so I’d need to manually reorder it there, too.
Given that I’m going to have a bunch of kanban views and that I’m going to have a fair number of editors, I don’t want to trust that everyone will remember to go in and update every kanban view every time they insert or reorder a step. I don’t trust myself to remember to do that.
To be able to share an ordering across views I’ve added a “Process Order” int field that I fill to be the order the steps are done globally across the process. That lets me sort by Process Order in every view and get a consistent ordering. It means all my editors need to know to update Process Order when they’re adding steps or that they need to update it if they want to reorder steps. It’s a complicated thing to explain.
Being able to share the order from one view with all the others would make this way easier. Is that possible somehow? Or is there a way to do this that’s less clunky than having an artificial, hand-maintained sorting field?