Quote:
Originally Posted by travger
[...]
1. What type column works best?
2. What should the entries look like? (Win Hugo 1975, Nom Nebula 1975, Decade's Best #3 1981?)
|
As you want to have more than one item per book, the only column type that makes sense is text, tags like.
As for what to put there, that is up to you. The rule must be that the 'category' of an item must be distinguishable. An idiot robot (a computer program) must be able to tell what an item is from the text in it, without knowing what the words mean. Having entries begin with key phrases like "Win" and "Nom" would do that. You might want to ensure that Hugo/Nebula items begin with "Win Hugo" and "Win Nebula" so they can be easily distinguished.
As for coloring, pay attention to theducks answer. There is some ambiguity in your coloring rules. For example, H/N Nom produces goldenrod, while other win produces sandybrown. What happens if a book has both an other win and an H/N nom?
Once you have the priority worked out, enter the rules. The easiest from the rule standpoint is to use regular expressions as theducks suggests to check if an item begins with something, such as "#XX has pattern ^Win Hugo". Each rule will have the same number of conditions as you expressed above.