CloudEvolv Web Site

Key Benefits of the Auto-Number Generator

The Auto-Number Generation Tool tool is a solution that can be added to any Dynamics 365 business applications or Power Platform model driven solutions. It allow developers and configurators a way to customize sequential number generation that goes beyond the Power Platforms current out-of-box capabilities.

If you have ever needed to build a sequential numbering system that relied on captured data elements likedates, codes, lookups and other parameters, this tool is the right choice.

Data-Driven

Using data elements you select you can generate sequential numbers that reseed based on several input parameters.

Flexible

You can implement this solution on an unlimited number of custom and out-of-the-box entities, each with different configurations.

Extensible

Stage and validate your applications metadata before triggering the auto-number generation using workflows.

Online Documentation

Auto-Number Generator Documentation

Getting started with the Auto-Number Generator utility is easy using the documentation provided below. Learn how this solution can help your organization implement robust, consolidated auto-numbering and sequencing strategies.

Overview

Providing end-users with a meaningful and readable unique identifier has always been an important aspect in developing business applications. Building on the Auto Number attribute, introduced to the Power Platform in release 9.0 this tool allows customizers a way to embed record data into the process of generating sequenced numbers.

Check out the video series below and see how our solution can help your organization implement a robust, consolidated sequential auto-numbering strategy.

Releases

Version 2.1.2 (Latest)

Release Notes

  • Add syntax similar to that found in the Auto Number Manager for XrmToolBox (see below).

All Previous Versions

All previous versions of this tool were developed and maintained for specific clients. This is the first version that has been created using a polymorphic approach. Polymorphism refers to the ability of an object to take on multiple forms or behaviors. This means a single interface or method can be used to work with different types of objects, making code more flexible and reusable.

Formatting Rules and Syntax

Auto-Number Generator Syntax

  • Sequential number: {SEQNUM:n} where n is the minimum number of digits.

  • Random text: {RANDSTRING:n} where n is the number of characters in the random string. Maximum value for n is 6.

  • Date/time: {DATETIME:fff} where fff is a standard datetime format string. See Microsoft's .NET documentation on Standard Date and Time Format Strings.

  • Other text: Any other text may be included in the number format. This text will be used as is.

Samples

Number Format

Example value

TEST-{CODE1}-{SEQNUM:3}-{CODE3}{RANDSTRING:6}

TEST-SIC-065-ELM-AB7LSF

CAR-{SEQNUM:3}-{RANDSTRING:6}

CAR-123-AB7LSF

CNR-{RANDSTRING:4}-{SEQNUM:4}

CNR-WXYZ-1000

{SEQNUM:6}-#-{RANDSTRING:3}

123456-#-R3V

KA-{SEQNUM:4}

KA-0001

{SEQNUM:10}

1234567890

QUO-{SEQNUM:3}#{RANDSTRING:3}#{RANDSTRING:5}

QUO-123#ABC#PQ2ST

QUO-{SEQNUM:7}{RANDSTRING:5}

QUO-0001000P9G3R

CAS-{SEQNUM:6}-{RANDSTRING:6}-{DATETIMEUTC:yyyyMMddhhmmss}

CAS-002000-S1P0H0-20170913091544

CAS-{SEQNUM:6}-{DATETIMEUTC:yyyyMMddhh}-{RANDSTRING:6}

CAS-002002-2017091309-HTZOUR

Microsoft Documentation

Full SDK documentation is available here: https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/create-auto-number-attributes.