Accessing Large amounts of data contained in a spread sheet dynamically from within Notes.
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).
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.