I’m currently in the final stages of a larger project to develop a brand new Notes application and integrate it with an existing suite of lotus notes applications for a large global customer. We designed the application to work seamlessly with Excel, essentially using Excel as a user interface that most users are already familiar with. All of the data from Notes is opened into an Excel template and any changes are saved back into corresponding Notes documents automatically.

One of the main challenges with this application was in ensuring that all of the values(labels, drop down selections, etc.) be handled dynamically based on whatever language they need to be in for a given user, but also to save all of the data such that we can pull all of this data together and generate reports accross all languages/countries later. It is imperative that everything “just works” no matter what language the user speaks. This is something that we as a company have a lot of experience in.