Kanban Card Limits per Column

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