Accessing Large amounts of data contained in a spread sheet dynamically from within Notes.
Posted on 2004-04-29
We have a internal product request system in Lotus Notes. At the moment the only way we have of looking up products is to post a spread sheet (obtained from another old system) in a Notes Document and provide a link in the application form to the spread sheet doc. This requires the user to follow the link then launch the spreadsheets and then type thier product number to get the product details which then have to be copied back into the original document.
This is quite a tedious process and obviosly not ideal. I'm looking for a way to somehow automatically lookup the details when the produuct number is entered. Either somehow geting the data from the spread sheet into Notes in an easy manner on a rountine basis (There is a lot data though!) or providing a lookup to the spread sheet (which can be updated easily enough).
Ps I've been generous with the points! ;-)