Display colored box on form
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 i...
Forum Discussion
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
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