Skip to main content
Question

Formula Help

  • January 19, 2018
  • 0 replies
  • 66 views
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
    This topic has been closed for replies.

    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
    • Author
    • Registered
    • January 19, 2018
    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
    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]);
    Terms & ConditionsAccessibility statement