OpenSesame: @DbColumn on a spreadsheet
Thu 22 Mar 2007, 11:58 PMTweet
by Ben Langhinrichs
Another one of my "projects" as part of OpenSesame (see earlier post on Edit view in spreadsheet) is the ability to do an @DbColumn or @DbLookup on an OpenDocument spreadsheet in Notes 8. This is what I have working tonight::
Colors := @DbColumn("OpenS"; "c:\\temp\\trial.ods"; "Sheet1"; "F4-F999");
Colors := @Implode(@Trim(@Unique(Colors)); ",");
@Prompt([Ok]; "All Colors"; Colors);
gives a result of:
with the spreadsheet:
Copyright © 2007 Genii Software Ltd.
What has been said:
586.1. Tim Tripcony (03/22/2007 10:43 PM)
Whoa. Now that's cool. Just curious, are you anticipating that UNC paths will be supported for the file location?
586.2. Ben Langhinrichs (03/23/2007 03:31 AM)
Certainly. They work now. I just tried
@DbColumn("OpenS"; "\\\\hamster\\cdrive\\share\\trial.ods"; "Sheet1"; "F4-F999");
and it works fine (\\hamster being a shared network drive here where I copied the file). Watch for the parameters possible for @DbLookup, as I think they are very cool (Rocky Oliver helped me think them up).
586.3. Ben Langhinrichs (03/23/2007 04:41 AM)
I should also point out that when this ships, it should also work with an attached ODS file, probably with the syntax:
@DbColumn("OpenS"; @DbName; @DocumentUniqueID; "MyInvoice.ods"; "Sheet1"; "F4-F999");
and there may be other variations. It is just likely people would want to act on an attached spreadsheet.