Discussions

 View Only
Expand all | Collapse all

Kanban Card Limits per Column

  • 1.  Kanban Card Limits per Column

    Posted 08-15-2018 16:35
    Is there a way to increase the number of cards in a column? For instance I have a "Task Completed" column but it maxes out at 50 even though my phase has 68 completed tasks. Thanks.


  • 2.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 13:54
    Hi Jaime,

    Currently the limits on Kanban reports are set to 50 per column. If you think that an increase in that number would be helpful I would suggest adding it as a request on our User Voice page and letting us know if there is a number that would work best. User Voice is our customer feedback platform that is used by our development team to look at customer requests and suggestions for enhancements and changes to features. Kanban reports and the way our customers use them is something the PD team is looking at very closely right now so its the ideal time to get a suggestion in.

    User Voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab or at http://quickbase.uservoice.com .  This forum is used by our development team to explore customer suggestions for enhancements / changes to the platform. If you do put in a user voice suggestion I always recommend posting the link back here in Community so other users that have the same need can add their votes and show support. 


  • 3.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 14:12
    Good morning Evan,
    Thank you for the response. I'll jump on uservoice and post a suggestion. Ideally I would like to use the Kanban for my application based on the interface but would definitely need to see more than 50 cards per column. Thanks for your help.


  • 4.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 18:43
    Glad I could help Jaime, its great to hear feedback from users interested in Kanban. For those on the Community who are interested you can find this User Voice request here:

    https://quickbase.uservoice.com/forums/111823/suggestions/35052007



  • 5.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 19:01
    Hi Jamie, I've got a kanban 'hack' to help prevent closed cards from piling up in your Kanban report. This may help with your situation. https://www.quickbasejunkie.com/blog/how-to-kanban-hacks#hack03


  • 6.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 20:44
    Thank you! Extremely helpful. Just subscribed. Looking forward to more good stuff.


  • 7.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 20:23
    Hi Sharon (a.k.a. Ms. Quick Base Junky)

    Great Tips, thx for posting.

    I thought I would post one too.  So Rich text fields work, so i wondered if I could get a HTML button or icon to work to edit a record and refresh the page without gong into edit mode on the card (record)

    In my case I wanted to change the color bar to indicate my activity level on a project.  By that I man I'm in a client meeting and we are juggling my priorities, and I may have several projects at the highest priority level, but for one reason or another I'm kinda in idle mode waiting on the users for information to proceed.

    So, I decided that Green meant I was fully engaged, Yellow means just some light clean up, Blue mean sleeping - I'm waiting on others,  etc.  So I wanted a button to cycle the colors down, as I often start out gung ho in Green and then fall back to idle mode as the project gets turned over to the client for testing and feedback. 

    here is my formula HTML code

    var text NextColour = Case([Activity Level Colour],
    "", "green",
    "green","yellow",
    "yellow", "blue",
    "blue","grey",
    "grey","green");


    var text red = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Project ID#]
    & "&_fid_50=" & $NextColour;



    var text Words = "<img src=https://images.quickbase.com/si/32/814-keyed_collection.png>";

    var text URL = "javascript:" &
    "$.get('" & 
    $red & 
    "',function(){" &
    "location.reload(true);" &
    "});";


    "<a href=" & $URL & ">" & $Words & "</a>"


  • 8.  RE: Kanban Card Limits per Column

    Posted 08-16-2018 20:43
    Very cool. Thanks. This will work well with the task report I do.


  • 9.  RE: Kanban Card Limits per Column

    Posted 08-17-2018 23:13
    I like it! Thanks for sharing Mark


  • 10.  RE: Kanban Card Limits per Column

    Posted 08-17-2018 23:36
    Taking a queue from your code, I applied it to the Status field, to cycle through various task statuses. Ended up needing to add a URLEncode due to spacing between words and QB seems to occasionally 'glitch' when I press the button (opens the record to edit)... but all in all a very cool effect!

    var text NextStatus = Case([Status],
    "", "Not Started",
    "Not Started","In-Progress",
    "In-Progress", "Issue",
    "Issue","Completed",
    "Completed","Canceled",
    "Canceled","Not Started");

    var text red = URLRoot() & "db/" & Dbid() & URLEncode("?act=API_EditRecord&rid=" & [Task ID]
    & "&_fid_12=" & $NextStatus);

    var text Words = "<img src=https://images.quickbase.com/si/32/814-keyed_collection.png>"">https://images.quickbase.com/si/32/814-keyed_collection.png>"">https://images.quickbase.com/si/32/814-keyed_collection.png>";

    var text URL = "javascript:" &
    "$.get('" & 
    $red & 
    "',function(){" &
    "location.reload(true);" &
    "});";

    "<a href=" & $URL & ">" & $Words & "</a>"


  • 11.  RE: Kanban Card Limits per Column

    Posted 08-18-2018 00:05
    Yes I found that image had to be pretty big because if you click a bit off center it opens the record. I think my image was one size too small.


  • 12.  RE: Kanban Card Limits per Column

    Posted 08-21-2018 14:57
    I was successful in adding the three color options to my cards but all I get is a staggered view of red, yellow, green. What activates the change? How do I get the priority color to switch? Thanks.


  • 13.  RE: Kanban Card Limits per Column

    Posted 08-21-2018 16:53
    You would need to create a Formula Rich text field like what I posted and then use that color field to set the color for the bar on the card.

    var text NextStatus = Case([Status],
    "", "Not Started",
    "Not Started","In-Progress",
    "In-Progress", "Issue",
    "Issue","Completed",
    "Completed","Canceled",
    "Canceled","Not Started");

    var text red = URLRoot() & "db/" & Dbid() & URLEncode("?act=API_EditRecord&rid=" & [Task ID]
    & "&_fid_12=" & $NextStatus);

    var text Words = "<img src=https://images.quickbase.com/si/32/814-keyed_collection.png>";

    var text URL = "javascript:" &
    "$.get('" & 
    $red & 
    "',function(){" &
    "location.reload(true);" &
    "});";

    "<a href=" & $URL & ">" & $Words & "</a>"


    I suggest disabling the need for Application Tokens in Advanced properties.


  • 14.  RE: Kanban Card Limits per Column

    Posted 08-21-2018 17:20
    Thank you. I had created the field and brought it over to my card but this is what it produces. Do you mean the the bar to the left will hold the color? Or these buttons are maneuverable? Thank you.


  • 15.  RE: Kanban Card Limits per Column

    Posted 08-21-2018 18:34
    If you have made the formula similar to what I posed and use the option on the report builder to 

    Color-code cards using a formula

    then the bars on the cards will color and will change color when you click the icon.  The icon is probably a size too small.

    This size might be better  size "48"


    https://images.quickbase.com/si/48/814-keyed_collection.png>



  • 16.  RE: Kanban Card Limits per Column

    Posted 08-22-2018 20:53
    Awesome. Works great. thanks


  • 17.  RE: Kanban Card Limits per Column

    Posted 08-23-2018 14:24
    Another question please...I have a column of "In Progress" tasks and a column for "Completed" tasks. On each card is a Date Completed: field. Can I get that field to populate with the current date when I move from "In Progress" to "Complete"? Thanks!


  • 18.  RE: Kanban Card Limits per Column

    Posted 08-23-2018 14:39
    No problem.  When you drag a box around it is simultaneously updating the Quick Base record identically to if you were editing the record manually.

    So you can set up an Automation to edit other fields on the record when the record is edited. You may need to create a formula date field called perhaps [Today] with a formula value of

    Today()

    so that you can have the Automation update a date field with the value in the field [Today] when the record is edited and the status changes to completed.