Kanban Card Limits per Column

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Acknowledged
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.
Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
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. 
Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb
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.
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
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

(Edited)
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
Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb
Thank you! Extremely helpful. Just subscribed. Looking forward to more good stuff.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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>"
Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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>

Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb
Awesome. Works great. thanks
Photo of Jaime

Jaime

  • 182 Points 100 badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.