That's what I thought, but I had that before posting & I couldn't get it to work here
I'm working with a hoisted Item
I noticed if ItemParent is hoisted, ie. when hoisting on, Grid options don't take & filter is no longer dynamic, i.e. user can't change it while hoist is engaged
Also when I tried to column filter, it also seemed to "interfere" with hoist
For example I thought if column filter to was set to non-blanks in boolean column, only checked items would be selected, i.e. filtered
I couldn't get that to happen either
Just playing around trying to set up construction project planning
Edited 2010/08/29 17:31
Pierre, I also experimented w two colors which I couldn't get to work as I would have expected,
Field A = blue
Field B = green
color assigned via field properties
both fields are boolean
In grid properties > options I changed line color to field color > Field A, Field B
close tab / open tab results in both fields colored in single color
re Hoist and filters: Hoist is already a filter, so you can't filter on a hoisted list. Select some items and re-hoist if you want
re Hoist and column filter: Column filters are not affected by hoist
32: Colors. I don't understand what you want to do with your boolean fields. ItemColor field contains the color of the item. You can select which columns show this color. Enter the list of columns where you want the color to appear. An item cannot have more than one color.
n.b. In tools>>Options, you can choose the file used for the item color (default is ItemColor). Change this and you can have an entirely different set of colors.
Itemcolor is field in which is stored the color info for the whole item. Not the color for a specific field. If you want to achieve the coloring of specific fields, you need to use the conditional formatting section.
There's another potential issue with using the itemcolor field in auto-assign rules : if you use the urgency calculations in any ways, urgency might reset your colour. But I haven't double check the system's VB code as it is now.... It used to be that way.
I haven't consciously used any urgency calculations yet so that's probably not it but I understand what you're saying.
You say I field = itemcolor sets color for the entire item vs a field & I understand that conceptually.
But here's what I don't understand & maybe you can explain this to me. If I use a single color the following changes the item color to a field color so long as I use one color. but if I use two separate itemcolor commands for two different fields in the following manner it fails,. So I am confused about the use of the following command. Can you plse tell me what it does.
Manage Grids > Options > Item color applies to fields
Thanks.
BTW, I also don't understand what an "available field" means
and I don't understand the command "hide in info pane"
with the option in question (in your original post) you can set which fields of an item are going to be colored, but they are all going to be the same colour - multiple colours are *not* supported in this manner.
The only way to have different colored fields within the one item is via conditional formatting (that's the theory anyways - I've never used conditional formatting myself so cant say much about it)
I think the confusion revolves around the itemcolor field -- I think I explained that in my previous post too, but maybe was it poorly explained.
1- Whatever value you give to the itemcolor field for a given item (whether you use another field autoassign rule to assign that color or not) will result in full item row coloring. Basically : itemcolor field = colors the whole row. And you can't have 2 different colours appearing simultaneously.
2- IF you want/need to color different fields with different colors, you automatically need to use the conditional format section of the fields properties dialog. Basically : conditional formatting allows you to have different colours (amongst othe for different cells in the same row.
I don't have the time to expand on that right now (I'm getting ready for a show on Saturday) but if you do understand now, tell us. And tell us how you think it could be made clearer.
Comments