% Completed button
I am looking for a button that will chance the color on a status bar based on the the number in a separate field.In other words, if I'm at 40% I need 4 check boxes to turn green. I found the below b...
Forum Discussion
It sounds to me you are not looking for a button, but display a simple progress bar based on another numeric field. Here's a formula to create one via a html enabled formula text field:
// 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
)
// 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
)
- where did the action count fields come from?
- The original post didn't have any fields names. The sample formula given used fictitious names since it's an example formula. In a real app you could use numeric summary fields of the related details table. Use your own field names as needed.
- so how would it work for me if I don't use or have any similar fields as the sample fields?
