Expand all | Collapse all

Display colored box on form

  • 1.  Display colored box on form

    Posted 09-27-2018 23:30
    I have a table of available color pairs that are assigned to each driver.  The first color is the one to use on a calendar for items to be done.  The second color is the one to use on a calendar for items that have been completed.  

    I tried to use named "HTML" colors that I got from an internet site but they would not work.  These colors had names like "Frog Green"...  To apply the colors, I had to use the RGB nomenclature (#969696 for gray).  The problem is that when a user is selecting these colors, the RGB nomenclature means nothing to them.  I would like to put a box beside each color text that has a background filled with the color selected.  Whether or not it has text is of no concern, so if it is easier to do with text, that is fine.

    I am hoping someone has a URL or Rich Text formula that will paint these boxes.  

    An alternative is if i can find a list of color names that could be used and are supported by QuickBase and most browsers, that are reasonably descriptive. 

    I need at least 5 color pairs.  The way we have designed the solution, we use a darker color for the To Be Done items and a lighter color (same tint family) for the completed items. A sample is #E9494F/#FA4A47.

    Your help is appreciated.

  • 2.  RE: Display colored box on form

    Posted 09-28-2018 00:36
    Lots of ways around this one...
    I know there are SOME named colors that QB natively supports. "Frog Green" won't fly but "blue", "orange" etc do. Some trial & error might get you where you need to go - or there must be a list in the documentation somewhere, but I didn't find it in 5 minutes of looking.

    You could create a reference table of color names and RGB hex values, and just present your user with the paired names to choose from (so, for your example... 'salmon' or... whatever that is... those two colors look very similar to me). Then using that user input name selection, lookup the associated RGB hex values from the color-pairs table down to wherever you're doing your reporting. That's probably the easiest way to do it without getting into some of the more fun stuff out there.

    Or, if you're into fun stuff, Sam Jones has given a GREAT presentation at a couple of EMPOWERs that I highly recommend, that I'm fairly certain would address all your questions here (and way beyond). I found a recording of it here... https://www.youtube.com/watch?v=wex-AUFNCOs

  • 3.  RE: Display colored box on form

    Posted 09-28-2018 01:29
    Thanks for the quick reply. I can certainly accomplish the first one and I will watch the video.