Is there a quick and easy way to do a check on every field in the form to check for valid entries? When I talk about importing data, it could be anywhere from hundreds of documents at a time. Our existing agents will often run on anywhere from 500 to 1000 or more documents at a time. With the error checking, we'd like to take the ones that had bad values and move them to another view and continue on with the check without failing. Our platform is Windows 2000.
If the form has field validation, you could use the computewithform method of the NotesDocument class to validate the form.
The second solution calls for you to change your import to create a different form. Once the imported form is validated, it can change to the existing form and be processed by the other agents. You can have a validation agent run against the newly imported documents, changing the form if they are acceptable or opening the document with all the errors highlighted for correction.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Lotus Notes Domino Application Development
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading