Demystifying InfoQube

Submitted by Pierre_Admin on 2009/06/16 16:55
 
InfoQube is often seen as a complex program: 
Regarding InfoQube, I agree with Jan Rifkinson that it is a massively capable programme, the development of which I am keeping a close eye on. (...) However, I have found InfoQube to be a massively complex programme that requires more practice than I have had time to give to date
[/quote]
 
This always comes as a surprise to me as, IMHO, it is an incredibly simple program. The concept can be summarized as follows:
  1. An item is the basic unit of information

DateDue

Submitted by jan_rifkinson on 2009/06/16 10:18
Pierre,
 
Would you explain why in the new & improved (& almost perfect) import dialog
you have included only DateDue of all the dates?
 
For example, it could have been start date so it will eventually goes to calendar a well as grid
Sometimes I clip from a monthly list of events & would like to immediately assign each clipping to an ApptDate or StartDate
 
Why not have a drop down menu for any date related field & let users decide what date to use?
 
I'm sure you have a reason for doing it as you have it but I'd like to know what you had in mind so I might take better advantage of it.
 
Thanks.
 
--
Jan Rifkinson
Ridgefield CT USA

Ctrl-Enter when multiple cells selected should populate all cells

Submitted by markfoley on 2009/06/15 23:14
In Excel, if you select some cells, type a value and hit ctrl-enter, all cells are set to that value.
 
This would be very valueable in IQ also, if for example you want to set the category of 10 lines to be "current" or set the same due date for many items.
 
Logic would be:
If multiple cells are selected and all have the same data type, ctrl-enter commits the entered value from the active cell into all selected cells.
 
This can kind of be done via the properties window but isn't something you'd want to do too often if building project plans, changing duration of things etc.
 

Accessing parent's values for searching

Submitted by markfoley on 2009/06/15 23:02
I created a new thread for this Pierre.  You mentioned in the 'Access field values of other grid items' that you can access parents and subitems values.
 
Can you iterate up through to parent's parents, or provide guidance on how the below search could be approached?
 
I was going to write a search (unless I can do it using IQ as it is) that would allow me to search as follows:
 
An example tree:
 
Projects
|___Project Blah
...
|___Project Swan
   |___Issues
      |___Cash reconciliation
      |___Cheque reconciliation
         |___Spk: Shane re: new process
 
For the same reason context parents are useful, you would want to search where other parts of the item's lineage contain ot

database management dialogs

Submitted by jan_rifkinson on 2009/06/15 17:28
Pierre, I find the database management dialogs confusing.
For example, if I click repair, IQ immediately pops up a dialog that sez "OK". It can't work that fast...... can it?
Likewise for Compacting. I can't tell when either are working or are finished.
 
Perhaps you can take a look at these when you get a moment.
 
Thanks.
 
--
Jan Rifkinson
Ridgefield CT USA
 

Wow! lots going on here

Submitted by Pierre_Admin on 2009/06/15 15:34
The last few days have been very busy on this community web site, 7 straight days of greater than 2000 page loads / day!
 
And so many posts, that I have a backlog to look at... which I will, but only in a few days, as I have some important accounting to do (not fun, but when you're running a business...)
 
So, keep posting questions and answers, and I'll be back in a few days
 

Auto assignment - something changed

Submitted by jan_rifkinson on 2009/06/15 15:04
Goal: User wants item background to change if Boolean field is engaged
Equation = A:ItemColor=&HCAFFFF|E:ItemColor=
This equation used to work just fine, i.e. when a Boolean field was engaged, it turned the background color to a light yellow, if Boolean was unchecked, the color was removed
It just stopped working & I can't figure out why
What's changed?
 
Maybe someone else could try this to see if it's working elsewhere
 
--
Jan Rifkinson
Ridgefield CT USA
 
 
 

Hyperlink minor bugs/questions

Submitted by markfoley on 2009/06/15 04:18
 
 
- using 'insert hyperlink' to a grid inserts the link but nothing is visible because no value is given to the tag.  ie it inserts <a Spend></a> but should insert <a Spend>Spend</a> to give the user an editable/clickable link.
 
- Am finding the outlook link to item does not work when I drop the email on the box it says to drop it on.  I probably won't use it anyway but am just beta testing.  Anyone else find this?

Access field values of other grid items

Submitted by markfoley on 2009/06/15 02:22
I'm doing a little test of the VB editor, and see that the functions tend to refer to field values of the item currently active.  I do see some aggregation items like 'Sum' etc.
 
--> Is it possible to iterate through the items in a grid or indeed iterate through all items?  (eg foreach loop)
--> How to refer to items by ID?  For example, if I wanted to obtain an item's text and its parent's text I might want to do something like (pseudocode):
 
get thisitem(ID)
msgbox  (this item's text)
 
for each parent of this item get it's ID number
msgbox (parent's item text)
next parent
 
 
None of this is very core to a particular task I need to do presently- but these are common things I believe you'd need to do to manipulate your items beyond 'field to field' triggers.