A question regarding the sorting. So Kanbans automatically change the grouping "based on" field value when dragging "across" the groups. Will there ever be an option to have the fields chang...
The direct answer is, right now you cannot do this. The Kanban report can only exist on one bucketing variable. The vertical sorting is a kind of epi-value that exists only for the purposes of sorting that Kanban report, and is persistent but not tracked or evident anywhere else in your app's universe.
Here's one way of addressing this. Create values in your Status field for 'update priority' for each priority ranking you want to be able to reassign your jobs to, and have them display on your Kanban. Set automations to fire when the Status value is changed to those values to change its Priority (and reset its Status as well)
It's slightly awkward to use, as you might expect. But it works! Here's a quick demo:
So we've got a two variable workspace: Status and Priority. The Kanban groups by Status and sorts by Priority. Here are the multiple choice settings for Priority and Status:
Here's the automation (I set up just one, for 'MAKE HIGHEST') trigger
activity
Kanban
It works perfectly. Just the view doesn't refresh automatically.
Drag your Kanban card from its status column to the "change priority" column (I only drew up one for the demo but it can be as detailed as you want/have space for); the automation changes the priority to the one you've linked to that status category and then re-sets the status (I had it re-set to 'queued' but you could create a custom status or set it to a particular one, or or or..)
So it's a hack to be able to update your Kanban sort field even though the report can't directly manage that field for you. You just have to manually do one of two things: refresh the report, or drag the card to your preferred Status column (this actually works fairly well, and makes intuitive sense to me - it's like those old 'factory ball' Flash games - use the 'CHANGE PRIORITY TO..' column to 'paint' your job with the priority you want, then when you put it in its proper Status column you'll have re-sorted the priority permanently).
Extension to the use case where some roles should only be able to see the native status values and some should have access to the columns that change prioritization should be fairly trivial; create one Kanban with all the Status columns and one without the 'MAKE ... PRIORITY' columns and permission those reports based on role.