InfoQube IM - Community

Submitted by jan_rifkinson on 2009/03/11 08:33

Situation:

Item w pending (boolean) & datedone (date) columns

equation for pending changes background color

boolean = yes, color background

boolean = no, remove color background

equation for datedone changes foreground (font) color

date added= font color changes

date removed = new font color removed, ie. revert to default

However, these are not combined, i.e.

When I right click check mark or <CTRL>+M, I'd like pending background removed + pending check mark to go away + font color change to take effect

I'm assuming I have to combine A or B or C commands in DateDue but don't know syntax

How do I do this?

Thanks.

Jan Rifkinson

Ridgefield CT USA

Comments

You could add the following to the IQBase Done field (may be your donedate field)

A: Pending=0

You can have as many auto-assign rules as you wish, simply separate each one with a |

OK, I think I understand the concept but still don't know the syntax.

Right now DateDone equation looks like this: A:ItemForeColor=&H808080|E:ItemForeColor=

So I guess there are two commands A: & E: right?

Why A & E?

Why not A & B?

Do the auto-assign rules take effect by the order?

You see... you have to spoon feed me here

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Try:

A:ItemForeColor=&H808080|E:ItemForeColor=|A: Pending=0

This will change the forecolor and uncheck Pending (which, in turn, will change the backcolor)

OK, that worked as expected. Thank you. Can you direct me to some documentation to read about these kind of commands, i.e. A: B:, etc.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Great!