MobileRead Forums - View Single Post - Color coding and designing composite columns

ElMiko · 01-03-2015, 08:14 PM

I have three custom columns that are Yes/No columns (let's call them "#cola", "#colb", and "#colc"). I would like to create a fourth column that displays 8 values, ideally with each text value as its own color (as in a "Text, but with a fixed set of permitted values" column):
"ColA" (if only #cola's value is "Yes"),
"ColA, ColB" (if only #cola and #colb values are "Yes"),
"ColA, ColB, ColC" (if all three columns have "Yes" values),
"ColA, ColC" (if only #cola and #colc values are "Yes"),
"ColB, ColC" (if only #colb and #colc values are "Yes"),
"ColB" (if only #colb's value is "Yes"),
"ColC" (if only #colc's value is "Yes"), and finally
simply blank (if all values are either "No" or "Blank")

Anyone know how this would be possible, and what the syntax would be?

01-03-2015, 08:14 PM	#1
ElMiko Evangelist Posts: 473 Karma: 65460 Join Date: Jun 2011 Device: Kindle	Color coding and designing composite columns I have three custom columns that are Yes/No columns (let's call them "#cola", "#colb", and "#colc"). I would like to create a fourth column that displays 8 values, ideally with each text value as its own color (as in a "Text, but with a fixed set of permitted values" column): "ColA" (if only #cola's value is "Yes"), "ColA, ColB" (if only #cola and #colb values are "Yes"), "ColA, ColB, ColC" (if all three columns have "Yes" values), "ColA, ColC" (if only #cola and #colc values are "Yes"), "ColB, ColC" (if only #colb and #colc values are "Yes"), "ColB" (if only #colb's value is "Yes"), "ColC" (if only #colc's value is "Yes"), and finally simply blank (if all values are either "No" or "Blank") Anyone know how this would be possible, and what the syntax would be?