Forum Discussion

GeoffreyHarmuth

Qrew Captain

6 years ago

Kanban vertical sorting

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

reports and charts

MarkShnier__You

Qrew Champion

Thx for posting this. I did not test it all out, but I did take note of the fid of my highest numbered field, then enabled Kanban in Advanced Properties and then added another field. The fid of the new field "skipped" a number, as your discovery would suggest it would as the new hidden field took up the next fid.

Also, rather than a webhook, I simply created a formula numeric field called [Kanban Priority Order mirror] with the formula

[KanbanPriorityOrder]

Although the formula editor complained in yellow, in fact the field did save without errors and worked just fine on a table report as a column or a sort field. So no Webhook is required.

Thx for the tip.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Qrew Member

4 years ago

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

MarkShnier__You
Qrew Champion
4 years ago
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
  Qrew Member
  4 years ago
  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
  ------------------------------