Can you use decimal or RGB format for colors in formulas? | Discussions

Expand all | Collapse all

Can you use decimal or RGB format for colors in formulas?

  • 1.  Can you use decimal or RGB format for colors in formulas?

    Top
    Contributor
    Posted 08-17-2017 18:06
    I'm trying to use a Formula-Text field to color another text field. Can you use decimal or RGB format in a formula?(ex. rgb(178, 218, 155))
    I'm currently using the following formula:
    "<font color=red>" & [Crew - Foreman]
    I know you can use the name of the color or a hex format, but I wanted to know if it could be done with an RGB format and, if so, how? I have already tried replacing "red" in the formula with different variations of "rgb(178, 218, 155)" and nothing works. I can't seem to find anyone who demonstrates a way to do this.
    Thanks in advance!


  • 2.  RE: Can you use decimal or RGB format for colors in formulas?

    Bronze
    Contributor
    Posted 08-17-2017 18:10
    try this
    "<font style=\"color:rgb(178,218,155)\">" & [Crew - Foreman] & "</font>


  • 3.  RE: Can you use decimal or RGB format for colors in formulas?

    Top
    Contributor
    Posted 08-17-2017 18:19
    Try this:
    "<span style='color:rgb(178, 218, 155)'>" & [field] & "</span>"
    This tag <font> is obsolete. Although it may still work in some browsers, its use is discouraged since it could be removed at any time. Try to avoid using it.

    It is another case where QuickBase's supported HTML tags is from the stone age.

    http://help.quickbase.com/user-assistance/what_tags_can_i_use_in_quickbase_.html


  • 4.  RE: Can you use decimal or RGB format for colors in formulas?

    Top
    Contributor
    Posted 08-17-2017 21:35
    The "span" formula doesn't seem to be working for me, I'm not sure why. I tried messing with it but couldn't get it to work. The "font" formula did work though! 
    Thank you very much!