Ticket Number Solution

Hey all,

I’m working on an application that I’ve been building in Domino. It’s a Help Desk feature designed to streamline my organization’s Tech-Support process. The application compiles all “events” with their originations, their timelines, and their solutions.

In order to do this, each “event” is defined by a single comprehensive form. The data entered on this form is stored in various fields, and then presented in different views that identify certain features.

All this works very nicely, but this organization is enormous, and the amount of Support-related calls we get forces this application to handle rediculous amounts of “events.”

As dynamic as my application is, I’d like to add a ticket number to each form, allowing for faster identification. This will help the support department save time by not having to scroll through miles of support requests to find what their looking for.

I’d like to have a formula (or LotusScript) that will automatically add a number onto each form via computed text. Each time a new “event” is created, it will simply add 1 and thus create a new number.

If anyone has any idea how to do this your input will be greatly appreciated.

Thanks in advance!

Marc

Subject: Ticket Number Solution

There are plenty of answers regarding “Sequential Numbering” - search this forum as well as the R4-forum. This problem is almost as old as Notes itself.

The first question is: Will this application be replicated and will the replicas have the ability to create new events/support tickets? If so, then You can’t let the number be created instantly. This will cause numbers to be duplicated between replications. My suggestions is to create an agent that runs on ONE server alone that has the task to assign ticket numbers on each event/document that hasn’t been assigned a number yet.

If you absolutely need a ticket number instantly - then consider using the @Unique formula for creating something that reminds of a unique number to each new document. You will then not have a sequential number, but You will have the ability to identify each document - and isn’t that what You really want? Is the sequential numbering of importance?

I beleive that there is a document somewhere here on LDD that describes a solution to sequential numbering…

hth