Automatic Linking

Submitted by Paul_J_Miller on 2019/03/18 10:51
One of the joys of using ConnectedText is the simplicity of making links between pages.  One merely needs to put the [[name of the page]] within square brackets and it is a link.  However there is more to this than it seems because if at a later date you change the name of the page then the name within the links to that page also change.  There is also a feature called backlinks which means you can see which pages have links to the current page, this can either be used in a query or there is a menu entry which says 'what links here?'.  Backlinks are useful.
 
This is all possible because although CT appears to be a wiki it is infact a database pretending to be a wiki.
 
Among the other magic to do with linking is a feature called 'Automatic Linking' which searches your page and finds the names of other pages and converts them into links.  This can be done fully au

Google Calendar Coloring

Submitted by David_H on 2019/03/17 13:40
 It's common for Google calendar users to color their calendar items as well as assign different colors to difference calendars. Please implement it so these colors are mimiced on the IQ calendar when Calendar is finished. Hopefully colors can also sync as item colors change, as I change colors to indicate a calendar event has been completed.
 
I notice that right now some all my calendars carry over as one color, with the exception of the holidays calendar which correctly carries over with its color.
 
Thanks

Grids grid

Submitted by jimspoon on 2019/03/15 16:56
Would it be a good idea to have a Grids grid - a grid containing links to grids, that I can arrange hierarchically?
 
As far as I can tell, neither the Manage Grids list of grids nor the All Grids list in the Home Page allows for a hierarchical arrangement of the list of grids.
 
Such a Grid could be can manually but I'd have to manually add and place a link to a new grid every time I created one.  I can do that of course.  A Grids grid could have a TLI for new grids that have not yet been placed in a hierarchy of grids.
 

Calculate Running Total (Trying to Replace Quicken)?

Submitted by viking on 2019/03/12 16:30
I am thinking about trying to replace Quicken with IQ to keep track of transactions in a few Bank accounts. Has anyone attempted to do this?

I would have one Grid for each account and a Summary Grid showing the current balance in each account. The account Grids would have the transactions sorted by date and I need to automatically have IQ calculate a running total of the transactions and display in a balance column.

One of the issues is how to automatically create a running Total in each account. It is trivial in Excel, but in IQ there is no way to know the item ID of the previous item (i.e. the item with an earlier or same date). Has anyone created a Grid with an automatically calculated running total?

Another issue is how to capture the last transaction of each account to put that on the summary page (Grid). Anyone have any ideas?
 

Exporting appointments from IQ back into Ecco(Ext)

Submitted by LeftEccoForIQ on 2019/03/10 08:16
Hey. Since Ecco in connection with MyPhoneExplorer still provides a working sync solution to Android, and IQ isn't quite there yet, I was wondering if anyone has experimented with transferring calendar event / appointment data from IQ back into Ecco in order to sync with an Android device?
 
I tried some copy and paste with column info included but couldn't get the column values to be put where they belong in Ecco. They either ended up inside the item text or didn't show up anywhere at all. Nothing ended up being put into columns in Ecco at any rate.
 
Now I'm thinking CSV export from IQ and import into Ecco might be the way to go but wanted to see if anyone here has any experience before I experiment further.
 
Thanks!

A few thoughts on how things have developed

Submitted by Paul_J_Miller on 2019/03/07 06:09
As InfoQube becomes more suitable for the purposes for which I use it I find myself relying on it more and more.
 
This was not always the case, I tried InfoQube several times before I finally understood it.  Those first attempts were frustrating.
 
With the advent of a decent customisable editor (this was before the new 'Item Editor' dialog) which supports CSS sheets I find myself using it for the composition of documents and as such it has taken over from Scrivener.  Of course InfoQube does not have all the formatting and publishing facilities of Scrivener but it has enough to be useful and the tables are now better than in Scrivener.  Having the note taking and document editing in the same application is useful, the whole is greater than the sum of it's parts.  In my opinion reading, writing and taking notes https://takingnotenow.blo

Group by bar/by sort column issue

Submitted by Armando on 2019/03/06 19:44
Hi Pierre,
 
When grouping by sort columns/by bar, pressing the ctrl+# shortcut to collapse or expand hierarchies completely removes the currently focused group(s).
It used to work fine, and stopped at some point -- not sure when.
 
1- Group some grid content by sort columns
2- Press ctrl+shift+1 to collapse all groups -- that should work
3- Focus on some "group level"
4- Press ctrl+2 to see the second level (in that case all it should do is show what's in that specific "column group") : the group just disappears.
 
Tell me if that's clear enough.
 
Thanks!

Columns Not Displaying Correctly

Submitted by jnmwarren on 2019/03/06 17:14
I created a new IQ Base let's call it A. In A I created 2 new Fields of 1 and 2. Then I created 2 new grids of A' and B'. In grid A' I have 3 columns for the item, 1, and 2 fields all with data in them. In grid B' I have 3 columns as well. I am using two of the same columns of fields 1 and 2. I would expect that the data for fields 1 and 2 on grid A' would auto fill the same fields in B'. This is not the case. The fields of 1 and 2 in grid B' are blank. Does anyone know why or why not?