Hyperlinks + Properties Pane Problems

Submitted by WayneK on 2017/08/06 13:39
Return of a previous issue:
 
1) Clicking on item hyperlink opens it in scratch grid instead of its home grid
 
2) Side-problem #1: tried to check on homegrid assignment in properties pane but field ItemHomeGrid is missing.
(IDItem field is also missing).
 
3) Instead, I added ItemHomeGrid to forms.  As expected, the field was blank so I entered the correct grid.
 
4) Tried hyperlink again.  Still opens in scratch grid instead of home grid.  Created hyperlink a second time but got same result.
 
Side-problem #2: is there a way to search the properties pane?  I frequently have trouble finding fields, especially system fields.
 
Side-problem #3:  My forms list is still repeatedly closing when it shouldn't. 
 
Side-problem #4: In properties pane, if I try to switch betwee

Changing Field Names Should Not Break Associations

Submitted by David_H on 2017/08/02 00:13
If a grid uses the field "finances" as the source, and the user changes the field name to "financial", the grid should maintain the source.  I often fiddle with grid names and field names as I'm adding more and more grids/fields to IQ, and it's always time consuming to have to reset grid sources when all I wanted to do was rename a field.
 
Thanks

auto complete typing a pop-up list field, which "SELECT" from another grid via SQL

Submitted by seanlu21 on 2017/08/01 05:32
In one of my grid, I have a text Field, using SQL  "SELECT" from another grid.
I successfully achieved it.
 
When I add an new item, move the cursor to that Field, I found out that I need to double click the field, then I can see a drop-down list arrow on the right side of the field, then you click it to choose the field value you need; and you can not just type and IQ will automatically match the value to automatically select it for you like some other MS software do.
 
Here is my question, how can I achieve to do this : 
 
- move cursor to that Field by typing 'Tab', or just using cursor arrow to move.
- then just type the letter of the field value you expect to "SELECT" from other grid by SQL.
- then IQ will show any matching value from the other grid's item been "SELECT"ed.
 
B.regards
Sean 

How do I add a symbol at the beginning of every item using a rule?

Submitted by viking on 2017/07/29 20:58
In Ecco there is Auto-assignment and scripting (e.g. Lua).
In IQ there is rules/equations (and VBscript).
 
How do I write a rule that adds a letter (symbol) at the beginning of every newly created item?
 
For example, if I add a new item "Call mom", I want IQ to change the item text to "X Call mom".
 
In particular, I want X = Wingdings Char Code 108 (ASCII) (This would put a large bullet in front of every item like in Ecco)
 
 

Font Issues

Submitted by viking on 2017/07/28 21:46
1. I select item text and press the “Grow Font” or Shrink Font” buttons, but nothing happens?
2. If I click the “Font” button I can change the font size. However, after I do this, I can no longer navigate the text (e.g. use left/right arrows). I need to close/reopen the file.

Both issues happen on a brand new default file and my own layout (Test1.Dock.dat). However, issue #2 does not happen on the default layout (Default.Dock.dat). 
 

Grid items count

Submitted by WayneK on 2017/07/27 11:21
This has been discussed a few times but I'm still having trouble understanding how InfoQube counts items when it loads a grid.  My understanding was that InfoQube counts only items that will be displayed.  It does not count collapsed subitems.  However, I keep getting warnings about number of items when it seems like I shouldn't.  Example follows.
 
1) I turn off hoist.
2) I receive warning about trying to load a grid with 1,056 items.  I choose "load all items" option.
3) Grid loads and there are only 100+ items displayed (not 1,000+).  In fact, the grid only contains 627 items when all levels are expanded.
 
So why am I getting the item number warning when only a handful of items will be displayed, and the grid contains well under 1,000 items if they were all displayed?
 
By the way, I'm getting the item counts from tooltips (hovering mouse over