Dynamics Community Forum Thread Details

How can I create a field that is a 6-digit randomly generated unique GUID in CRM?

I can't get my hands on the link right now but, there is a new feature that hasn't made it to the user interface yet allows you to create auto generated value fields. The six-character seems to go A9A9A9 -- alpha/numeral chain of 3. Here's the class I put together. You may want to search on some of the more unusual terms to find sources of greater explanation:

using System;
using System.Configuration;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using Microsoft.Xrm.Sdk.Messages;
using Microsoft.Xrm.Sdk.Metadata;
using Microsoft.Xrm.Tooling.Connector;
using System.Collections;

namespace consoleUtility {
    class AutonumberingFieldMaker {
        public AutonumberingFieldMaker(Microsoft.Xrm.Sdk.IOrganizationService CRMservice) {
            this.service = CRMservice;
        }

        private Microsoft.Xrm.Sdk.IOrganizationService service;
        private StringAttributeMetadata attributeMetadata = null;

        private string nbrFormat = null;
        public string AutonumberingFormat { set { nbrFormat = value;
                buildAttributeMetadata();
            } get { return nbrFormat; } }
        private string sname = null;
        public string SchemaName { set { sname = value; attributeMetadata = buildAttributeMetadata(); } get { return sname; } }
        private string dname = null;
        public string DisplayName { set { dname = value; attributeMetadata = buildAttributeMetadata(); } get { return dname; } }
        private int? len = null;
        public int? MaxLength { set { len = value; attributeMetadata = buildAttributeMetadata(); } get { return len; } }
        private string desc = null;
        public string Description { set { desc = value; attributeMetadata = buildAttributeMetadata(); } get { return desc; } }

        private StringAttributeMetadata buildAttributeMetadata() {
            if (null != nbrFormat && null != sname && null != dname && null != len) { 
                StringAttributeMetadata am = new StringAttributeMetadata() {
                    AutoNumberFormat = this.nbrFormat,
                    SchemaName = this.sname,
                    LogicalName = this.sname.ToLower(),
                    FormatName = StringFormatName.Text,
                    RequiredLevel = new AttributeRequiredLevelManagedProperty(AttributeRequiredLevel.None),
                    DisplayName = new Microsoft.Xrm.Sdk.Label(this.dname, 1033),
                    IsAuditEnabled = new Microsoft.Xrm.Sdk.BooleanManagedProperty(false),
                    IsGlobalFilterEnabled = new Microsoft.Xrm.Sdk.BooleanManagedProperty(false),
                    MaxLength = len
                };
                if (null!=desc)
                    am.Description = new Microsoft.Xrm.Sdk.Label(desc, 1033);
                return am;
            }
            return null;
        }

        public void CreateIn(string entityLogicalName) {
            if (null!=attributeMetadata) {
                CreateAttributeRequest req = new CreateAttributeRequest() {
                    EntityName = entityLogicalName,
                    Attribute = attributeMetadata
                };
                service.Execute(req);
            }
        }
    }
}

here's how I ran it twice:

AutonumberingFieldMaker cmAddr = new AutonumberingFieldMaker(CrmService);

cmAddr.AutonumberingFormat = "a{RANDSTRING:6}";
cmAddr.Description = "Autogenerated address number";
cmAddr.DisplayName = "adnbr";
cmAddr.SchemaName = "new_adnbr";
cmAddr.MaxLength = 8;
cmAddr.CreateIn("customeraddress");

cmAddr.AutonumberingFormat = "c{RANDSTRING:6}";
cmAddr.Description = "Autogenerated account number";
cmAddr.DisplayName = "cmAddr";
cmAddr.SchemaName = "new_cmAddr";
cmAddr.MaxLength = 8;
cmAddr.CreateIn("account");

Quick Links

Subscribe to this forum!