DYNAMIC COLORS

[christian77]

Hi:

I want to set colors dynamically according to my
product. Each product has its color.

Does anybody know how to do that?

Example attached.

[giakoum · Accepted solution]

see attached

[christian77]

Hi:

Thanks. Could we do it with only one field?

Anyway is good.

[giakoum]

I tried to do it with one field but it did not work out

[christian77]

Hi,

Product           SubProduct                  Red        Green   Blue

A                            A1                          0             0             255

A                            A2                          100         100         255

A                            A3                          200         200         255

In this case, when I see the thing by Product: what color to place? The Red and Green
fields are null(). RGB function interprets that as 0, so the color is 0,0,255, which
is exactly what I wanted.

Also, having the 3 fields null() or empty will result in 0,0,0; that means black.

Set your SubProducts in the same range of colors, like above, and it’ll show the generic one when seeing it by Product.