I have a Domino app that was designed for only Notes clients. Now I need to make it work on the Web and be accessible by customers so that they can create documents. I have two problems.
- There are picklists and DBlookups to validate information (i.e., system serial numbers from a systems database and customer info from another). How do I provide that functionality on the Web?
- I have to ensure the security of the systems and customer database (i.e., the lookup is needed, but I don't want customers to be able to access those two databases directly).
You should look at Webqueryopen and Webqueryclose agents. On a form you have these two Web events where you can execute an agent. These agents can either run with the priviliges of the Web user or with those of the signer of the agent. This is a property you set on the agent. Let the agents run with the priviliges of the agent signer, and let Anonymous have no access to your systems and customer databases.
To simulate the picklist, I would let a Webqueryopen agent write to a field that is to contain the list of available values that you want to present to the user. Webqueryopen agents are able to manipulate the fields of the document that are about to be displayed to the Web user. If the lookup has to be based on something that the user enters into the form, you will need to first display the form without the picklist, let the user enter what is needed to do the lookups and then let the form be submitted to the server and then displayed again, now based on what the user entered into the form.
Dig Deeper on Web Development for Lotus Notes Domino
Related Q&A from Jens Bruntt
Web Development expert Jens Bruntt offers suggestions on how to programmatically copy and hide attachments in Lotus Notes rich-text fields. Continue Reading
Learn about an add-on Domino developers can use to programmatically edit rich-text field tables from within the Lotus Notes client. Continue Reading
Web Development expert Jens Bruntt outlines three potential issues to consider when troubleshooting Lotus Notes Domino tabbed table problems. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.