OpenSesame: @DbLookup on spreadsheets
Fri 23 Mar 2007, 12:46 PMTweet
by Ben Langhinrichs
Copyright © 2007 Genii Software Ltd.
What has been said:
574.1. Carl Tyler (03/26/2007 03:44 PM)
This brings back memories, way back when I came over to the US to work for Lotus as SmartSuite Marketing Manager, I wrote a 1-2-3 addin for sales reps to demonstrate the powerful integration between 1-2-3 and Notes, it included the Notes LSX to do exactly this. Took about 3 hours of coding, but it worked a treat. I might even have a screencam of it somewhere, I'll have to see if I can find it.
574.2. Carl Tyler (03/26/2007 04:26 PM)
Doh, I am mistaken, I misread what you were doing. My addin worked the other way, you would put the dblookup directly in the spreadsheet as a 1-2-3 formula and it would query notes, you are doing it the other way and querying the spreadsheet.
574.3. Bill McNaughton (04/02/2007 07:06 PM)
Extremely cool. The idea of integrating spreadsheet data into Notes applications in this way will make it very easy to, for example, build picklist values directly from a spreadsheet, which is the format they are often stored in.