For clarification, the term ?user? refers to the browser user. The term ?customer? refers to the notes designer's customer who wants the button to do the automation instead of depending on the user to copy/paste the correct email address from the Excel spreadsheet to the appropriate field on the main form.
Currently, a browser user displays the Excel spreadsheet via a button that opens another browser window on top of the main browser window. This secondary window is a document that contains an attached Excel spreadsheet. The user then dble clicks on the Excel spreadsheet to display the data. The user looks for specific data in the Excel spreadsheet ? usually a server name or empid. They then copy/paste the associated email address from another cell on the same row as the server name or empid in the Excel spreadsheet to a field on the form which is displayed in the primary browser window. The user then closes Excel which automatically closes the secondary browser window.
I need a button that a browser user will click on that will open the excel spreadsheet and prompt the user for the empid or the server name. It will then search for the associated email address in the excel spreadsheet and copy/paste this information into a field on the primary form displayed in the primary browser window.
The Excel spreadsheet cannot be an imbedded attachment on the main form that is displayed in the primary window of the browser. The customer needs to update the Excel spreadsheet within the notes client whenever needed. The customer will not be provided designer capabilities to detach and reatttach Excel spreadsheets on a form. They are only provided the capability to update the Excel spreadsheet via a document. The Excel spreadsheet is maintained in the notes client by the notes designer's customer and the document resides in a view the customer can access via the notes client. The url to display this document is what is used when clicking on the button on the main form in the primary window to display the Excel spreadsheet in the secondary window via the browser.
January 11, 2005 9:28 AM
January 13, 2005 11:00 AM