InfoQube IM - Community

Submitted by jan_rifkinson on 2012/06/03 14:23

When item is marked datedone I have the following equation

A:ItemForeColor=&H808080|

ME:ItemForeColor=&H000000|

I assumed with the above the following would happen:

A: if datedone is 1 (yes) then ItemForeColor=&H808080 (gray)

ME: if datedone is 0 or changed then ItemForeColor=&H000000 (black)

but it's not happening.

Comments

Are those in the "equations"--> auto assignment rules section of the datedone field ?

They should work, but you don't need to have ME: . That could be the problem

"E:" is enough, as datedone is a Boolean field.

"M:" would probably trigger its corresponding action whether you add a True or a False value.

I haven't tried, but that's what I'd expect.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

Thanks Armando, I'll try that.

Here's the situation which I probably should have explained earlier.

Yes, the equations are in the auto assignment rules section.

I am using it in conjunction with your recurring date equation in the following way

Normally, when I mark an item w a done date, the forecolor turns gray

So now I add your equation & I was hoping that when your equation reset the due date, it would re-set the forecolor to black but that doesn't happen.

forecolor remains gray.

Something along those lines should work, but I don't have all the details here.

Can you tell me each field's type ? I don't remember having a datedone field.

--------------------------------------------------------------------------------

Windows XP Home Edition, Service pack 3

Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz

datedone is actually from your equation when bill is paid

does that clarify?

I thought E is erase (see Field Management Dialog - Equations).

And I assumed that 0 wouldn't trigger E since its not being erased (I could be wrong on this). So you need to actually test the value. I would do that maybe using a row equation something like this in ItemColor:

IIF(DoneDate= 1, &H808080,&H000000)

I guess you could do it in the Auto Assignment Rule also doing this:

AM: IIF(DoneDate= 1, &H808080,&H000000)

A different approach that I use for what you are trying do is Conditional Formatting (Item Formatting). I don't think you can do it at the entire item/row level, but I do it now for the Item field/column with something like this in Item's Conditional Formats:

-1:DoneDate=1:ForeColor=&H808080
 -1:DoneDate=0:ForeColor=&H000000

I actually have a much longer list of Item conditional formats that looks at things like priority and Check. For example:

-1:SPri>0:Bold=1|Italic=1
-1:PriInt>0:ForeColor=DarkRed
-1:PriInt>1:ForeColor=OrangeRed
-1:PriInt>2:ForeColor=DarkGreen
-1:PriInt>3:ForeColor=DarkBlue
-1:PriInt>4:ForeColor=RoyalBlue
-1:PriInt>5:ForeColor=SteelBlue
-1:NotesG<>0:ForeColor=Gray
-1:CLHave=0:Italic=1
-1:IsGroup<>0:ForeColor=Black|Bold=1
0:WorkIsSprint<>0:ForeColor=MidnightBlue|Bold=1
-1:Check<>0:StrikeOut=1|ForeColor=Gray
-1:Key<>0:ForeColor=DarkRed
-1:WorkIsStory<>0:Italic=1|Bold=1
-1:TaskCurrent<>0:BackColor=Yellow

Thanks a lot for your reply. This has exciting possibilities which I'm going to try out. I like automated actions but afraid to overload 'item' equations.

I know I'll have questions......