items order

Submitted by Pavel on 2019/03/21 06:02
Hi there,
It seems to me that between sessions the order in which items (TLIs) are listed changes slightly, i.e. without me interfering I seem to find some before others that I'm fairly sure I wrote earlier. Or am I imagining things? What is the default behaviour as to listing order of items?
 
Thanks
Pavel

Copy, Paste

Submitted by WayneK on 2019/03/18 16:56
Could someone help me with what should be the very simple operation of copying an item with its subitems and pasting it into another database?  Just want the text to paste with no other field info required.
 
1) Select TLI (or select TLI and subitems - I've tried both)
2) Copy Special> 6 (selected items and their subitems)
3) Go to other database, select empty cell
4) Paste (ctrl-v)
 
Results:
 
a) A blank cell
(dialogue appears at bottom that says "Paste - 1 items were copied "  Why is it talking
about copying during a paste operation?)
 
or
 
b) A cell filled with HTML code
 
I've tried multiple combinations of copy / paste options, and read the manual, but still can't get it to work.
 
 
Wayne
9.111k

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?