in the item field, hyperlink wasnt ticked
works now

hmmm
in my files grid, all the other fields at the moment are tick boxes,
guess I could create one for this - I'm sure I could find other uses for it too!

hmmm
in my files grid, all the other fields at the moment are tick boxes,
guess I could create one for this - I'm sure I could find other uses for it too!

If you drag-drop files, the system Fields FileName and FilePath are filled. Set FileName to a hyperlink if you want. You can use the item to add description, notes, etc

@Armando: HTMLExport bug has been found and is being fixed

@Armando: HTMLExport bug has been found and is being fixed

Great!!! 

durn
showed the FileName field, made it hyperlink, decided to hide it again,
was resizing columns and got
---------------------------
SQLNotes
---------------------------
Run-time error '9':

Subscript out of range
---------------------------
OK 
---------------------------
I can report it proper if you want but gotta go now
it restarted fine..

For those who use farr and would like to use google to search SQLNotes forum (it works well for stuff posted a few days ago, but not for recent stuff), I created an alias. Just use the "Import : paste preformatted alias group" feature in farr. In the alias window, right click --->"Import : paste preformatted alias group", and paste that :

1000>>>"Search SQLNotes Forum">->Google - $$1 | http://www.google.com/search?q=$$1 site:http://www.sqlnotes.net/Forums/ /ICON=icons\google.ico>+>^searchsqln (.*)

In the farr entry zone, just write "searchsqln " (with a space) and type what you're looking for.
You can change the "searchsqln ", of course (I chose "searchsqln " because the "search"  term is already assigned to a hotkey in my setup... and so I just need to type sqln after it.

[edit : added and alias file for those who'd prefer this : just download and put the file in your C:\Program Files\FindAndRunRobot\AliasGroups\MyCustom\ folder (in find and run robot's folder) ]

Congratulations Pierre : it works! 
I still don't know what it was, but you certainly do! 

What it was is the following:
The HTML Export will soon support email-merge. I was testing it before 0.9.22 release and decided to postpone it to 0.9.23 and instead added a context menu and email form to quickly generate emails.

Email merge will work much like the HTML template merge but will generate individual emails with personnalized information. I was testing different methods of generating emails and one of them used MSMAPI.OCX, a MS component to send emails. I had forgotten to include that control in the setup program, hence the form would not open. This is now fixed. Users must re-install using the setup program (no need to uninstall)

Quote from: PPLandry on February 19, 2008, 10:19 PM

Users must re-install using the setup program (no need to uninstall)

presume you mean just users that had problems ?

Correct, other had the control already installed (by some other program).

I'm looking at your error 9 right now, so an update is coming

Pierre, why do you require SQLNotes to have administrator privileges to be installed on a computer?  Why isn't PowerUser status enough?

Congratulations on this thread so far.  It has surpassed the Notetaking thread as far as number of pages (28!).  It might now be the longest thread on DC.  I think the topic is worthy!

I've got an organisational challenge

In my WorkDone/Billing grid, when the work is invoiced it gets an invoice number in the invoiceID field
My problem is with files which show in WorkDone/Billing grid,
They get an invoice number - fine - but this is just the first stage, the same files/drawings will be invoiced again for further work at least once.

How to give a file more than one invoice number in such a way that I can easily see

• when it was last invoiced
• all files under say invoice #200

one answer would be to have a field for each invoice but that's not good I think
(or maybe if I had "invoiceID1", "invoiceID2" etc where I could add any invoice numbers - seems too messy..)

another way is simply to give it a second parent (i.e. Invoice#200) and hide that mostly somehow
not sure then - I guess just show two or more numbers in the invoiceID field

if you think there's a better way, shout...
or if it's too difficult I can use another method to keep track of which files sent with which invoice

So, like you suggested, there are basically 3 choices : 1- for each item, either write your different invoice numbers in different invoice fields, 2- or all in the same invoice field, 3- or... the "parent" way, which could work well.

Multiple (number) fields might probably a good way to sort (ascending, descending, etc.), etc IF your invoice numbers are... numbers only (but I see that you have a SO01, a mix of numbers and letters -- OK that was in the sample grid...  ).

The "parents way" looks good to me (probably the bes)... Well : each work could be a parent, and its subitems would correspond to multiple invoices. You'd have only one invoice field, and it would be easy to sort all invoices in "flat view" or even "hierarchical view", depending on your needs. You could have the itemparent field to be displayed in your grid if you choose such a way : it might facilitate seeing which invoice goes with which work (in flat view, for example...).

In any case, you might also have to create a date field called LastInvoiceDate (or whatever), that you'd edit yourself each time you add a new invoice (you could also just rely on the "itemCreated" field if you use the "Parent" way.)


IF you don't want to create a new field for each invoice or use the parent way maybe you could try to type the different invoice numbers in the same field, as you suggested? (And also, of course create the date field called LastInvoiceDate that you'd have to edit yourself each time you add a new invoice.)

For that way you'd have to :

1- Create a  Invoice multi-line and text field (in the "Manage field" window),
2- Create a LastInvoiceDate date field

Close the grid and reopen it to be able to activate the multi-line field (I believe that it's a bug in the Grid component)

Now, you could write each invoice number bellow the previous one (write the first one, shift+enter, then the other one, etc.), and maybe add a prefix to these numbers like : "a-", "b-", etc. (so you'll be able to easily find all "b" invoices, and see how many items have been billed 2 times, etc.

Sorting and filtering ?

--> Use a field-column filter to see specific invoice # : *b-*,*200*, or whatever...

--> Use the filter/source bar to see specific invoice numbers.

ie :
- Invoice alike "a-%" (will show all items-invoices starting with "a-")
- Invoice alike "%-2%" (will show all items-invoices starting with "-2")

[edit : before, i wrote category instead of invoice!!!! sorry : i was thinking in terms of my own grid!]

with this way, I don't think that it would be feasible to sort your invoices or items by number.

You're welcome!

PS you've given me a few good tips on searching & other stuff there

Good! But I'm sorry, nevertheless... about the mistake in my previous post where I wrote :

- category alike "a-%" (will show all items-invoices starting with "a-")
- category alike "%-2%" (will show all items-invoices starting with "-2")

I meant INVOICE, not category (which is the field/column you want to filter)... I was thinking in terms of my own grid... 

BTW, you can get a lot of filter ideas by using the find feature (ctrl+f). You can also "direct" your searches inside a specific grid context and see the results in the very same grid by using the "source view" and "results in" zones. (in that case, just be careful if you've already set up nice filters that you like : they'll vanish, being replaced by the present search, hence new filters -- what I do is save filters I like for all my grids in a special grid named "filters"; in that grid, filters are organized hierarchically, by grid names and filter types (following the source bar UI) : source, filter, sorting).

EDIT/
* in "WorkDone" I have files as Parent items but wont give them InvoiceIDs themselves
i.e. File has subitems that are given invoice number
- SQLNotes01.psd
- - Drawing of same - 2hrs - Invoice#200

Exactly. This is how I was imagining the structure.