InfoQube IM - Community

Submitted by Armando on 2010/05/12 00:47

e.g. : Numberfield = -2 BackColor=&h283AFF

This won't work.

But Numberfield < 0 will work.

Can anybody confirm ?

P.S. I also have a question for Pierre : would it be feasible to use conditional formats with strings (e.g. TextField = "SomeString") ? Or at least maybe be able to use a <> 0 or = 0 to signify "isnull()" or "not isnull()" ? This would make the conditional format much more useful and similar to Outlook "automatic formatting".

Comments

[quote=Armando]P.S. I also have a question for Pierre : would it be feasible to use conditional formats with strings (e.g. TextField = "SomeString") ? Or at least maybe be able to use a <> 0 or = 0 to signify "isnull()" or "not isnull()" ? This would make the conditional format much more useful and similar to Outlook "automatic formatting".[/quote]

Reading Item Formatting, I get the feeling the criteria of conditional formats only works on Yes/No fields at the moment?

It would be great if they supported the same syntax as the other filters did.

Unfortunately I cannot confirm your bug, because I can't get conditional formats to work at all at the moment

[quote=Jibz]Reading Item Formatting, I get the feeling the criteria of conditional formats only works on Yes/No fields at the moment?

It would be great if they supported the same syntax as the other filters did.[/quote]

Silly me, I was using the offline IQ version of the manual which is a bit outdated it seems. The current online version does say integers can be used.

[quote=Jibz]Unfortunately I cannot confirm your bug, because I can't get conditional formats to work at all at the moment

[/quote]

And it also states that all fields used in the conditional have to be visible in the current grid for it to work .. I can confirm that the negative criteria you reported does indeed not work here.

I think it's safe to say this feature needs to be smoothed out a lot to be useful. At the moment there are too many silly constraints and voodoo magic you have to apply in the right order or it just silently doesn't work.

It has great potential though, so I hope it will get some work. I would love to, say, color my Appointments list based on how long there is until they come up (today red, this week yellow, this month green or similar).

Also, it would be nice if it were possible to make formats that were local to a grid as well as global.

[quote=Jibz]

[quote=Jibz]Reading Item Formatting, I get the feeling the criteria of conditional formats only works on Yes/No fields at the moment?

It would be great if they supported the same syntax as the other filters did.[/quote]

Silly me, I was using the offline IQ version of the manual which is a bit outdated it seems. The current online version does say integers can be used.

[quote=Jibz]Unfortunately I cannot confirm your bug, because I can't get conditional formats to work at all at the moment

[/quote]

And it also states that all fields used in the conditional have to be visible in the current grid for it to work .. I can confirm that the negative criteria you reported does indeed not work here.

Also, it would be nice if it were possible to make formats that were local to a grid as well as global.

[/quote]

Thanks Jibz,

Yes I wrote some of the parts in the conditional format section of the manual -- the warnings especially.

So the bug is confirmed thanks. I'll enter it in Mantis later.

As for the other requests : conditional formats based on dates, strings, etc. yes, it would be good. It was mentioned a few times 2 y ago but was never entered in Mantis. It should.

Added a Mantis issue for that feature (didn't find it anywhere even if it was previously mentioned) :

0994

conditional formats based on dates, strings, etc.

New feature

feature

It is a grid issue. I'll forward it to the supplier

OK!

[quote=Pierre_Admin]

It is a grid issue. I'll forward it to the supplier

[/quote]

Can you tell us who the supplier is so we can dig into their docs for others hint? For example, I'm interested to see if there is some way to do compound statements like:

-1:IsGroup=0 AND PriInt=5:Bold=1

Thanks,

[quote=reesd]

Can you tell us who the supplier is so we can dig into their docs for others hint? For example, I'm interested to see if there is some way to do compound statements like:

[/quote]

Take a look at -- link to nonexistent node ID 1752 --.

[quote=KeithB]

[quote=reesd]

Can you tell us who the supplier is so we can dig into their docs for others hint? For example, I'm interested to see if there is some way to do compound statements like:

[/quote]

Take a look at -- link to nonexistent node ID 1752 --.

[/quote]

Thanks! Just stumbled across that and was coming back here to link it :). I think I never saw it because it doesn't seem to be linked to from anywhere (that I looked at least). I moved it under the FAQ, hop that's ok.

[quote=reesd]

[quote=Pierre_Admin]

It is a grid issue. I'll forward it to the supplier

[/quote]

Can you tell us who the supplier is so we can dig into their docs for others hint? For example, I'm interested to see if there is some way to do compound statements like:

-1:IsGroup=0 AND PriInt=5:Bold=1

[/quote]

Ok, with a little help from -- link to nonexistent node ID 1752 -- (thanks Keith!), I found this detailed help on conditional formatting. Lot's of stuff to play with, anything we shouldn't expect to work Pierre?

http://www.exontrol.com/content/products/exg2antt/help/ConditionalFormat_Expression.htm

Thanks reesd... won't have the time to play with it till Sunday though.

but... it doesn't look like it could work in the conditional formatting area of the field management dialog. All examples are in "real languages" (from VB to C#). Were you thinking of using them in the vb script editor ? some stuff might work.

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

Windows XP Home Edition, Service pack 2

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

Even if issue was forwarded to the supplier, I entered in Mantis for the record :

0993

Conditional Format : won't work if negative values are used.

Bug

minor