auto (interval) backups are not working (FIXED 0.9.25W3)

Submitted by reesd on 2011/10/29 18:44
Users, please note that auto-backups are NOT working.
 
This is now confirmed by Tom below. I am highlighting this because nothing is worse than having an issue and then  realizing your data is not being backed up. Until this is fixed you may want to setup an alternative backup strategy (which is probably a good idea in general). 
 
"Create backup on close" IS working. So you probably want to make sure that is at least turned on.
 
I have auto-backup set to every 60 minutes, but that seems to have stopped working sometime in the last few weeks. I have a backup for midnight for last night around midnight, but none before that for several weeks til 10/13.

field equation

Submitted by jan_rifkinson on 2011/10/28 13:24
In field equations I want an item to change to a specific color if two criteria are present
 
If item is bold
and
if item is assigned to field daylogs
 
I'm assuming this belongs in daylogs field equation (or should it be in item field equation?.
but don't know the syntax.
Any help would be appreciated.
Thank you.

Add Caption column to Add/Remove Columns dialog (ADDED 0.9.25W3, TWEAKED 0.9.25W4)

Submitted by reesd on 2011/10/27 17:34
Minor, but I think useful tweak.
 
Could you add a column for the field's Caption value to the Add/Remove Columns dialog (like the Description column you already have)? That would be helpful since "Caption" is really "column name" and columns are what we are adding/removing - so we are thinking in terms of column names not field names (which can be pretty different).
 
Thanks,
d

use parent's fields in column equation

Submitted by reesd on 2011/10/27 17:24
As discussed at http://www.sqlnotes.net/drupal5/index.php?q=node/2070#comment-9119, you can do something like the following to use more than one field of your children in your column equation.
 
Parents = mySum(IncludeField, children)

Function mySum(IncludeIt, x) ' Calculates the sum of the array x if IncludeIt is true
  dim d, i

  d=ubound(x)
  for i=0 to d
    if IncludeIt(i)=true then mySum = mySum+NZ(x(i))
  next

end Function

Show "plus/minus"-signs for collapsing/expanding

Submitted by mca1 on 2011/10/10 06:48
Hi there,
 
meanwhile I used IQ for about 2 month now and every day I am more impressed about the power under its hood.
 
The possibilty to modify the UI to certain degrees is very nice. What I would like to achieve by now is showing the typical "plus/minus" signs inside the grid instead of the ecco-like-buttons or that big black triangles.
 
I've seen screenshots in the online manual that included a very nice looking clean interface with those plus/minus signs.
Is there a way of modification to get them?

Filter in the sourceBar with a "Today"-Date

Submitted by mca1 on 2011/10/09 12:05
Hi there,
 
I need help with the following configuration:
 
I have a grid that is about to show...
a) all entries that have a checkmark in a specific yes/no - field
PLUS
b) all entries that have a date earlier than today in a specific date - field
 
 
I tried to set up a filter in the sourcebar like this
"PreSelected is not null"
to fulfill my first requirement. That works fine.
 
Now an extension like
"PreSelected is not null OR DTStartPlanned < Today
 
doesn't work.

Date entry problem in Property Pane

Submitted by Jon on 2011/10/01 17:40
Using W1.
 
1. In Property Pane, go to Forms. The form has to be long enough to scroll and the field in question needs to be toward the bottom of the form. The field in question also has to be a date field.
2. Click in the field, then the down caret to open the calendar. See what happens? The form field scrolls to the top.
 
This does not happen all the time, but it does happen frequently enough to be annoying.
 
Jon
 
EDIT: I see this happening sometimes when I first use the calendar to enter a date. However, it always happens if, after entering the date once, I change the date. So the steps to reproduce are the same as above, an if you don't see the Property Pane scroll to the top, repeat step 2.

Making "Shown In" available in fields

Submitted by jan_rifkinson on 2011/10/01 13:42
I had a use for this in a view I've created & thought I could add column "Shown In" like you see in search results but it didn't appear in fields so I guess it's not available. Is there a reason for that, am I missing  something, is it possible or does this replicate the discussion about a "home" column?  I see ItemHomeGrid but I don't know how it's populated? That might cover my needs but it's a mystery to me.  Thanks.