Translation map

Is there a way to use a variable within the translation map of a table? Right now, I am doing something like this for the translation:

Part 1

But I would like to be able to assign the color dynamically:

Part 1

I could add all of the entries to the translation map I suppose, but it would make it more flexible if I could use expressions or data set within the map. I would like to use red text for rejects, yellow for raw parts, blue for parts in process, green for completed parts, etc.

Well, there is a new color translation map feature in 3.2.4, but I don’t think it will satisfy exactly what you want. We need a more full featured column color mapper ala the row color mapper.

Your best bet for now is to use CASE WHEN statements in your SQL query to choose the colors dynamically.