"Progress" Bar for a Form

This  is a Progress bar icon from the downloadable app from the exchange called Magic Buttons.  I suggest that you download it to see what other useful formulas are there.


// Draw basic progress bar.  PctDone must evaluate from 0 to 10.
var Number pctdone = Round(If([Action Count]=0,0,([Action Count] - [Incomplete Action Count]) / [Action Count]) * 10);
var Text gry = "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"</img>";
var Text grn = "<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"</img>";

Case($pctdone,
  0, $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry,
  1, $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry,
  2, $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry,
  3, $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry,
  4, $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry,
  5, $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry,
  6, $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry,
  7, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry,
  8, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry,
  9, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry,
 10, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn)

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