Updated equation/rules docs

Submitted by reesd on 2009/02/10 14:34
I did some revisions of the equation/rules documentation (http://www.sqlnotes.net/drupal5/index.php?q=node/128) including moving some of the information over from fields (http://www.sqlnotes.net/drupal5/index.php?q=node/68). To be honest I had even more done that I lost when I accidently hit Cmd-Left which lost that set of changes (argh!). Something I really need to get fixed in Firefox on the Mac.
 
One gap in my knowledge and therefore in the documentation is updating. Could someone summarize for me how updating works for row/hierarchy equations and how is is affected by the Update button and Auto-Update checkbox?
 
One other question is terminology, I tried to line up the names between the screenshot, fields doc, and equations doc by going with the following. Let me know if we should tweak these names more.

import/export/sync outline depth

Submitted by reesd on 2009/02/10 12:11

I would like to recap the need for importing or synchronizing outline depth. It was covered in the old forums, but I would like to summarize here in the new forums and also push for my lighter approach listed below be in 0.9.25 (rather than 0.9.26 as currently planned). For reference, also see http://www.sqlnotes.net/drupal5/index.php?q=node/257 for some discussion on importing/exporting depth.

 

Import (and sync which uses the same underlying mapping approach) is quite powerful in IQ, but its missing one key piece of information - the items depth in the outline. There are three ways of indicating depth that could be used. I will use the following simple outline in my examples:
A
  AA
    AAA
  AB
B
  BA

 

Equivalent to a "Lookup" Function?

Submitted by srv181 on 2009/02/08 10:52
Is there some way to populate the content of a popup list for a field with values from another grid?
Access has a function to do this (I believe it is called dblookup - or so).
 
I need to assign tasks to contacts. I know that one could use the parent/hierarchy functionality but that is too tedious - just too many steps to go through. It would be so much simpler to be able to populate the content of the popup with some field from another grid.
 
Is anyone doing something like this?
 
Thanks

The state of the documentation .SNDB 2-5-09

Submitted by KeithB on 2009/02/05 20:47
I grabbed all the current pages of the user manual, and put them into an IQbase for my purposes. I'm attaching it here, others might be interested.  It was done quickly with the web capture (which is REALLY nice, by the way).  Also I tried to make a new blog post for this, but couldn't figure out how to make an additional one.
 
I'm using it to ascertain the obvious gaps  in the material, as well as check if I missed any comments.  (Is anyone else overwhelmed at times with all the postings/comments on this site?).
 
I set it up in a nice hierarchical structure, which may be instructive to beginners, also.
 
It sure is nice having an "offline" manual here; this will be a taste of what the "finished" version will be like.
 
 

item color not displaying -- have to refresh

Submitted by Armando on 2009/02/03 23:39
I'm using user code to automatically assign colors to my items (allows me to use conditions based on strings, etc.). e.g. :
 
  if (isnull(Urgency) and item = "Notes") or (Urgency < -10 and item = "Notes") then
    CalcColor="Pink"
  end if
 
etc.
 
"Pink" truly appears as the "itemColor" color, but, sometimes, unless I do a refresh, the color won't display in the grid.
 
Is that a bug? or am I omitting something ?
 
thanks
 
 

"Building Blocks"

Submitted by jsolka on 2009/02/03 12:03
I've just started using word 2007 and I realy love Building Blocks. It's a really user-friendly, veru useful (at least for me), and cool feature with nice UI. Maybe it's far-fetched, but it would be great to have something similar in IQ.