Why are various fields "Locked" so that they can't be Removed?

Submitted by DragonGem on 2019/03/31 16:24
There are a number of Fields that can not be REMOVED from the List of Fields. I understand this for ITEM-specific fields and other System-related fields. But fields like "ThisWeek" and "AddressBook" don't fall into those categories. I know that a number of these fields are referenced in Equations and the default VB Code but other similar fields like "Duration" are not Locked. Is there specific criteria for Fields that can't be removed Databases?

TLI disappearing from grid

Submitted by Frenchwolfie on 2019/03/31 09:21
Hello, I think I encountered a problem with the disappearance on an item I created as TLI in a grid. I can still find it when I search for its text via the Omnibox and then hoist it : it appears hoisted in the proper grid, with all its siblings. When I dehoist (Ctrl + H), I can't see it anymore. Is there a way to get it back on the unfiltered grid ? TIA

Question About Hidden Columns

Submitted by David_H on 2019/03/31 02:34
 One of the things I've always struggled with, with IQ, is the amount of columns I like to have visible vs them taking up too much space. Stacking columns can help, but only so much. Making them narrow is no good, because then you have to manually change the sizes whenever you want to see the column data.
 
Hidden columns seems like it would be the perfect solution, however it seems that if I hide several columns, the moment I unhide them the setting is erased. Now if I want to make them disappear I have to click on each and hide them again. Is there a way to create a set of hidden columns and turn them on and off as needed, without having to redo them all every time you unhide them?
 
Open to any suggestions how to achieve this now? I also looked at column sets but that won't work either.
 
Thanks

Shortcut Lockup

Submitted by WayneK on 2019/03/30 17:20
Trying to customize keyboard shortcuts, I'm getting a lockup every time:
 
1) Tools>Keyboard Shortcuts>Customize
2) Keyboard>Category "edit">Command "Copy as Hyperlink"
2a) "Press new shortcut key" = Alt-C
2b) Click ""Assign"
 
3) Message: "This shortcut is currently assigned.  Do you want to re-assign this shortcut?"
4) Click "yes"
5) Then find there's a second, identical message box behind the customize screen ("The shortcut is currently assigned...")
6) Program is locked up at that point and can only be closed by killing the process.
 
Reproduced multiple times.  Updated to 112n, but same lockup
 
Wayne
112n

Quick way to add the currently selected item to another grid (without using the mouse)

Submitted by LeftEccoForIQ on 2019/03/27 05:04
Just wanted to ask if there is a quick way to add the current item in grid view to a certain other grid (without using the mouse / using the same sequence of keys to be sent each time)? I tried going through the properties pane but couldn't figure out a reliable way to get to the target grid name in the "All Fields" section each time. I want to use this method in an Autohotkey script so the key codes needed to accomplish this would have to be repeatable regardless of the current status of / focus position in the properties pane.
 
I'm probably being daft and there is a much easier way...
 
Any help would be much appreciated!
 
Thanks
 
 

table joins

Submitted by jimspoon on 2019/03/26 02:49
I was just looking at the manual page "Sync with a fictitious SQL Server database" Sync with a fictitious SQL Server database and looked at the example -
it seems to involve syncing data from another DBMS, specifically the results of a SELECT statement with multiple table joins, to IQ fields.
Unless I am not understanding this correctly, that would seem to make it possible to use IQ to query external database data using table joins and generate results with many-to-one relationships, in a way that can't be done using the "internal" IQ capabilities.
The process is not particularly easy though. That makes me think, if IQ can do this, could not IQ accomplish similar results by creating a grid that joins multiple grids and filters the joined grid in any desired manner?
 
 
I hope I have phrased my question in an intelligible way.
 
 

Repeat calendar events not showing in Appointments tab

Submitted by MarkR on 2019/03/25 18:01
 I have created several annually repeating Calendar events. The initial events showed in the Appointments tab. However I can't make subsequent occurrences show in the Appointments tab - Their properties show the initial 2016 date and therefore do not appear if a more recent date filter is applied. What am I doing wrong?