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.

Per below- when you go to validate your code it doesn't tell you what line the error is on.  It should tell you what section (system, user or database) and what line number.

 

It does return the correct error description however.

 

How to do the equivalent of a replace query.  Example situation:

 

a) I have a grid I created called 'projectsomiro' .  Now all the items in it (at top level) have the field 'projectsomiro' set to true. 

b) I now see I'll have 50 projects, and to make reporting/etc easier, I want just one 'text field' which would contain "somiro", "project x" or another project's name.  I don't want 50 true/false fields of course.

 

 

Then I would delete my true/false flags.

 

Based on my early usage I think this will be a common thing to do.

 

 

 

Per above.  Affects calendar, popup lists etc but options/manage grids etc centre correctly on the correct monitor.

 

See attached.

using an 'auto' popup list, it pops up when it shouldnt.

 

It pops up when you click the combo box which is fine, but it also pops up when you type a valid value.  eg if you had a field with valid values of 'one' and 'two', typing 'one' should just accept the input rather than then prompting with the popup.

 

Hope my description makes sense!

a) When you do a pivotable like below with SUMS of fields, you would expect it to show only totals rather than line level detail of each amount.  If I had pulled the descs in it would be different as it would 'group by' those also.  You can click the little minus sign for each one but that would take a long time on larger pivotables.

 

 

b) Also if you close IQ with a pivot open the pivot does not auto-reopen like a grid would, is this intentional?  It does retain settings though which is great news.

 

cheers

The title from the last copied item using  the universal clipper is appended to item (in add item window/dialog) created with the "Copy Content" Firefox clipper.

Reading parts of the documentation, I noticed that the word properties and even folder (4. Searching and Filtering Items) is used from time to time to speak about fields. This is very confusing.

 

I even wonder if the "Properties" pane shouldn't be renamed to "fields". I understand some of the semantic advantages of using the word properties, but I'm not sure if it serves any true didactic, pedagogical or practical purpose.

 

There are a few other cases. But let's start with this one...

In main menu

Menu | View | Grids

 

Customize Menu

Customize | Keyboard | Category = View (Grids does not exist) so I couldn't attach shortcut to it.

 

What am I missing?

 

--

Jan Rifkinson

Ridgefield CT USA