create item

select text in item / right click / click link

drag / drop file from desktop onto lower right hand boxed text area that sez "you can drop an outlook object [...] here..."

program unexpected close

 

I know that's not where i'm supposed to drag / drop there but that's what it sez to do U &U this is what happens.

 

Also after creating link to file, if file location changes, link no longer functions, lies there like a lox & there is no error msg like "lost link / file moved" or something

 

bumping

 

--

Jan Rifkinson

Ridgefield CT USA

 

 

I am entering data with  "Item>Insert ...>Insert Tab" and the Field display in a slight different way based on just being there on the grid or activated for editing.

I have to make a choice: either adjust the text to look right on Edit mode or on just Display mode.

I'm assuming ItemHasHTML is hardcoded. If I create a field 'ItemHasURL' & give it the same properties it does not function the same way.

 

--

Jan Rifkinson

Ridgefield CT USA

I am working to generate reports in SQLNote trying to eliminate in part FileMaker.

I filter data by Dates. So far I can get the range that I need and I can see the Context Parents.

The challenge is that without the Upper Parent is not possible to establish the larger context of the report.

 

The Pivot table is not working because in this case we are using only 0ne Field with Sub-Items for everything except Numbers values and Dates.

 

It would be great to choose a Upper Context Parent "Level" so that we can be drill as deep as we need working with Filter on any Source Data.

Or maybe it can be done but I have really no clue after going around for a couple of hours.

 

I am trying different data structures to get what I need in order to migrate my databases into SQLNotes.

In one grid, I always get the :

"Error reading data : Check the source, filter and sort criteria"

whatever I write in the source/filter/source/"any other" bar. It can even be completely empty -- still get the error.

Tried a restart, tried a repair --> still get the error.

What could be the problem?

Anybody else had this problem before?

Pierre, hope you are feeling better & hard at work on the next release. Do you have an approximate release date so  I can stop bothering you about it? I could create a reminder in IQ calendar.:-)

 

--

Jan Rifkinsson

Ridgefield CT USA

How do I export or move a Grid ( with data) to another SQLNote file?

AND

Is it possible to have more than one file open at the same time?

 

Thank you.

I created a Grid with Projects and Times for each.

I use

1 - Clients [Parent to Projects]

2 - Projects [Parent to Tasks]

3 - Tasks

4 - Task Time

5 - Task Date

6 - etc.

I use SUM Parent > Children in Clients, Projects and Tasks so I can get the Totals for all Task related to each Project and Totals for all the Projects Related to a Client.

It works well, but when I use a Date Filter the SUM Totals are always the same.

 

Is it possible to SUM only Visible items?

First time here...

 

Finally found something useful. I am a MyInfo and FileMaker user and a previous EPIM also. I found this SQLNotes by sheer luck by looking for ECCO.

So I am trying to understand well all the facets of SQLNotes and the first thing that come up is "How to design a specific section for a specific task" because it seems that here you have more than several way of doing something either right or less right.

I think this could be the one.