InfoQube IM - Community

Submitted by jan_rifkinson on 2012/04/02 11:59

Purpose

When item is marked done

IQ inserts done date, removes datedue

and

changes text color from black to grey

A:DateDue=

A:ItemForeColor=0X00CCCCCC|

The date stuff works great

The grey color isn't happening

????

04/03/12 10:47: Any news on this front?

Comments

I find colour confusing in IQ, especially as I change it so seldom.

I notice the colour you give doesnt work either for ItemColor

Could it be the hexcode or whatever it's called - I have had a lot of trouble with that in the past. IQ will only accept certain "formats" of colour. Have you checked the manual for what's "acceptable"?

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

Win 7 Pro 64bit ~ Portable IQ 0.9.25.W9

Color hex is supposed to start with &. See http://www.sqlnotes.net/drupal5/index.php?q=node/219.

I also recommend using named colors, for instructions on adding a good list of them see http://www.sqlnotes.net/drupal5/index.php?q=node/2360.

re start with &H:

True, but IQ should support the 0x format as much as possible. I'll see why this doesn't work...

I've tried w & w/o &H

I've tried in conditional formatting

and in

equations in DoneDate field

Nothing seems to happen here.

What am I missing?

Thanks for the color references & the HELP pages for changing colors. Excellent compilation.

Starting v0.9.25W10, 2 new color formats are supported in equations:

C-style hex: 0x00BBGGRR
HTML-style hex: #RRGGBB

Of course, the original VB format is still supported (&HBBGGRR) !

HTH !

A latest build is available in the download area which fixes this issue

[quote=Pierre_Admin]

A latest build is available in the download area which fixes this issue

[/quote]

Pierre when I download that I get SQLNotes.exe file from 2009

I was wondering could it be my cache but -from 2009- I dont think so... :-)

So true..

Try it now !

[quote=Tom]...I get SQLNotes.exe file from 2009[/quote]

that would have been a blast from the past :-)

Sorry to report not really unless I am missing something (entirely possible in MY case)

Wondering if something is cooking with "ItemForeColor" ??

Also tried with conditional format w same success (not)

And I wonder the following while I'm at it::

I have boolean fields that when checked create a column color by using conditional format

I want to be able to turn those off when I add a DateDone.

Jan, the colour bit works here fine (edit/ under "Equations") -

could it be it's not working cause there's no seperator "|" between the two equations?

> could it be it's not working cause there's no seperator "|" between the two equations?

Yes, that is definitely it. I'll update the parser to also support a carriage return as separator

@Tom - YES, that's IT !! Thank you, Tom

@Pierre, tks for adding carriage return to simplify the # of things we all have to remember to do to work in IQ

Hi Pierre,

Does that mean that all CRLF (which will now be parsed as a "|" delimiter for Auto-Assign rule) will generate errors in my rules since I use "|" to separate statements, but also CRLF to make it more readable ?

Thanks.

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

Windows XP Home Edition, Service pack 3

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

No, one or the other will do