InfoQube IM - Community

Submitted by grahamrhind on 2010/01/13 13:57

I'm just playing at the moment, but I've come across some issues in 0.9.24H.

1) When importing, (File->Import->Import data), the first import works, the second always freezes IQ. After a restart it will work.

2) When importing, when the file being imported is locked by another user, instead of a warning message IQ freezes.

3) In the properties pane, Forms->Grid Form, double clicking should "Show items with values for this field". 0 is a value, as is False in a Boolean field, but in both cases these are excluded when that is chosen. It took me a while to work out where my data had "gone". I think this either needs correcting or the explanation improved.

4) Out of interest (because, and forgive the heresy, I see IQ as a Zoot/Ultra Recall mixture), is it already possible to format items conditionally (e.g. change the colour according to the contents of a field)? I see this in the Field Management dialogue but can't see if/how it works.

Cheers,

Graham

Comments

The short answer to your question #4 is 'yes'. You might want to take a look @ www.sqlnotes.net/drupal5/index.php

Also current build is beta v9.25 pre release 13 which I suggest you download from www.infoqube.biz/download

A lot of bugs were fixed & it has a working calendar to boot

HTH

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-2

re #4 - there's also the capability to alter the colour of the item itself depending on whether a field is filled or not

look at the Done field in 'Field Management' under equations - I beleive the default has the following under Equations

AM: ItemColor="blue"

which means if you tick this field, the item goes blue

I cant remember or find which page this is on in the manual (anyone?) - ahh look at "Auto-Assign Rules" on this page: Field Management Dialog - Equations

[quote=grahamrhind]

[/quote]

I had trouble with this lately - AFAIK if you filter a grid for a numeric field having a value, items with a value of '0' dont get displayed (I dont think this is changed by the option to make 'Null=0' )

I'll have to look up my notes though or try it out again...

well a quick check confirms that if the source is a numeric field, items with a value of '0' dont get displayed, whether the option 'Null=0' is selected or not

Is there any documentation on the correct syntax for adding formulas, formats, criteria and so on?

In the case of conditional formats (as discussed above, to try to trigger a change in colour), I have tried:

Source Code='I'

='I'

Source Code=I

='I00026'

=I00026

Source Code='I00026'

Source Code=I00026

with the Format as

BackColor=&H0000FF

BackColor=Red

BackColor='Red'

and nothing works. Is this a bug?

Thanks

AFAIK, the conditional formatting Item Formatting only works with field having content or not (or ticked or not). From that page:

"=0" means that the Yes/No field is "Null" --> "not ticked". Likewise: for other types of fields it means "Empty"
"<>0" means that the Yes/No field is "not Null" --> ticked. Likewise: for other types of fields it means "Not Empty"
As shown in step 2, if you want the formating to be conditioned by another field (here a value in the InfoQube field will affect the Notes field formating), you can add a specific field name before the "<>0" or "=0"
example:
in order to make a field change colour, lets say the "Date" field, based on whether the ItemHasHTML field is ticked (i.e. based on whether the HTML pane has content) you put the details in the Criteria column in the Date field thus (Field names are case sensitive):-

ItemHasHTML<>0
ItemHasHTML=0

and then add formatting - color, etc. as appropriate

and later:-

"Conditional formats criteria can use number or yes/no fields only. Formatting can be applied to any fields."

Then there's auto-assign rules which can change formatting when a field has content or not or is modified

Then there's user scripts which might be what you're looking for - also on the auto-assign rules page Field Management Dialog - Equations bottom of the page

EDIT: corrected last link

Ah, thanks Tom. I hadn't seen that restriction on field types.

[quote=grahamrhind]

Ah, thanks Tom. I hadn't seen that restriction on field types.

[/quote]

have you looked at the Auto-assign rules (I corrected the link bottom of my last post- but after you posted so maybe you missed it) & the user scripting - also mentioned at end of my last post

Auto-assign rules can be used with other field types - scroll down the page a bit on that link to find them

I think I'll need a brain transplant before I understand VB syntax - I'll add that to my todo list :-) Thanks Tom.

[quote=grahamrhind]

I think I'll need a brain transplant before I understand VB syntax - I'll add that to my todo list :-) Thanks Tom.

[/quote]

I wouldnt know VB syntax if it hit me in the face :-)

- but the auto-assign rules are easy enough (I always have to go back to that page to check how they work but I manage..)