I'm attempting to create a series of colorized progress trackers, based on a number of requirements. To do so, I'm trying to colorize a field based on a number of checkboxes. Example:I have different types of contacts that I need my sales folks to ensure we have in place prior to moving a deal forward. What I would like is for the status bar on the main page to change color based on having none of the boxes checked (Red), any one of the boxes checked (Orange), and two boxes checked (Yellow) and all boxes checked (Green).Thoughts?Mike

There are 502 icons here available for public use in 5 convenient sizes.https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=134https://login.quickbase.com/db/bcgnn27bx?a=q&qid=1000039var number NumCompleted = Count( [checkbox 1], [checkbox 2],[checkbox 3]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>",1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>",2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>",3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")

Ok, So I probably should've started with, I kinda suck at formulas. I've put what you showed above into my field, changed the "[checkbox 1] to the actual name of the field, and I'm getting the following error. Sorry to be a hassle.Mike*NOTE*I'm going to need to replicate this across a couple of different tables that are not only related to contacts.--------------------------------------------------------------------------------------------------------------------------------------var number NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")Error message:Formula Error--Undeclared IdentifierThe variable Count is not declared

No problem, there was a clear error in my formulaChange that first part to thisvar number Count NumCompleted = Count( [checkbox 1], [checkbox 2],[checkbox 3]);

I apologize for being a pain (and for not understanding formulas better at this point), but I'm still getting an error message. Immediately below is the error message. Below that, is exactly what I have placed in the formula box.Thanks again for all the help.MikeError Message_______________________________A variable declaration must have an assignment operator.var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")In my Formula Box________________________________var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")

Try thisvar number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>", 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>", 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>", 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")

Formula Help | Qrew Discussions

QuickBaseCoachD
Qrew Captain
8 years ago
There are 502 icons here available for public use in 5 convenient sizes.

https://login.quickbase.com/db/9kaw8phg?a=ShowPage&pageid=134

https://login.quickbase.com/db/bcgnn27bx?a=q&qid=1000039

var number NumCompleted =
Count( [checkbox 1], [checkbox 2],[checkbox 3]);

Case($Count,
0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>",
1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>",
2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>",
3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")
MikeMike1
Qrew Cadet
8 years ago
Ok, So I probably should've started with, I kinda suck at formulas. I've put what you showed above into my field, changed the "[checkbox 1] to the actual name of the field, and I'm getting the following error.
Sorry to be a hassle.

Mike

*NOTE*
I'm going to need to replicate this across a couple of different tables that are not only related to contacts.

--------------------------------------------------------------------------------------------------------------------------------------

var number NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")

Error message:

Formula Error--Undeclared Identifier
The variable Count is not declared
QuickBaseCoachD
Qrew Captain
8 years ago
No problem, there was a clear error in my formula
Change that first part to this

var number Count NumCompleted =
Count( [checkbox 1], [checkbox 2],[checkbox 3]);
- MikeMike1
  Qrew Cadet
  8 years ago
  I apologize for being a pain (and for not understanding formulas better at this point), but I'm still getting an error message.
  
  Immediately below is the error message. Below that, is exactly what I have placed in the formula box.
  
  Thanks again for all the help.
  
  Mike
  
  Error Message
  _______________________________
  
  A variable declaration must have an assignment operator.
  
  var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")
  
  In my Formula Box
  ________________________________
  
  var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);Case($Count,0, "<img src=https://images.quickbase.com/si/32/221-point_red.png>";, 1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>";, 2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>";, 3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")
- QuickBaseCoachD
  Qrew Captain
  8 years ago
  Try this
  
  var number Count NumCompleted = Count([Buyer], [Decision Maker],[Influencer]);
  
  Case($Count,0,
  "<img src=https://images.quickbase.com/si/32/221-point_red.png>",
  1, "<img src=https://images.quickbase.com/si/32/223-point_yellow.png>",
  2, "<img src=https://images.quickbase.com/si/16/224-point_blue.png>",
  3, "<img src=https://images.quickbase.com/si/32/222-point_green.png>")
- MikeMike1
  Qrew Cadet
  8 years ago
  Same error message.

Forum Discussion

Formula Help

Related Content

Formula Assistance

Formula Url Buttons

Formula Query with custom key

Formula Date Field

Date Field Formula