Sequential Numbering has been difficult within NOtes for a number of reasons. the biggest problem is that multiple documents are created during the same relative time periods. It is better to use @Unique or a custom time stamp to create a tracking number for documents. If you allow users to generate documents on multiple replicas of an application, keeping the numbers sequential is almost impossible.
If you must use sequential numbering, I have found the best method is to keep track of the number in a profile document or similar unique document. When a document is created, don't get the next sequence number wait until the document is being saved. I prefer to use the QuerySave Event to get the current sequence number from the profile document, increment it and save the profile. The the incremented value can be used as the sequence number.
Dig Deeper on Domino Resources
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.