When I did the work to add coloring I thought it was probably a waste of time. Never thought I would say this, but this coloring stuff is kind of fun. While testing it, my wife asked if the color of our custom rating column could depend on who had read the book (two custom boolean columns), green if both of us read it, blue if only me, fuchsia (a dark pink) if only her, and black if neither (??). It actually helps, even with my part color blindness.
Did it by coloring the rating column using the following template:
Code:
program:
r1 = field('#mybool');
r2 = field('#mybool2');
first_non_empty(
test(and(r1, r2), 'green', ''),
test(r1, 'blue', ''),
test(r2, 'fuchsia', ''),
'black')
(NB: I added the 'and' function (and 'or' and 'not') to the template language to simplify the first expression. These boolean functions will be in the next release.)