Forum Discussion

Re: Kanban vertical sorting

good idea to use formula numeric.
I'm new to quickbase, so not sure when to use the correct method.
is there a way to change formula so that if it is empty or zero to set the value to a high number so that non-sorted items are lower in the order?


------------------------------
Johnny Niumata
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    I don't think it can be empty or zero.  I believe that when you first enable the Kanban on he Advanced Properties of the table it orders them by the default sort field - ie the sort set on the default report which might just be by highest date modified first, if it was not changed.

    When you enable the feature there is a pop up message saying to "wait a sec while I do some work".  I'm guessing that  it is then going ahead to create that new field and then assigning a value to all existing records.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JohnnyNiumata's avatar
      JohnnyNiumata
      Qrew Member
      gotcha...
      I just tested adding in more records and it automatically created the sort order number by incrementing to the previous sort order number within that kanban column (in my case "work ticket status" is the column). 

      here is a response from the table in JSON
      { "data": [ { "25": { "value": "WC1.01" }, "72": { "value": "Not Started" }, "75": { "value": 19.9 } }, { "25": { "value": "CAS1.01" }, "72": { "value": "Casting and Shipping" }, "75": { "value": 30 } }, { "25": { "value": "JAM1R.01" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.701 } }, { "25": { "value": "SSK2.01" }, "72": { "value": "Mold Dept" }, "75": { "value": 60.2 } }, { "25": { "value": "SSK2.02" }, "72": { "value": "Mold Dept" }, "75": { "value": 60.1 } }, { "25": { "value": "SSK2.03" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.60000000000002 } }, { "25": { "value": "UB1.0" }, "72": { "value": "Not Started" }, "75": { "value": 21 } }, { "25": { "value": "UB2.0" }, "72": { "value": "Mold Prep" }, "75": { "value": 69.50000000000003 } }, { "25": { "value": "JAM1.01" }, "72": { "value": "Not Started" }, "75": { "value": 90 } }, { "25": { "value": "KS1.1" }, "72": { "value": "Not Started" }, "75": { "value": 100 } }, { "25": { "value": "PAN13.1" }, "72": { "value": "Not Started" }, "75": { "value": 110 } } ], "fields": [ { "id": 25, "label": "Part number variant", "type": "text" }, { "id": 72, "label": "Work Ticket Status", "type": "text-multiple-choice" }, { "id": 75, "label": "KanbanPriorityOrder", "type": "numeric" } ], "metadata": { "numFields": 3, "numRecords": 11, "skip": 0, "totalRecords": 11 } }​

      ------------------------------
      Johnny Niumata
      ------------------------------