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

eschwartz · 01-04-2015, 02:39 AM

Code:

program:

part1=contains(field('#cola'), 'Yes', 'colA', '');
part2=contains(field('#colb'), 'Yes', 'colB', '');
part3=contains(field('#colc'), 'Yes', 'colC', '');

final=list_union(
    '', 
    strcat(part1, ',', part2, ',', part3)
    ','
);

Will display the concatenated and comma-separated values.

I've never really played around with custom columns, but you can set 8 rules to match each state with a different color. I think you have to have a rule per color.

Edit: Right, like chaley said, templates are "hiding" at the bottom.

01-04-2015, 02:39 AM	#5
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	Code: program: part1=contains(field('#cola'), 'Yes', 'colA', ''); part2=contains(field('#colb'), 'Yes', 'colB', ''); part3=contains(field('#colc'), 'Yes', 'colC', ''); final=list_union( '', strcat(part1, ',', part2, ',', part3) ',' ); Will display the concatenated and comma-separated values. I've never really played around with custom columns, but you can set 8 rules to match each state with a different color. I think you have to have a rule per color. Edit: Right, like chaley said, templates are "hiding" at the bottom. Last edited by eschwartz; 01-04-2015 at 03:08 AM.