[How do I] Working with a (decreasing) Budget

Submitted by Tom on 2014/11/12 08:41
There's various possibilities here but I'll just give one example:
 
You have a budget of say, 5000
The available budget decreases as it gets used up - as you spend money and/or time.
 
Any tips here ?
A 'Budget' field could be an equation that subtracts the 'cost' columns from 5000.
But that solution seems to only work for one project then.
 
How could I do this for multiple budgets simultaneously ?
is there another way?

IQ loops/freezes on field defined using SQL SELECT

Submitted by Armando on 2014/11/06 16:18
Fields based on queries freeze IQ.
This was mentioned in this older thread to the  forefront  (IQ loops on field defined using SQL SELECT).
 
I hadn't used those in a while, but it happened 10 min ago and thought I should mention... even if only a few users are using those (they are quite powerful and helpful though!)
 
 
Here's the request that freezes IQ :
 
SELECT FirstName AS Responsable, IDItem FROM Adrsbook
 
All the above fields exist, of course.

HTML pane tab says "empty" when HTML pane contains images (exclusively)

Submitted by Armando on 2014/11/03 18:11
As the title says.

Also : could the ItemHTMLWordCount field be emptied when there's absolutely not content there (no image, no text...)? If I delete the only image contained in the HTML pane, ItemHTMLwordcount still = 0.
 
Emptying the ItemHTMLWordCOunt field would help with auto-assign equations (for example), as ItemHTMLWordCount is the only field one can rely on (as -- unless I'm mistaken -- ItemHasHTML doesn't seem to contain any real data and so it's not possible to rely on it to trigger any auto-assign equations).
 
Thanks a lot Pierre !

Application Hangs after ECCO import and Column / Field select

Submitted by richlove on 2014/10/31 16:47
 
I used the IQ import wizard, i.e., leave ECCO open and select the Notebook and Rows that I want to import, then hit "import", then wait. Then select the columns that I want to be showing in the grid, then HANG, (CRASH) !!!  The only thing I can do to exit this hang is to kill the process and restart IQ. 
 
Since at least 2010 this has happened everytime I have imported a data set or ECCO folder into IQ.   ECCO import is really dirty and buggy, and it needs to be fixed. 
 
I will recreate and reformat by hand multi-level hierarchies from ECCO Pro to IQ beta.  It is too much work. Creating them in ECCO is so fast and better than PowerPoint, MS-Word, Excel, and other products.
 
How disappointing, because I hoped again that IQ could help me with a better project outliner and task management system than ECCO.  Another 4 years until IQ

Documentation images in Sample DB (portable version)

Submitted by PIMfan on 2014/10/31 14:49
I posted something in the documentation area regarding the Portable version missing images in the sample DB documentation.
 
 
Not trying to cross-post, but after a week of no responses, just thinking I should have posted it here first.  Can anyone else verify that they are also not seeing the images as noted in the above link writeup?
 
Dave

Import Mapping Help needed

Submitted by richlove on 2014/10/30 10:56
A Help System Button and/or Wizard is needed for CSV, Tab-delimited, spreadsheet, and all Grid Import operations. 
 
I am trying to import a tab-delimited file.  I have not set up a "import field mapping file" yet. 
 
If my fields to be imported are not already defined, I cannot finish the import of those fields.  I must cancel the operation and set up the fields and try again. 
 
The "Import Step 2 : Field Mapping" dialog box needs to be able to just enter new fields to be imported, perhaps by putting them into bracks, e.g., [Hours_Est_Labor] and IQ will add this new field to the list, and allow the "Save as an import field mapping file" button to work.  This is not the case now. 
 
Right now I have to back out, set up all missing fields in the Field Properties Grid, and then go back and select them one by one. 
Subscribe to