Numerator Service

1. Introduction

The Numerator Service enables you to provide a unique ID for all new documents, tasks, emails, etc. created on a business module.

This feature is great for providing entities, documents, e-mails and many other items with unique identifiers. This can greatly help in identifying where items belong, as well as granting overview of items. The number sequences used with this service can also be customized to contain information such as the name of the parent of the entity (e.g. the company of a project), and the day, month and year of the creation of the item, and many more properties.

A use case could be a company that works with a lot of different projects and documents. Projects can be outfitted with a unique automatically generated ID, which can also be used on associated documents, in order to e.g. easily know which documents belong to which projects.


2. Requirements

There are currently no license requirements associated with the use of the Numerator Service feature.

3. Configuration

Configuration of the numbering service can be done from the WorkPoint Administration:

  1. Click the "Home" button of the WorkPoint solution.
  2. Click the cog icon in the bottom of the side panel to access to WorkPoint Administration.
  1. In the left side panel of the WorkPoint Administration, click "Numerator Service".

   3.1. Creating a number sequence

Creation of a new number sequence can be done by following these steps:

  1. In the Numerator Service settings page, click "Add sequence".

In this example, we will create a number sequence for the ProjectID field for each project in the Projects module. This helps automatically generate a project ID for each new project in a sequential manner.

  1. A title is provided for the sequence.
  2. For "Next number" a value of "1" is set. This is in effect what the first project ID from this sequence will be.
  3. The "Increment" value is set to "1", meaning that the "Next number" value will increase by 1 each time a new ProjectID is created using this number sequence.
  4. The "Mask" is probably the most complex aspect of the numbering sequences. The mask allows for configuration of what the result of the numbering service will be. As described in the user interface, an example of a mask of "[DD]-[MM]-[YYYY]-[####]" will result in an ID of "28-04-2016-0001". "[DD]" refers to the current day, "[MM]" refers to the current month, "[YYYY]" refers to the current year, and "[####]" is a number sequence, containing the value from the "Next number" field.

Other properties can also be used. In the example from the image above, "[wpParent]" is the first property of the sequence. "wpParent" refers to the parent business module of the item that this sequence is set up for. In this example, the ID of the first project of a company called "Advanced Bicycles" would be: "Advanced Bicycles-2019-0001"

  1. The "Reset next number on new year" checker can be checked if the value of the "Next number" field should reset when a new year begins.
  2. When the configuration of the sequence is complete, click the "Save" button.

   3.2. Using a number sequence

Using a number sequence requires it to be enabled on a business module. Working further on the example in section 3.1. we use the created number sequence on the Projects module of the solution:

  1. In the Numerator Service settings page, click the "Edit" button for the Projects business module.
  1. The numerator service is enabled for the Projects business module.
  2. The "Keep document number on move" checker can be enabled to make it so that documents only get a new ID when copied, not moved between document libraries. This setting is not relevant for this example, thus it is left unchecked.
  3. The "Use a number sequence on entities" checker can be enabled to use a unique ID from a number sequence for each entity in the business module. This is exactly what we want in order to be able to have each new project created have a unique project ID based on the number sequence we created earlier.
  4. For the "Number sequence", the sequence we created is selected.
  5. For "Number sequence field", we have to set the field on the project that should receive and contain the project ID. In this example, projects have a column called "Project ID", which we will use.
  6. We leave the rest of the settings as default (they can be configured in just the same way), and click the "Save" button.

In the Numerator Service settings page, we can now review the configurations:

4. End User Guide

In the list of Projects on the solution, we have created two projects for the "Advanced Bicycles" company. These can be viewed in the "Projects" list of the solution:

The numerator service that is enabled for the Projects business module works when creating a new project:

  1. Click the "New" button on the Projects list to create a new project.

As an example, the following project is created:

  1. The project is given a title of "Design of Bike0106".
  2. The Company of the project is set to "Advanced Bicycles".
  3. All other settings are left blank, and the "Save" button is used to finalize the creation of the project.
  1. As can be seen from the Projects list, the new project is given a Project ID based on the numerator service settings we configured in section 3.1.

Another example is shown below. Here a sequence has been set up to create a unique document ID for each document on every project. The ID consists of the title of the project that the document is associated with (in this case "Design of Bike0075"), and a number:

The result is that documents are easy to keep track of, and it is easy to identify which project a given document belongs to:

5. Notes

As exemplified previously, many different properties can be used in the mask of a number sequence. Typically used ones are:

Mask name Property
[DD] Current day
[MM] Current month
[YYYY] Current year (can be [YY])
[#] The value of "Next number" is inserted in this property of the mask (can have as many '#' as needed)
[Title] The title of the entity on which the item is created
[wpParent] Title of the parent business module of the created item. Other fields from the business module can be used, such as [Title] (title of the entity on which the item is created)
String of characters A string of characters can be used in the mask. E.g. "Project-[YYYY]-[##]" could result in "Project-2019-01"

The numerator service is typically used for providing unique IDs to entities, such as projects or cases, or for individual documents.

Have more questions? Submit a request