Expand all | Collapse all

Kanban vertical sorting

  • 1.  Kanban vertical sorting

    Posted 09-05-2018 14:48
    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 change on a vertical drag? so for example if the sorting order is from 1-6, by dragging card 6 to the position of 1, the fields will swap values and changes are made?

    I find this particularly useful in a scheduling type environment for dragging and sorting Jobs etc.  an example would be to group by technician then have the sorting order be on scheduled time etc.  

  • 2.  RE: Kanban vertical sorting

    Posted 09-05-2018 15:18
    Re: "will there ever"

    The future is now. Is that soon enough for you?

    Go to the table
    Advanced Properties
    Go way down to the bottom and the option switch to enable that is there.

  • 3.  RE: Kanban vertical sorting

    Posted 09-05-2018 17:36
    Hi Geoffrey,

    Mark is correct and that functionality actually has been added to our Kanban reports based on the feedback of our users who had the same needs as you. We have a help topic that goes into that feature in more detail that you can find here">https://help.quickbase.com/user-assistance/kanban_manual_ordering.html">here. Hopefully that can help to answer any questions you have on manual sort for Kanban reports. 

  • 4.  RE: Kanban vertical sorting

    Posted 09-05-2018 18:16
    yes, so this works on face value,  but the actual field value that it is sorted on doesn't change.  this is taken directly from that same help document:

    "Note: This only sets an initial order for your Kanban reports. Users can then reorder cards by dragging them on a report. This does not affect the values of the field chosen as the initial order field."

    So where is the future? :)

  • 5.  RE: Kanban vertical sorting

    Posted 09-05-2018 18:26
    Right. It does not edit field values to change a visible sort order field. The sequence is only maintained in the Kanban format report, not on say a table report.

  • 6.  RE: Kanban vertical sorting

    Posted 09-05-2018 19:00
    When you engage manual sort order it still puts information into order on the Kanban report based on the sort order of the original field being used (For example if it was in order by Date Created) but then once manual sort is enabled any records that are specifically pulled out of order, in your example record six being pulled to be the 1st in priority will now going forward be in place as the first record in that order while the other records will continue to use the previous sort until they are pulled manually into a different sort. The previous sort order exists as a stand in until you chose to take action to change the records sort order but it wouldn't change the Date Created on that record just the records place on your Kanban report. 

  • 7.  RE: Kanban vertical sorting

    Posted 02-07-2019 17:55
    I want to implement an Agile type of methodology, whereby my Sprint team can moves items between columns to show the Status - this works well between columns, and if I move an item, the Status changes.
    However, I also want to have my Product Owner vertically sort the Items with the "Prioritizing" Status column. I have a Priority field on the Item, but this doesn't change if I vertically move the Items within this column. How can I save this Prioritization, so that the rest of the team can see the Priorities set by the Product Owner?

  • 8.  RE: Kanban vertical sorting

    Posted 02-07-2019 19:53
    In the Advanced Settings for the table there is an option to enable manual sorting. But that then would be available to all users. So it may be a problem in your use case.

  • 9.  RE: Kanban vertical sorting

    Posted 02-07-2019 22:37
    You can have more than one Kanban report on a table.

    On the team's report changing columns changes the Status field
    On the owner's report changing columns changes the priority field. 
    Then set the team's report would sort by priority

  • 10.  RE: Kanban vertical sorting

    Posted 02-08-2019 19:35
    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')



    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).

  • 11.  RE: Kanban vertical sorting

    Posted 02-08-2019 19:39
    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.